Loading…

How to use CSV Merger

Load or paste two or more CSVs, choose union or intersection of columns and whether to add a source column, then preview the merged table and download it.

Frequently asked questions

What if the files have different columns?

Choose union to keep every column that appears in any file, filling missing values with blanks, or intersection to keep only the columns that all files share. Union is safer when you do not want to lose data; intersection gives a tidy rectangular result.

Does column order have to match?

No. When matching by header name the tool maps each file's columns onto the merged header by name, so a file whose columns are in a different order still lands in the right places. Positional stacking is available too if your files have no headers.

Can I tell which file each row came from?

Yes. Turn on the source column and every merged row gets an extra field naming the file or block it came from, which makes it easy to trace a record back or to filter one source out later.

More Charts & Data Tools

CSV Column Extractor
Pick, reorder and rename the CSV columns you want to keep, then export a tidy new CSV containing only those fields.
CSV to JSON Converter
Convert CSV to a JSON array of objects and JSON back to CSV, with typed numbers, a live table preview and one-click download.
CSV Transposer
Swap the rows and columns of any CSV so records become fields, with a live preview and a download of the transposed file.
Summary Statistics Calculator
Get count, sum, mean, median, mode, min, max, range, variance, standard deviation and quartiles for every numeric CSV column.
Pivot Table Builder
Build a pivot table from any CSV: choose a row field, a column field, a value field and sum, count, average, min or max.
Frequency Counter
Count how often each value appears in a chosen CSV column, with percentages, a mini bar visual and a copyable results table.
Bar Chart Maker
Turn pasted numbers or a CSV into a clean labelled bar chart with gridlines and value labels, then download sharp SVG or PNG.
Line Chart Maker
Plot one or many data series as a line chart with nice axis ticks, a legend and optional smoothing, and export SVG or PNG.
Pie Chart Maker
Build a pie chart from labels and values with percentage labels, a legend and six colour themes — download as SVG or PNG.
Donut Chart Maker
Create a donut chart with an adjustable hole, a centre total and percentage labels, then export a crisp SVG or a PNG image.
Area Chart Maker
Draw filled area charts from your data, stacked or overlapping, with gridlines, a legend and one-click SVG or PNG download.
Scatter Plot Maker
Plot X against Y as a scatter chart with auto-scaled axes, adjustable point size and an optional trend line; export SVG or PNG.

← View all Charts & Data ToolsBrowse all 1,100+ tools →