Merge CSV & Excel Files

Combine many spreadsheets into a single table.

Combine options

First row is a header

Columns are matched by their header name. A column that only some files have is added, and left empty for the others.

Add a Source column
Combined in your browser. Your files are not uploaded.
Guide

How to combine spreadsheets

1

Add your files

Drop CSV and Excel files together. You see how many rows each has.

2

Choose how to join

Match columns by header name, and add a Source column if you want to know where each row came from.

3

Download

Get one CSV or Excel file with everything in it.

Frequently asked questions

Is my data uploaded?

No. The files are combined in your browser.

What if the files have different columns?

With First row is a header on, columns are matched by name (ignoring upper and lower case). Columns that only some files have are added and left empty for the rest.

Can I merge sheets from one workbook?

Yes. Add the Excel file and turn on Use every sheet of Excel files.

What does the Source column do?

It adds the file name (and sheet name) to each row, so you can see where it came from.

Can I mix CSV and Excel files?

Yes. They are read the same way and combined into one table.

Related tools

See all documents →