Merge two Excel files by a column
VLOOKUP without the formula: match two files on a shared column and bring the other file's columns across.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Join Two Excel Files by a Column
- 1Select your files, or drop them on the page
- 2Choose how, then run it
- 3Download joined.xlsx
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
How do I merge two Excel files on a common column?
Upload the main file first and the lookup file second. The shared column is found for you, or type it. Download one table with the second file's columns added.
Is this the same as VLOOKUP?
It does what VLOOKUP does for every column at once: each row of the first file gets the matching row of the second. When a key appears twice in the second file, the first one is used, as VLOOKUP does, and you are told.
What if the IDs look slightly different?
Keys are matched trimmed and without case, and 1 matches 1.0, so "C02 " finds "c02".
What happens to rows with no match?
They stay in the result with the new columns empty, and they are also listed on a sheet called No match so you can check them.