Join Two Tables (VLOOKUP)
Match rows of two tables by a key column – left, inner, full or right join.
| id | Name | city |
|---|---|---|
| 1 | Ana | Lisbon |
| 2 | Ben | Berlin |
| 2 | Ben | Hamburg |
| 3 | Carla | |
| 4 | David |
Runs entirely in your browser. Nothing is sent anywhere.
How it works
- 1Paste or type your text.
- 2Choose the options you need.
- 3Copy or download the result.
About this tool
Join Two Tables (VLOOKUP): Match rows of two tables by a key column – left, inner, full or right join. Paste your text and the result appears immediately, ready to copy or download. Everything happens locally in your browser — nothing you paste is uploaded or stored.
Example
Input
id,name 1,Ana 2,Ben 3,Carla 4,David
Output
id,name,city 1,Ana,Lisbon 2,Ben,Berlin 2,Ben,Hamburg 3,Carla, 4,David,
How do I use the Join Two Tables (VLOOKUP)?
Paste or type your text. Choose the options you need. Copy or download the result.
Is the Join Two Tables (VLOOKUP) free?
Yes. It is completely free with no sign-up, no usage limits and no watermark.
Is my data sent to a server?
No. Everything is calculated locally in your browser. Nothing you enter is uploaded, logged or stored.
Does it work on my phone?
Yes. It works in any modern browser on Android, iPhone, iPad, Windows, Mac and Linux — no app needed.