About this tool
VLOOKUP is the formula everybody looks up and nobody remembers. This tool does the same job without one: upload two spreadsheets, tell it which column they have in common, tick the columns you want to bring across, and download the combined table.
It works exactly like VLOOKUP, XLOOKUP or a database LEFT JOIN — every row of Table A is kept, and the matching values from Table B are added on the end. Everything runs in your browser; neither file is uploaded.
How the matching works
Choose the matching column in each file — an order number, employee ID, SKU, email address, whatever the two tables share. The names do not have to be identical; you pick the column in each file separately.
- Ignore upper/lower case and spaces is on by default, so ABC-01, abc-01 and abc-01 all match. Turn it off when you need exact matching.
- If a key appears more than once in Table B, the first row wins — the same rule Excel's VLOOKUP follows — and the tool tells you how many duplicates it saw.
- Rows in Table A with no match can either be kept with the new cells left empty, or dropped entirely.
You always get a count of how many rows matched and how many did not, so a mismatched key or a stray space never passes unnoticed.
Features
- A real VLOOKUP / XLOOKUP / LEFT JOIN between two files — no formula, no add-in
- Reads XLSX, XLS, XLSM, XLSB, ODS and CSV, multi-sheet workbooks included
- Pick the matching column on each side independently
- Choose exactly which columns to bring across
- Case- and space-insensitive matching, or exact
- Keep or drop unmatched rows, with a matched/unmatched count
- Download as .xlsx or copy the result as CSV
- Works fully in your browser — nothing uploaded
Common uses
- Add prices from a price list to a list of order lines by SKU
- Attach department and manager to a staff list by employee ID
- Bring email addresses into a report by customer number
- Check which rows of one list exist in another — the unmatched count answers it instantly
How to use it
- Upload Table A — the list you want to add columns to; every row is kept
- Upload Table B — the list to look values up in
- Pick the matching column in each file
- Tick the columns you want to bring across from Table B
- Download the Excel file, or copy the result as CSV
