CSV JOIN · INNER / LEFT JOIN
Join Two CSV Files by a Common Key
Select a shared column, such as a product code or employee ID, to combine related fields from two CSV files into one row. Both files stay in your browser.
CSV processing stays in your browser
Your files are not uploaded to a server.
File selection
Choose 2 CSV files, up to 50 MiB total. They are processed in left-to-right order. File names and contents are never sent outside your browser.
Drag and drop CSV files here
Up to 2 CSV files, 50 MiB total
How it works
Add product names to sales data by product code
How it works
Add product names to sales data by product code
Join matching product-code rows from the sales CSV on the left and the product CSV on the right.
Left CSV
sales.csv
| Product code | Quantity |
|---|---|
| P01 | 2 |
Right CSV
products.csv
| Product code | Product name |
|---|---|
| P01 | Apple |
Output example
| Product code | Quantity | Product name |
|---|---|---|
| P01 | 2 | Apple |
INNER JOIN keeps only keys found in both files. LEFT JOIN keeps every row from the left CSV.