Merge / Lookup
Join two files on a key (VLOOKUP-style)
Drop a CSV or
Drop a CSV or
About Merge / Lookup
What this does
The online equivalent of an Excel VLOOKUP or a SQL JOIN. Drop two CSVs, pick the column they have in common (the key), and pull data from the second file into rows of the first.
Join types
- Left join (default) — keep every row from the left file; fill in matching data from the right.
- Inner join — only rows that exist in both files.
- Right join — keep every row from the right file.
- Full outer join — every row from both, matched where possible.
When to use it
- Adding order totals to a customer list
- Looking up product names by SKU in a sales export
- Merging a survey response file with the participant roster
- Reconciling two reports that share an identifier
Frequently asked questions
No problem — pick the key column for each file separately. They do not need to share a name.
The first occurrence wins. If you need the last instead, use the Dedupe tool first to keep just the row you want.
When a column from the right file has the same name as one in the left file, the right one is renamed to "name (right)" so nothing gets overwritten.
Embed this tool on your site
Drop a one-line iframe snippet into any blog, lesson plan, or knowledge base. Powered-by-Toolenza link included.
Embed this tool
Paste this snippet into any HTML page. The tool runs entirely in your reader's browser.
Related tools
Merge / Lookup
No reviews yet — be the first to share your thoughts.
- No reviews yet — be the first to share your thoughts.