CSV Merge
Add the monthly files, the regional files or the weekly exports, and get one table with every row. Columns are matched by their names, so the order in each file does not matter.
Drag files here or choose them
Worked examples
Two files, one extra column
January: Name,Sales / Ann,120 February: name,Sales,Region / Cara,95,North
Name,Sales,Region Ann,120, Cara,95,North
Columns were matched by name, so name and Name are the same column. Region is added, and Ann's row gets a blank.
About CSV Merge
Reports are often delivered in pieces: one file for each month, one for each branch, one for each week. To analyse them you need one table. This tool stacks the files one under another, matching columns by their names, so it does not matter if the files list their columns in a different order or one file has an extra column.
Add the files, or paste a table, and the combined result appears with a count of the rows each file contributed and the new columns it brought in. Columns that only some files have are added with blank cells for the others. You can add a column that says which file each row came from, which is very useful when the file name holds the month or the region.
How to use CSV Merge
- Choose or drop your files. Add as many as you need, in the order you want the rows to appear.
- Choose whether to match the columns by their names or by their position.
- Tick the box to add a Source column if you want to keep track of the file each row came from.
- Download the combined file or copy it.
Common uses
- Joining twelve monthly exports into a year
- Combining branch or regional reports
- Building one import file from several partial ones
- Stacking survey results saved in separate files
Frequently asked questions
Do the files need the same columns?
No. When columns are matched by name, a column that only one file has is added to the result, and the rows from the other files get a blank cell there.
Is the match on column names case sensitive?
No. Sales and sales are treated as the same column, and spaces at the ends of names are ignored. The spelling from the first file that has the column is used.
When should I match by position?
When the files have the same layout but the column names differ or are unhelpful. Column 1 is stacked on column 1, column 2 on column 2 and so on.
Can I join files that are side by side instead?
That is a different job, called a join. Use the join tool to match two tables on a key column and bring across the columns you want.
How many files can I add?
There is no set limit. The practical limit is the memory available on your computer, which is comfortable for hundreds of thousands of rows in total.