Skip to main content

Join CSV files online free

Nothing uploadedTested up to 10 MB

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.

Processed locally in your browser

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. 1

    Choose the left CSV and the right lookup CSV.

  2. 2

    Select the key column in each file.

  3. 3

    Choose the join type and duplicate-key behaviour.

  4. 4

    Review exact match, unmatched, and duplicate counts.

  5. 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.

orders.csv · customer_id
orderkeyamount
1001C-4284.50
1002C-9142.75
customers.csv · id
keynametier
C-42Aminapro
C-42AminaVIP
Result
orderkeynametier
1001C-42Aminapro
1002C-91——

Browser limits

Files are limited to 10 MB to protect browser stability, especially on phones. Processing stays on this device.

Inner, left, and full joins

Join two CSV files on matching key columns, choose inner, left, or full results, and control duplicate lookup keys without uploading your data.

Private by design

The selected file is not uploaded to Nablyx.

Processed locally in your browser

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.

Ready to work on your file?

Return to the workspace and process it locally.

Join two CSV files