Join CSV files online free
Join two CSV files on matching key columns, choose inner, left, or full results, and control duplicate lookup keys without uploading your data.
Join exactly 2 CSV files on a key column you choose in each file, entirely in your browser without uploading either file. Choose an inner, left, or full join; when the right file contains the same key more than once, you can use its first row, last row, or every matching row. The downloaded CSV contains the left columns plus the right-side columns, with suffixes added when column names collide, and includes unmatched rows according to the join type. Each file can be up to 10 MB, with 20 MB allowed across both files. This cap is intentionally lower than the limits on our other CSV tools because the browser must keep the decoded right-hand rows and their lookup structure in memory while it streams the left file and writes the result. If your files differ in size, putting the smaller lookup table on the right reduces that memory pressure.
CSV join workspace
Use the left file as the main table and the right file as its lookup table.
Joined rows will appear here
Choose two valid CSV files, select their key columns, and run the join.
Combine two CSV tables by a lookup key
- 1
Choose the left CSV and the right lookup CSV.
- 2
Select the key column in each file.
- 3
Choose the join type and duplicate-key behaviour.
- 4
Review exact match, unmatched, and duplicate counts.
- 5
Download the complete joined CSV.
Built for the real task
- Inner, left, and full joins
- Different key-column names supported
- Explicit duplicate lookup handling
- Collision-safe right column suffixes
See the transformation
Two tables meet on one exact lookup key.
Add matching customer details to each order while keeping missing or repeated matches visible.
Browser limits
Files are limited to 10 MB to protect browser stability, especially on phones. Processing stays on this device.
Join two CSV files on matching key columns, choose inner, left, or full results, and control duplicate lookup keys without uploading your data.
The selected file is not uploaded to Nablyx.
No. This tool reads and transforms the file locally in your browser.
Common uses
- Inner, left, and full joins
- Different key-column names supported
- Explicit duplicate lookup handling
- Collision-safe right column suffixes
How are key values and duplicate lookup rows matched?
Keys match as exact text after surrounding whitespace is trimmed. Matching stays case-sensitive unless you opt in to case-insensitive matching. For duplicate right-side keys, choose the first row, last row, or every match.
Related guide
Related tools
Continue with a related Nablyx tool.
- Compare CSV files online freeCompare two CSV files and review added, removed, and changed rows directly in your browser.
- CSV column mapper and renamerRename, reorder, and remove CSV columns before importing data into a CRM, store, database, or accounting system — without uploading your file.
- Salesforce Contact-to-Account Import JoinerMatch Salesforce Contacts to Accounts, append AccountId only for unique matches, and review unmatched or ambiguous rows before import.
Ready to work on your file?
Return to the workspace and process it locally.