Merge CSV files
Merge CSV files or texts with matching headers. Align columns, preserve every row, preview results and download CSV locally in your browser.
CSV sources
Files and content are processed in this browser only. Comma-separated UTF-8 CSV is supported.
Public examples merge 3 data rows on the first run.
Format and limits
Each input: 1,000,000 bytes, 10,000 rows including headers and 10,000 characters per cell. Batch: 10MiB, 100,000 cells and 100 columns. Headers must be unique, not whitespace-only, and match exactly including case and spaces. Convert other encodings to UTF-8 first.
Merged result
No result yet.
Preview shows the first 20 rows. Download includes all rows. Selection order and source row order are retained, including duplicate rows.
Export uses UTF-8 with BOM, quoted fields and CRLF, up to 2,000,000 bytes. A tab is prefixed to formula-like values and headers to reduce spreadsheet execution risk. Displayed values may change; this does not ensure safety in every app.
Instructions and example
The first public input contains rows 001 and 002; the second contains row 003 with columns in a different order. Merge produces 3 data rows ordered as id, item, amount. You may also select 2–20 UTF-8 CSV files; later columns align to the first header. Duplicate rows and leading 0s remain, with no date or number inference. Preview shows up to 20 initial rows; download includes the complete result.
Frequently asked questions
Can I merge different columns?
Column order may differ, but header sets must match exactly. Case and spaces matter. Blank or duplicate names and ragged rows are rejected. Missing columns are not filled and rows are not joined by a key.
Can exported values look different in a spreadsheet?
A tab is prefixed to formula-like values and headers. Export also uses a UTF-8 BOM, quoting and CRLF. Protection may change displayed values and cannot prevent formula execution in every app; inspect import settings and results.
What are the size and encoding limits?
Only comma-separated UTF-8 is supported. Each input allows 1,000,000 bytes, 10,000 rows including headers and 10,000 characters per cell. The batch allows 10MiB, 100,000 cells and 100 columns. Export is at most 2,000,000 bytes including BOM and protection.
Calculation criteria and reference materials
- IETF RFC 4180 — CSV quotes
Citation handling for fields containing commas, newlines, and double quotes
Verification of calculation criteria: · Calculation·verification principles · Report errors