Skip to content
utilnest

Merge CSV files

Combine monthly exports, survey results or reports into a single CSV, lined up by column name.

  • Works in your browser
  • No sign-up
  • Free to use

How to use Merge CSV files

  1. 1

    Choose two or more CSV files and put them in the order you want.

  2. 2

    Choose whether columns are matched by name or by position, and whether to add the file name or drop duplicates.

  3. 3

    Press Merge CSV files and download merged.csv.

What this tool does

Merge CSV files joins several CSV files into one, one after another. It's the quick way to combine monthly sales exports, form responses, log files or reports from different people into a single sheet you can analyse.

Features

  • Up to 50 files at once, in the order you choose.
  • Match by column name (case-insensitive) or by position.
  • Union of columns: columns found in only some files are kept, with empty cells elsewhere.
  • Optional source column with each row's file name.
  • Duplicate removal and a choice of output separator: comma, semicolon or tab.

Limits

  • The first row of each file must be its header when matching by name.
  • All files are read into memory, so the combined size is limited by your device's memory.

Where your files are processed

This tool works in your browser: your files are merged on your own device, so they aren't sent to our server for this tool. Some other tools on UtiloNest do use our server, and their pages say so.

Frequently asked questions

What if my files have their columns in a different order?

With "By column name", columns are matched by their header, so Name, Age in one file and age, name in another line up correctly. Upper and lower case don't matter.

What happens to columns that only some files have?

They're added to the merged file, and rows from files without that column get empty cells there. Nothing is dropped.

Can I tell which file each row came from?

Yes. Tick "Add a column with each row's file name" and a source_file column is added at the end.

How does duplicate removal work?

A row that is exactly the same as an earlier row, cell for cell, is left out, even if the two copies came from different files. The summary shows how many were removed.

Are my files uploaded?

No. They're merged in your browser, on your own device.

Was this tool helpful?