CSV Merger Tool

    Merge any number of CSV files into one, straight in your browser. Mismatched headers, different delimiters and mixed encodings are handled during the merge, and nothing is uploaded to a server.

    Upload Files

    Combining CSV Files That Are Not Quite Identical

    Delimiters Are Not Always Commas

    A file with a .csv extension is frequently separated by semicolons rather than commas. This is normal behaviour for Excel in locales where the comma is the decimal separator, which covers most of continental Europe. Opening such a file with a comma-only parser produces a single column containing the whole row. FileMerger inspects the first lines of each file, infers the delimiter it actually uses, and can merge a semicolon-separated export with a comma-separated one in the same operation.

    Encoding and the Mangled Character Problem

    If names arrive looking like "Björn" rendered as mojibake, the file was written in one encoding and read in another. Legacy systems still emit Windows-1252 or Latin-1, while modern tooling assumes UTF-8. FileMerger detects the byte-order mark where present and falls back to heuristics where it is not, then normalises everything to UTF-8 in the output. Check a row containing accented characters in the preview before exporting, since encoding damage is far cheaper to catch now than after the merged file has been distributed.

    Headers, Blank Rows and Row Counts

    Each input file contributes its header row once; the merged output carries a single header rather than repeating it between blocks. Trailing blank lines, which many exports include, are dropped rather than becoming empty rows. After merging, compare the output row count against the sum of your source rows minus the header lines. A mismatch almost always points at a quoting problem in one source file, typically an unescaped quote character that caused a row to be parsed as a continuation of the previous one.