CSV merger
Combine two CSV tables, aligning columns by their headings.
Bookmark this page
Keep this page handy for next time.
- On a computer
- Press Ctrl + D, or Command + D on a Mac.
- On a phone or tablet
- Open your browser's menu or Share menu and look for Add Bookmark, Bookmark or Add to favourites.
A bookmark saves the page link. Save any tool results separately.
How to use this tool
- Paste two tables with unique column headings.
- Columns are aligned by their exact header names, regardless of order.
- Columns present in only one table are retained with empty cells for the other table.
Things to know
- Processing happens on your device. Check the result before replacing your original data.
- Each CSV input accepts up to 25 MiB, 100,000 data rows, 10,000 columns and 1,000,000 cells. Expanded tables also count empty cells.
- Generated CSV text is limited to 25 MiB in total, including all split files.
Task guides
You might also need
More in data & csvCSV joiner
Join two CSV tables on a shared key using inner or left joins.
CSV transpose
Swap the rows and columns of a CSV table, including its heading row.
Venn diagram maker
Compare two lists as sets and create a Venn diagram showing shared and unique items, with SVG and CSV downloads.
CSV splitter
Split CSV data into smaller files while repeating the original headings.
CSV column organiser
Select, reorder and rename CSV columns.
CSV viewer and editor
Inspect CSV as a table and edit an individual cell by row and column.
CSV deduplicator
Remove duplicate CSV records using all columns or selected key columns.
CSV row filter
Keep CSV records matching text or numeric conditions in a selected column.
CSV sorter
Sort CSV records by a named column while retaining all row values.