Join two tables on a shared column
Pick the key column in each table. The joined rows and the unmatched ones appear as you choose.
- Runs on your device
- No sign-up
- Works offline after a visit
Join type
Several right rows for one key
Columns from Right to add
0left rows matched
0left rows without match
0right rows without match
0rows in result
How to join two spreadsheets on a shared column
- Drop or paste the left and the right table.
- Pick the key column in each, and the join type you need.
- Check the counts, then download the joined table as CSV or Excel.
Questions
What is the difference between the join types?
Keep all left rows keeps every row of the left table and adds the right columns where a match exists. Only matches keeps just the rows found in both. Everything keeps every row of both tables. Left rows with no match keeps only the left rows that found nothing on the right.
What happens when a key appears twice on the right?
First match takes the first right row for that key. All matches adds one row for each right row, so a left row can appear more than once. The tool tells you how many keys repeat.
Is my data uploaded?
No. Both tables are read and joined in your browser. Nothing is sent anywhere.
Reviews
No reviews yet. Be the first.