Online Tool Store
VLOOKUP Tool
VLOOKUP two CSV or TSV tables in your browser: pick key and return columns, spot duplicate keys and unmatched rows, then download the merged result.
🔒 This tool runs entirely in your browser. Your files are never uploaded to a server.
Data & CSV
VLOOKUP Tool
Match a main table to a lookup table locally, without formulas or uploads.
Paste two tables or load the example.
Matched
0
Missing
0
Duplicate lookup keys
0
Output preview
Missing key report
How the VLOOKUP Tool works
- Paste the main table and the lookup table as CSV or TSV text.
- Choose each key column, the value column to return, and the matching rule.
- Run the lookup, review matched and missing counts, then copy or download the output CSV.
The method
The tool indexes the lookup table by its selected key, then scans each main-table row and appends the selected value from the first matching lookup row.
output row = main row + lookup value for the first matching key
With exact matching, "ann@site.com " and "ann@site.com" are different keys — which is why trailing-space failures dominate real spreadsheet joins.
FAQ
Why do my VLOOKUPs return #N/A when the value is clearly there?
Almost always invisible differences: trailing spaces, a number stored as text, or mixed casing. Switching to trimmed or case-insensitive matching usually resolves it, and the unmatched list shows which of the three you are hitting.
Is this the same as XLOOKUP?
The idea is the same lookup, but XLOOKUP can search in any direction and return a default when nothing matches. This page focuses on the classic left-to-right key match and on surfacing the misses.
What happens with duplicate keys?
A lookup returns the first match and silently ignores the rest, which is how duplicates quietly corrupt a merge. Deduplicate the lookup table first if the key is supposed to be unique.
Can I merge two CSV files without opening Excel or Google Sheets?
Yes. Paste both tables directly as CSV or TSV text, pick the key and return columns, and run the match on this page — no spreadsheet software or VLOOKUP formula required.
Is my data uploaded anywhere?
No. The match runs locally in your browser. Nothing you paste is sent to a server, which also makes it fine to use with data you would not want to upload.
How we compare
| Feature | Online Tool Store | A spreadsheet | A BI platform |
|---|---|---|---|
| Lists unmatched keys | ✓ | Manual work | ✓ |
| Reports unmatched and duplicate keys | ✓ | ✗ | ✗ |
| No file upload | ✓ | ✓ | ✗ |
| No formula syntax to remember | ✓ | ✗ | Varies |
| Copy or download merged CSV | Yes | Manual export | Yes |
The VLOOKUP Tool is built around the part spreadsheets hide: the rows that did not match, and the reason they did not.