Multi-File CSV Concatenation

Combine CSV, TSV and Excel files into one table, preserving the file order you choose.

On-device No sign-up Free to use

Combine CSV files controls

  1. 1 Add files
  2. 2 Arrange/Options
  3. 3 Download

Drop your table files here

or choose them from your device

One to 10 CSV, TSV or XLSX files, up to 20 MiB each and 80 MiB total. CSV and TSV must use UTF-8. Every file is read in your browser.

    ?

    XLSX keeps every cell as text. Reorder files with the Up and Down buttons before combining.

    ?

    The union keeps every distinct heading and fills an absent cell with an empty string. Exact headings refuse a file whose heading set differs from the first file.

    ?

    When selected, each row records the file it came from. The name must not clash with an existing heading.

    ?

    Used only when the source-column option is selected.

    ?

    Automatic uses tabs for .tsv files and detects delimiters in other text files. A manual choice applies to every CSV/TSV input. XLSX ignores this setting.

    ?

    A cell whose first visible character is = + - or @ receives an apostrophe in the download, so a spreadsheet reads it as text. The prefix changes the stored value.

    Result

    Showing an example.

    Append two files with different headings.

    The output headings are id,name,city. Rows are 1,Ada, and 2,,Paris in input-file order.

    Loading the tool. Your result will appear here.

    https://usefreetools.net/multi-file-csv-concatenation · 20 November 2026

    Was this helpful?

    How to use Multi-File CSV Concatenation

    1. Choose one to ten CSV, TSV or XLSX files. Reorder them with Up and Down; workbooks use their first visible worksheet.
    2. Use automatic delimiter handling for mixed CSV and TSV files. It uses tabs for .tsv names; a manual delimiter applies to every text file in the batch. Check the output headings before reuse.
    3. Choose a union of headings or require the same heading set. Union output fills columns absent from a source with empty values.
    4. Optionally add a source-filename column, choose CSV or XLSX output and check CSV formula protection.
    5. Combine and review headings, row counts and missing cells. Download the result; stacking does not merge records with the same identifier.

    Example: Multi-File CSV Concatenation

    Append two files with different headings.

    You add
    one.csv: id,name 1,Ada. two.csv: id,city 2,Paris. Mode: header union; source column off.
    You get
    The output headings are id,name,city. Rows are 1,Ada, and 2,,Paris in input-file order.

    Options

    Download format
    XLSX keeps every cell as text. Reorder files with the Up and Down buttons before combining.
    Header handling
    The union keeps every distinct heading and fills an absent cell with an empty string. Exact headings refuse a file whose heading set differs from the first file.
    Add a column for the source file name
    When selected, each row records the file it came from. The name must not clash with an existing heading.
    Source column name
    Used only when the source-column option is selected.
    Delimiter
    Automatic uses tabs for .tsv filenames and detects delimiters from other text files. A manual choice applies to every CSV/TSV file in the batch. XLSX ignores this setting. Check short or ambiguous tables for correct headings before using the combined output.
    Protect spreadsheet formulas
    CSV output can prefix formula-like values with an apostrophe. This changes stored text and depends on the destination's import behavior; review the file before reuse. XLSX output stores its values as text cells.

    Supported inputs and limits

    File countUp to 10 CSV, TSV or XLSX files
    Input size20 MiB each; 80 MiB total
    Table bounds100,000 rows; 500 columns
    • One to ten files, 20 MiB each and 80 MiB total; combined table up to 100,000 rows, 500 columns and 2,000,000 cells.
    • XLSX input uses the first visible sheet and saved values; missing caches or merged cells refuse conversion.
    • CSV output uses the formula guard;
    • XLSX output keeps text and supports up to 400,000 cells.
    • Header union fills absent cells with empty strings; strict mode requires the same headings.
    More details

    Use Up and Down controls to reorder files.

    Drag reordering is not provided.

    Where your input is processed

    This tool does not upload your inputs. See the limits for anything saved on your device.

    Concatenation appends rather than reconciles

    Rows are appended in chosen file order. A union of headings can combine tables with different columns but cannot decide that differently named headings mean the same thing. Map headings first when two exports use different names for the same field.

    Empty cells can have different origins

    In header-union output, an empty value may have been blank in the source or may represent a heading absent from that file. Keep a source column when that distinction matters, and retain the original exports for a more detailed reconciliation.

    Questions about Multi-File CSV Concatenation

    Is this a key-based table join?

    No. Records are stacked in file order. The header union aligns columns but does not combine records sharing an identifier.

    What if one file cannot be parsed?

    The run refuses the combined export and identifies the problem file. Correct or remove it before trying again.

    Why does a cell gain an apostrophe?

    Formula protection prefixes cells that a spreadsheet could treat as formulas. A raw export option is available when you deliberately need the original strings.

    Page updated · Project managed by Tony Hines · Report a problem with Multi-File CSV Concatenation