CSVStitch

Merge CSV files with different headers

Use this when one file has a column the other does not.

This setup is for files that do not share one header row. Duplicate rows are left in place unless you turn that option on.

🔒 Your files stay in your browser and are never uploaded

  1. The sample has a name column in one file and a city column in the other.
  2. Run it and check that both columns appear.
  3. Empty cells mark the column a file did not have.

Common problems

Use this page when two or more CSV files do not share one header row. A common mistake is to paste the files one under the other and assume column 1 is always the same kind of fact. Here the match is the header text. A column that appears in only one file stays in the result, and the other files get an empty cell in that column. Try the sample first: one file has a name column and the other has a city column. After the run, both columns should be present. An empty cell means that file never had the column. It does not mean the row failed, and the row is not deleted for being incomplete. When the sample looks right, switch to your own files.

Are columns matched by position?

No. They are matched by the header text. id lines up with id, even if the other columns differ.

Will extra columns be dropped?

No. An extra header is added to the result.