Combine exports without mixing up columns
CSV Merger appends rows from multiple comma-separated files. It matches columns by their exact header names, so a file with name,score can be combined with a file containing score,name. The first file determines the output column order. All inputs must contain the same set of unique, nonempty headers.
Merge CSV files
- Use Choose local files to select at least two UTF-8 CSV files.
- Check the displayed list. Use Move up and Move down to arrange the files; rows are appended in that order.
- Choose a CSV export mode. The default preserves cell strings.
- Choose Merge CSV files, inspect Result, then choose Download CSV.
The result includes one header row. Original files remain unchanged. Selecting different files removes the previous result and download link. Moving a file changes row order; moving another file to the first position also changes which header order the result follows.
A reproducible example
Select Load sample CSVs (replaces files and export mode) to try the example without preparing files. It loads two synthetic CSVs and selects Preserve cell values (default). Your current result is cleared; select Merge CSV files to produce the output. Your original files on disk are not changed.
Save these as two UTF-8 files:
name,score
Ada,10
score,name
12,Lin
The merged rows are Ada,10 and Lin,12, under name,score. Output cells are quoted, so the downloaded representation is "Ada","10" and "Lin","12". Quoting does not change these cell values.
Supported CSV and export behavior
Quoted commas, doubled quote characters, multiline quoted fields, CRLF and LF line endings are supported. A UTF-8 byte-order mark is accepted. The parsing rules follow the familiar quoted-field conventions described in RFC 4180. Semicolon-delimited exports and Excel workbook files are not CSV inputs for this tool.
Preserve cell values (default) retains the parsed strings, including -10, +12 and formula-like text. CSV quoting and line endings are normalized, so this preserves cell values rather than the original file bytes. A spreadsheet can interpret formula-like strings when opening the file.
Choose Protect formula-like cells when you want an apostrophe added before values whose first non-whitespace character is =, +, - or @. This includes headers and negative numbers: -10 becomes '-10, deliberately changing the cell string and potentially importing it as text. The warning beside the export mode explains the change before processing. Inspect the downloaded CSV for your intended application; this is not a guarantee about every spreadsheet application's import settings.
Limits and troubleshooting
Choose 2–20 files. Each file can contain at most 800,000 bytes and 200,000 characters; the combined limits are 4,000,000 bytes and one million characters. There may be at most 200 columns and 10,000 combined data rows. Every row must have the header's number of cells. UTF-8 decoding errors, duplicate headers and mismatched column names stop the merge rather than silently drop data. Header matching is case-sensitive and preserves spaces.
The merger does not remove duplicate records or sort rows. To keep only selected columns afterward, use CSV Column Selector. To turn the result into structured records, use CSV to JSON.





