Table Join by Key
Add columns from one table to another by a shared column, and show unmatched rows.
The main table. Its rows and order are kept.
The table whose columns are added where the key matches.
A column both tables share, such as a customer id.
Your result
Paste or upload two tables that share a key column.
How to use it
- Paste or upload both tables.
- Pick the shared key column and which rows to keep.
- Check the unmatched keys and download the table.
Examples
- MatchC1 in both tables One row with both tables' columns
- No matchC3 only in the first Kept with empty cells, or dropped, as you choose
- Repeated keyC1 twice in the second The first row is used and a note says so
Tool details and privacy
Add a second table's columns to the first where a key column matches, such as a customer id, like VLOOKUP does.
Combine customer data from two files without formulas.
Options
- Keep every row of the first table, or only rows found in both.
Limits
- Matching is exact on the text, after trimming spaces around it.
- Up to 5,000 rows per table.
Privacy
What you type or open stays in your browser. Nothing is uploaded or saved on the server.
Questions
Is this like VLOOKUP?
Yes, for all columns at once.
What about keys with no match?
They are listed.
Does it read XLSX?
Yes.
Are the tables uploaded?
No.