Combine multiple CSV files into one

Upload your CSV files, click Combine, and get a single CSV file with all the data merged vertically.

How to combine

Files with different columns? See how smart merge works.

Combining options

Updated · See what's new

How to combine multiple CSV files

Simple steps to merge your CSV files in seconds

  1. Step 1

    Drag and drop or click the selection area to add all your CSV files.

  2. Step 2

    Click the Combine button.

  3. Step 3

    Wait for the process to finish.

  4. Step 4

    Download the combined CSV file!

Combining options

Customize how your CSV files are merged

Files include headers

Keeps one header row instead of repeating each file's, and warns you if a file's headers don't match.

Skip empty rows

Leaves out rows that are completely empty, so the combined file has no blank lines.

Add new column with file names

Adds a column showing which file each row came from.

Remove duplicate rows (must be exact)

Keeps one copy of rows that are exactly the same, even when they're in different files.

Separator

Commas, semicolons, tabs or pipes are detected for each file. Choose one if columns aren't split correctly.

Files with different columns?

Choose Smart merge to line columns up by their names instead of their position. Columns in a different order, with different capitalization or missing from some files all end up in the right place.

Learn about smart merge

Frequently asked questions

Are my files uploaded anywhere?

No. Your files are read and combined entirely in your browser. Nothing is uploaded to a server, so your data never leaves your device.

Does it handle line breaks, commas and quotes inside cells?

Yes. Files are read as standard CSV, so quoted cells that contain line breaks, commas or quotes stay in one cell and every record stays on one row.

What happens if my files have different columns?

Quick combine stacks rows by column position and warns you about files whose header doesn't match the first file. To line columns up by name instead, choose Smart merge, which fills in blanks for columns a file doesn't have.

What format do my CSV files need to be in?

Files can end in .csv, .tsv or .txt and should be saved as UTF-8 (Excel's Unicode Text format also works). Columns can be separated by commas, semicolons, tabs or pipes, and the separator is detected automatically. Quoted cells can contain separators, quotes and line breaks. The combined file uses the first file's separator and opens correctly in Excel, Google Sheets and Numbers.

Is there a limit on file size or the number of files?

Each file can be up to 50MB. There's no limit on the number of files, but very large combined files depend on how much memory your device has.

Is CSV Combiner free?

Yes, it's free to use with no sign-up and no limits on how often you use it.