Match business exports
Connect an order export with a customer reference table by using a stable identifier available in both files.
Data & spreadsheets
Join two Excel or CSV files
Import two Excel, CSV, TSV or JSON files, choose the key columns, then run an inner or left join locally in your browser.
- Export
CSV, TSV, XLS, XLSX or JSON
CSV, TSV, XLS, XLSX or JSON
Result
Preview of the first rows
Was this tool useful?
How does this tool work?
Join two tables on a shared key without uploading your files. The engine reads Excel, CSV, TSV and JSON locally in your browser.
The tool reads both files independently in your browser, extracts their sheets and columns, and lets you choose a matching key for each table. During the join, values from the left key are compared with values from the right key to connect matching rows. An inner join keeps only matches, while a left join preserves every row from the first table. Conflicting column names receive a suffix before the resulting CSV or Excel workbook is generated locally for download.
How to use this tool
Import both tables
Choose the left and right files, then select the sheet when a workbook contains several sheets.
Choose the keys
Select the columns representing the same identifier and choose the join type.
Review and export
Check the preview and download the result as CSV or XLSX.
Use cases
Enrich an Excel table
Bring columns from a second dataset into a primary spreadsheet without performing manual row-by-row lookups.
Combine different formats
Join a CSV source with an Excel workbook when both datasets contain a reliable key representing the same records.
Tips and best practices
- Prefer stable IDs over free-form names.
- A left join keeps every row from the first file.
- Conflicting right-column names receive a suffix automatically.
Frequently asked questions
What is the difference between merge and join?
A merge often stacks rows. A join matches two tables horizontally using a common key.
Are my files uploaded?
No. Reading, joining and exporting happen locally in your browser.
Can I join Excel with CSV?
Yes. Each source may use a different supported spreadsheet format.
Related tools
Keep going with these tools
Tools similar or complementary to this one.
Similar tools
Split a CSV file into smaller files using the size or groups you choose.
Data & spreadsheetsFeaturedUse this tool
Merge multiple CSV files into one table while keeping columns aligned consistently.
Data & spreadsheetsFeaturedUse this tool
Merge multiple Excel or CSV files into one table with automatic column alignment.
Data & spreadsheetsUse this tool
Read next
GuideBest practicesBeginner
Data and tables: understanding CSV, Excel, JSON and dataset structure
Learn how tabular data is structured, how CSV, Excel, JSON and TSV differ, and how to choose the right format before cleaning, converting or automating a workflow.
29 August 20263 min
GuideBest practicesBeginner
Merge CSV or Excel files without misaligning columns
Learn how to align headers, verify schemas and combine several CSV or Excel files while avoiding duplicated or shifted columns.
29 August 20262 min
GuideBest practicesBeginner
How to clean and prepare a CSV or Excel file before using it
Learn a practical order for removing empty rows, trimming values, standardizing headers, checking identifiers and validating a CSV or Excel dataset.
29 August 20263 min
GuideBest practicesBeginner
Filter, sort, select and rename CSV columns efficiently
Learn when to filter rows, sort records, keep only useful columns and rename headers so a CSV is easier to analyze, merge or export.
29 August 20262 min