UtilityPilot.Find a tool

Data & Tables

CSV Merge

Append several CSV exports under one header. Check that column names and ordering match before combining their records.

Processed in your browserPrivacy details ↗

5 MiB per input · 50,000 records · 200 columns

Adjust your options

Spreadsheet-safe export can change formula-like cells by adding an apostrophe. Turning it off preserves raw values; use raw exports only in a trusted importer.

No sign-up. No upload.

How to use this tool

  1. Choose two to ten CSV files, or paste two inputs.
  2. Order the selected files and choose their shared delimiter.
  3. Merge; review the per-file record counts and download the combined file.

How the operation works

Merge appends data records in input order and writes the first header once. Every file must have identical header names in identical order. A header-only file contributes no data rows. Up to 10 MiB combined input and 50,000 output records are supported.

Identical headers are required

Every file must have identical header names in identical order. Merge appends data records in input order and writes the first header once. A header-only file contributes no data rows. Schema mismatches are blocked instead of silently filling or dropping fields—this prevents accidental data loss when two exports differ by a column.

Align differing files first with CSV Column Editor (rename, reorder, drop), then merge the adjusted files.

Ordering and counts

Files are merged in the order you arrange them. The result shows per-file record counts so you can reconcile against source row counts. Up to 10 MiB combined input and 50,000 output records are supported. Up to ten files can be selected, or two pasted inputs.

File A: id,name · 1,Ada
File B: id,name · 2,Sam

Merged:
id,name
1,Ada
2,Sam

Appending is not a join

Merge concatenates rows; it does not match keys across files like a database join. Duplicate keys across files remain duplicates—deduplicate afterwards with CSV Deduplicate if needed. Shared headers do not imply shared business meaning; verify counts and sample rows after merging.

Safe merge workflow

1) Inspect each file in CSV Viewer. 2) Align schemas in Column Editor. 3) Merge and review per-file counts. 4) Deduplicate or split if the importer needs batches (CSV Split). 5) Re-open a synthetic merged file in the destination before processing a larger batch.

Keep originals. Merging does not remove duplicates or normalize values.

A worked example

File A: id,name
1,Ada
File B: id,name
2,Sam

id,name 1,Ada 2,Sam

Appending is not a database join. If one file has name,id while another has id,name, reorder it with CSV column editor first. Merging does not remove duplicate records.

What merge requires from each file

Merge appends records; it does not match rows by a shared ID. Both inputs must use the same delimiter and be readable under the selected header rule. Column order and header names must agree, because the output has one header row and one column order. A file with an extra, missing or renamed column is a structural mismatch and should be aligned first with CSV Column Editor.

Leading byte-order marks, quoted newlines and blank records are handled by the parser, but they can still hide a mismatch from a quick visual check. Inspect both files with CSV Viewer before merging, especially when one export came from Excel and the other from a database.

A safe merge checklist

  1. Open each file and confirm the delimiter and header setting.
  2. Compare header names and their order.
  3. Merge a small sample first.
  4. Re-open the result and check the first and last record from each source.
  5. Deduplicate only if duplicate rows are genuinely unwanted; identical IDs can represent different events.

Merge is not a database join. If you need to attach columns by a key, join on the key inside a database or spreadsheet, then inspect the result for unmatched and duplicated keys. The record ceiling and 5 MiB input limit apply to each file.

Processing and privacy

CSV Merge combines the selected files in page memory; neither file is uploaded to a merge service. Input stays in browser memory until you reset or leave the page. Copy and download run only when you choose them. No tool input is sent to a processing service. Website pages and scripts still make ordinary hosting requests; the privacy policy separates those from tool processing.

Frequently asked questions

Can files have different columns?

No. Schema mismatches are blocked. Align names and order with CSV Column Editor first.

Does merge remove duplicate records?

No. It appends. Use CSV Deduplicate afterwards if duplicates must go.

How many files can I combine?

Two to ten files, up to 10 MiB combined input and 50,000 output records.

What if one file has only a header?

It contributes zero data rows. The merged output still contains the shared header once.

Is the order of rows preserved?

Yes—files merge in the order you set, and rows keep their order within each file.

Does merge match rows by ID?

No. Records are appended in file order. Shared IDs do not cause matching or replacement, and duplicate IDs remain unless you deduplicate afterwards.

What should I do if the headers differ?

Rename, remove or reorder columns first with CSV Column Editor so both files have the same header row and column order, then merge again.

How this tool was checked

CSV Merge was checked with different header orders, mismatched column sets, BOM-prefixed files, delimiter changes and inputs near the record ceiling. A structural mismatch is refused rather than guessed. See the testing method or report a failure.