CSV Merge and Join

Join two CSV or Excel tables by key, with clean columns and optional matching details.

On-device No sign-up Free to use

Join the tables controls

Drop your table file here

or choose one from your device

One CSV, TSV, text or .xlsx file up to 20 MiB per table, 100,000 rows and 500 columns.

    Drop your table file here

    or choose one from your device

    Read with the same delimiter and quote settings as the first table.

      ?

      The table that keeps its rows. Paste CSV or TSV here, or leave this empty and choose a file. A quoted comma or line break inside a cell is read as one value.

      ?

      The table that is matched onto the first one, or choose a file below instead.

      ?

      One column name, or several separated by commas such as region,sku. Enter each name exactly as it appears in that table.

      ?

      Enter the same number of names as the first table, in the same order.

      ?

      A left join is the common choice when the first table is the list you care about.

      ?

      Change this when one table holds SKU-1 and the other holds sku-1.

      ?

      A key that repeats in both tables multiplies the output rows. The result is refused past 50,000 rows, and the repeat count is reported.

      ?

      Off omits _match and combines redundant same-name keys. Other source values remain separate.

      ?

      A workbook download holds every cell as text, so a formula-looking value is never run.

      ?

      A precaution for opening the CSV in a spreadsheet. A cell that begins with = + - or @, including after leading spaces, receives a prefix so it is less likely to run. The prefix changes the stored value, and an app can still treat the cell as a formula after a save and reopen, so it is not a guarantee.

      Advanced
      ?

      Only for a first .xlsx file: the sheet name or its position, such as 2. Leave empty for the first visible sheet.

      ?

      Only for a second .xlsx file. Leave empty for the first visible sheet.

      ?

      Used only when Delimiter is set to Another character. Enter one character, such as ^.

      ?

      The stored value is what the spreadsheet last calculated. The formula text appears with a leading = and is never calculated here.

      Result

      Showing an example.

      Left-join Ana and Bo's IDs to the price table, leaving Bo's unmatched price blank.

      Joined 2 first-table rows with 2 second-table rows on "id" and "id", producing 2 rows. 1 of the first-table rows matched and 1 had no match. Match-status column omitted. Same-name key columns are combined only when their nonblank values agree; differing original key values keep separate columns.

      Loading the tool. Your result will appear here.

      https://usefreetools.net/csv-merge-join · 20 November 2026

      Was this helpful?

      How to use CSV Merge and Join

      1. Paste the first table into the first box, or choose its CSV, TSV or .xlsx file instead.
      2. Add the second table the same way, then set the delimiter or the worksheet if the detected one is wrong.
      3. Name one key column on each side, or several separated by commas such as region,sku, then choose the match type and select Join the tables.
      4. Check the row counts and the repeated-key notes, then download merged.csv or the workbook.

      Example: CSV Merge and Join

      Left-join Ana and Bo's IDs to the price table, leaving Bo's unmatched price blank.

      You add
      First table text: id,name 0012,Ana 0013,Bo; Second table text: id,price 0012,1.50 0014,9.99; Key columns in the first table: id; Key columns in the second table: id; Match rows: left; Compare keys: exact; When a key repeats: all; Include match status and both key columns: false; Download the merged table as: csv; Protect spreadsheet formulas in the CSV download: quote; Encoding of a chosen file: auto; Formula cells in a workbook: cached
      You get
      Joined 2 first-table rows with 2 second-table rows on "id" and "id", producing 2 rows. 1 of the first-table rows matched and 1 had no match. Match-status column omitted. Same-name key columns are combined only when their nonblank values agree; differing original key values keep separate columns.

      Options

      First table text
      The first input table. Which of its rows survive depends on the selected join type. Paste CSV or TSV, or choose a file; quoted commas and line breaks stay inside their cells.
      First worksheet
      Only for a first .xlsx file: the sheet name or its position, such as 2. Leave empty for the first visible sheet.
      Second table text
      The table that is matched onto the first one, or choose a file below instead.
      Second worksheet
      Only for a second .xlsx file. Leave empty for the first visible sheet.
      Custom delimiter character
      For a custom join separator, choose Another character and enter one character used by both delimited sources. Worksheet reads use the workbook cells instead.
      Key columns in the first table
      One column name, or several separated by commas such as region,sku. Enter each name exactly as it appears in that table.
      Key columns in the second table
      Enter the same number of names as the first table, in the same order.
      Match rows
      Inner keeps matched pairs; left keeps every first-table row; right keeps every second-table row; full keeps unmatched rows from both sides as well. Duplicate matching keys can create multiple output rows.
      Compare keys
      Change this when one table holds SKU-1 and the other holds sku-1.
      When a key repeats
      A key that repeats in both tables multiplies the output rows. The result is refused past 50,000 rows, and the repeat count is reported.
      Include match status and both key columns
      Off omits _match and combines redundant same-name keys. Other source values remain separate.
      Download the merged table as
      A workbook download holds every cell as text, so a formula-looking value is never run.

      Supported inputs and limits

      • Each side: 20 MiB, 100,000 rows, 500 columns and 2,000,000 cells.
      • Up to four key columns and 50,000 joined rows.
      • Repeated keys multiply matches.
      • Default output omits _match and combines redundant same-name keys; differing nonblank original keys retain both columns.
      • Other colliding headings receive suffixes.
      More details

      XLSX input reads recognized date styles and cached results without recalculation; missing caches or merges refuse conversion.

      XLSX downloads store text, up to 400,000 cells.

      Where your input is processed

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

      A join is not a stack

      Combining two files by stacking them appends rows; a join attaches columns from the second table onto rows of the first where the keys agree. If both files hold the same columns and you want one longer file, use a cleaner or concatenation instead. The row counts in the summary separate matched rows from unmatched ones so a silent mismatch is visible.

      Why a many-to-many key is dangerous

      One order number usually appears once per file. When it appears four times on each side, the join produces sixteen rows, and it is easy to read that as real data. The repeated-key count, the list of the keys that repeat most and the 50,000-row cap exist so a mistaken key shows up as a warning or a clear refusal rather than a surprise download.

      Text stays text on both sides

      The join keeps source values as strings, so an identifier such as 0012 remains text inside its table. XLSX output stores those strings as text cells. CSV has no cell-type declarations: quoting preserves CSV structure, but a spreadsheet can still infer a number or date when it opens the file. Choose text columns in that importer when exact identifiers matter.

      Questions about CSV Merge and Join

      Can I join on more than one column?

      Yes. Enter each key column on its own side of the comma, such as region,sku, and use the same number of names in the same order on both tables. Every listed column has to match before a pair of rows is joined.

      Why might both key columns remain?

      Default output combines same-name key columns only when their nonblank original values agree. Keys that match after trimming or case normalization can still retain two columns if their original spellings differ. Enable helper columns when you want both keys and match status explicitly.

      What does the _match column mean?

      It labels each output row: both when the key was found on each side, first only for a first-table row with no match, and second only for a second-table row with no match.

      Can I join an Excel file with a CSV file?

      Yes. Either side can be a .xlsx file, and you can name the worksheet to read. The other side can be pasted text or a CSV or TSV file, using the same delimiter and quote settings. Reading a workbook needs the browser's streaming decompressor, so an older browser is told to save the sheet as CSV instead.

      A key repeats in both tables. Why was my result refused?

      Repeated keys multiply the matching rows rather than adding them. Set When a key repeats to use only the first matching row, or clean the duplicates out of one side first. The summary names the keys that repeat most so you can see which one is expanding.

      Page updated · Project managed by Tony Hines · Report a problem with CSV Merge and Join

      Related reading

      All guides