3 VLOOKUP Tools, Compared Honestly

Two exports: orders in one, customer details in the other, a shared ID column between them. You need them side by side, and =VLOOKUP(A2,Sheet2!A:D,3,FALSE) returns #N/A for a third of the rows.

The formula is not usually the problem. The mismatches are — trailing spaces, numbers stored as text, an ID that gained a leading zero somewhere in the export. A good matching tool is judged less by how it joins than by how clearly it shows you what failed to join, because that list is where the real work is.

How to judge a table matching tool

Does it show unmatched rows? The keys that found nothing are the useful output. A tool that returns only successful matches has hidden the problem you needed to see.

Which join types? Inner join keeps only matches. Left join keeps everything on the left and fills in what it can. Different questions, different answers.

Can you match on more than one column? SKU alone is often ambiguous; SKU plus warehouse is not. Multi-column keys are a genuine differentiator.

Where does the data go? Order exports and customer lists are the usual inputs. Browser-side processing keeps them on your machine.

The comparison

Facts checked August 2026; tools change their plans. Table covers only the 3 alternatives — our tool gets its own section below.

ToolZapHub Visual VLOOKUP

The closest to what most people actually want. Upload two Excel or CSV files, pick the key column in each, choose which data to bring across, and download the joined result — described as being like VLOOKUP but entirely visual, with no formula knowledge needed. It runs in your browser, so the files are not uploaded to a server, and it states no signup, no payment and no limits.

The feature that matters most here is a separate download for unmatched rows. That is the list you take back to whoever produced the export, and having it as its own file rather than a filter you have to construct saves the fiddly part. Output is CSV.

Sheetgo VLOOKUP

The most connected. Either side of the join can be Google Sheets, Excel, CSV, BigQuery or a REST API, which puts it in a different category from tools that only take two uploaded files — if your data lives in a warehouse or behind an API, this removes the export step entirely. You choose the key columns, pick inner join or left join, select output columns and download the result.

It is free in-browser for a single run, with no signup. Scheduling the join to run repeatedly requires a free trial and then a paid plan, which is the actual product; the one-off tool is the sample.

Toshical VLOOKUP Generator

The most basic of the three, and sometimes that is right. Upload two Excel files, select the shared unique key, generate, download. No account, free, four steps.

Its page says little about how it handles the details — whether files are processed locally or on a server, what happens to unmatched keys, or what the output format is. For a quick merge of two clean files that is unlikely to matter; for anything sensitive or messy, the other two tell you more about what they are doing.

VLOOKUP Tool

Ours takes two pasted tables rather than uploaded files, lets you pick the key column in each, and previews a VLOOKUP-style join showing both matched rows and the keys that found no match. Pasting suits the common case — you already have both tables open, and exporting them to files first is a step that exists only to satisfy the tool.

What it does not do: connect to BigQuery or an API, match on multiple columns at once, or export to Excel. For a scheduled join between live sources, Sheetgo is the right shape; for a composite key, you would need to concatenate the columns first. The underlying operation is a left join in database terms, which is worth knowing if you ever move this work into SQL.

Which one to pick

• Data living in Sheets, BigQuery or an API — Sheetgo.
• You need the unmatched list as its own file — ToolZapHub.
• Two clean Excel files and nothing complicated — Toshical.
• Two tables already on your clipboard — the tool below.

How to do it with VLOOKUP Tool

1. Open the VLOOKUP Tool and paste both tables.
2. Pick the key column in each — they do not need the same header.
3. Read the matched rows, then read the unmatched keys, which is where the real information is.
4. Clean the keys and run it again rather than accepting a partial match.

The walkthrough is in how to use VLOOKUP Tool. Other data tools are in the tools directory.

You might also need

When the two tables are simply being stacked rather than joined, the CSV Merger is the tool for that job.

If one file arrived as .xlsx and the other as .csv, the Excel to CSV Converter gets them into the same shape first.

Frequently asked questions

Is there a free VLOOKUP alternative that doesn’t need Excel?

Yes. ToolZapHub and ours both run in the browser with no account, Sheetgo works without signup for a single join, and none of them require you to write a formula. All of them handle CSV, so Excel is optional.

Why does my VLOOKUP return #N/A for rows that clearly exist?

Almost always a key mismatch that is invisible on screen: trailing whitespace, a number stored as text on one side and a real number on the other, or a leading zero that a spreadsheet stripped on import. Compare the raw values, not the displayed ones.

What is the difference between an inner join and a left join?

An inner join keeps only rows that matched on both sides. A left join keeps every row from the first table and leaves blanks where the second had nothing. If you want to find missing data, you want the left join — the blanks are the answer.

Final thought

Look at the unmatched keys before you look at the matched rows. A join that succeeded for 90% of rows is not a 90% success; it is a data quality report you have not read yet.

Try the free VLOOKUP Tool