CleanCSV

Merge Multiple CSV Files into One

Stack several files into a single table, even when their columns are in a different order or not all the same, then clean and download it.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

Merge files

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop two or more CSV, Excel or JSON files

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Select or drop all the files you want to merge at once. You can add more later with Add more files.

  2. 2

    Combine all is selected. Columns with the same header are lined up whatever their order, and columns that exist in only some files are kept.

  3. 3

    Keep Add a “Source” column on to see which file each row came from, and turn on Remove duplicate rows if the files overlap.

  4. 4

    Download the merged file as CSV, Excel or JSON.

How columns are matched

Headers are compared ignoring capital letters, spaces, underscores and hyphens, so “First Name”, “first_name” and “first-name” land in the same column. A column that only appears in some files is still included, with blank cells for rows from the other files. Nothing is dropped.

Mixing CSV, Excel and JSON

You can merge different file types in one go. Excel workbooks contribute every sheet, which is handy for monthly data kept on separate tabs. Remove a file with its × button, or click a single table to clean it on its own.

Header rows

Each table's header row is detected automatically, so files with a title line above the headers still line up. If your files have no header row at all, choose No header row and columns are matched by position instead.

Frequently asked questions

Is there a limit on the number of files?

There is no fixed limit on files, but the merged table can have at most 250,000 rows and each file must be within the size limit.

Do the files need the same columns?

No. Columns are matched by name, and columns missing from a file are left blank for its rows.

Can I merge Excel sheets too?

Yes. See Combine Excel sheets for merging the tabs of a workbook.