Merge CSV Files

One table from many CSVs

Monthly order exports, sales files from each branch in the same format, survey results downloaded in batches — data split across files is hard to analyze. Drop them here and they're stacked into one table, matching columns by header name. Different column orders or extra columns in some files don't shift anything.

Matching columns

• By header name — collects every header from all files and places each value under the matching name. Missing columns stay blank. Headers must match exactly (“Amount” and “Amount ($)” count as different), so align names first.
• By position — for files without headers, or with inconsistent names but the same column order. The first file's headers are used, and files with a different number of columns are flagged.

Handy options

The “Source file” column shows where each row came from, so you can filter by month or branch later. “Remove exact duplicate rows” drops repeated orders from exports with overlapping date ranges. Files with different encodings are detected automatically, and for Excel files the first sheet is used.

Download the result as a UTF-8 CSV (with BOM, so Excel opens it cleanly) or as .xlsx. Values with leading zeros stay as text. Files never leave your device.