Merge CSV files
This tool joins several CSV files into one, which is what you need for monthly exports from the same shop, customer lists pulled from two systems, or one file per region that really belong together. Files are joined in the order you choose, and columns are matched by the name in each file's first row rather than by position, so files whose columns differ or arrived in another order still line up correctly. A column one file does not have stays empty in that file's rows. Merging runs in your browser, and your files are never uploaded.
Runs in your browser
Drop your files here
CSV, up to 50 MB each, 30 files at most
How it works
- 1 Choose at least two CSV files and put them in order.
- 2 Choose the delimiter the files use.
- 3 GRID16 merges them in your browser.
- 4 Download the result.
Questions
- How many files can I merge?
- At least two, and up to 30 CSV files in one job. Each file can be up to 50 MB, and all files together up to 100 MB.
- What happens when the files have different columns, or in a different order?
- Columns are matched by the name in each file's first row, exactly - case and spaces count, so "Email" and "email " are two different columns. A column a file does not have stays empty in that file's rows. The result's header lists every column in the order it first appears, starting with the first file.
- What if my files use different delimiters?
- One delimiter is used to read every file and to write the result: comma, semicolon, tab or pipe. Choose the one your files actually use; a job cannot mix delimiters between files.
- Does the file need a particular encoding?
- Files are read as UTF-8. A file saved in an older Windows encoding is reported by name instead of being merged. A byte order mark at the start of a file is kept in the result, so Excel still reads umlauts and accents correctly.
- What if a file has no header row?
- The first row of every file is taken as its column names, so a file without a real header only merges cleanly when its first row matches the others' header exactly.
- Is my file uploaded to a server?
- No. Merging happens in your browser; the files never leave your device.