हिं हिन्दी

    Merge CSV files

    Combine many CSV files into one, matching columns by name.

    or drop CSV files here

    Files never leave your device

    About this tool

    This tool combines two or more CSV files into one CSV, matching columns by their header names. If the files have different or re-ordered columns, the result contains every column from every file, and cells a file did not have are left empty. You can also add a column showing which file each row came from.

    At a glance

    What it does
    Combine many CSV files into one, matching columns by name.
    Price
    Free, no sign-up
    Works in
    Your browser, on phone or computer. Works offline after the first visit.
    Privacy
    Files are processed on your device and never uploaded.

    How to merge CSV files

    1. Click "Select CSV files" and choose two or more files.
    2. Put them in order with the arrows and choose "Match columns by name".
    3. Click "Merge CSV files" and download merged.csv.

    Private

    Your files are processed in your browser and never uploaded.

    Fast

    No upload or queue. Results are ready in seconds.

    Free

    No sign-up, no limits and no watermark on your files.

    Frequently asked questions

    How do I combine CSV files that have different columns?

    Keep "Match columns by name" selected. For example, merging a file with Name, Phone and a file with Phone, City gives one file with Name, Phone, City; the City cells of the first file's rows are empty. Names are matched ignoring upper/lower case and extra spaces.

    Is the header row repeated in the merged file?

    No. The merged file has one header row at the top, followed by the data rows of every file in the order you set.

    What if my files have no header row?

    Choose "No headers: just stack rows". The rows of every file are then joined exactly as they are, one file after another.

    Why does Excel show strange characters in the merged file?

    Excel needs a marker (a UTF-8 BOM) to read Hindi, accented or other non-English text correctly. Keep "Excel-friendly" ticked and the marker is added.

    Are my files uploaded to a server?

    No. This tool runs entirely inside your browser, so your files never leave your device. Nothing is stored or seen by us.