How to use CSV Merge and Join
- Paste the first table into the first box, or choose its CSV, TSV or .xlsx file instead.
- Add the second table the same way, then set the delimiter or the worksheet if the detected one is wrong.
- 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.
- 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.
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.