Merge CSV files

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

    or drop CSV files here

    Files never leave your device

    About the Merge CSV Files 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. For example, twelve monthly sales exports from a billing app become one yearly file with a single header row. Files are merged on your device and never uploaded.

    At a glance

    Matching
    By header name, ignoring case and extra spaces; or stack rows as they are
    Output
    One CSV with one header row; optional "Source file" column
    Encoding
    UTF-8, with a BOM for Excel (on by default)
    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.

    Merge CSV 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.