100% Free & Secure

Excel VLOOKUP Tool

Match values from one table to another using a shared column. Process everything locally in your browser for total privacy.

Primary File
The main dataset you want to enrich with new columns.
Lookup File (Optional)
If you are matching within the same workbook, leave this empty.

Share this tool

Did this work well?

Why Use Our VLOOKUP Tool?

Simple, fast, and secure data matching

Flexible Modes

Upload two separate files or select two sheets from the same workbook.

Lightning Fast

All processing happens locally in your browser with no upload delays.

100% Private

Your files never leave your device. Zero server uploads.

Online VLOOKUP Tool - Free & Private

The Excel VLOOKUP Tool lets you easily merge data from two separate files or sheets based on a common matching column. Forget complicated Excel formulas—just upload your files, map your columns, and download the combined result instantly.

What is this tool?

It's an online alternative to Excel's VLOOKUP and XLOOKUP functions. It takes rows from a primary dataset and enriches them with data from a lookup dataset by finding matching keys.

Understanding the Settings

Main Sheet (Primary Sheet)

This is your primary dataset. The tool will add a new column of data to this sheet, keeping all your original rows and their exact order intact.

Lookup Sheet

This is the source dataset that contains the new information you want to pull into your Main Sheet.

Match Column (Main Sheet) / Primary Key

The column in your Main Sheet that contains the unique identifier you want to match on (e.g., Email Address, Employee ID, Product Code).

Match Column (Lookup Sheet) / Lookup Key

The corresponding column in your Lookup Sheet that contains the exact same unique identifiers.

Column to pull in / Return Column

The specific column of data in the Lookup Sheet that you want to bring over and add to your Main Sheet.

New Header Name / Output Column Name

What you want to name the brand new column that gets added to your Main Sheet.

Fallback Value

If the tool searches for an identifier but cannot find a match in the Lookup Sheet, it will output this exact text instead (e.g., 'Not Found' or 'Missing'). Leave it blank for an empty cell.

Trim spaces before matching

Often, Excel data has hidden spaces at the beginning or end of words (like ' [email protected] '). Turning this on removes those spaces so matches do not fail.

Approximate Match

By default, the tool requires an exact character-for-character match. Turning this on makes the match case-insensitive (e.g., 'Apple' will match 'apple').

How Does It Work?

  1. Upload Files: Upload your primary file and an optional lookup file (or just use two sheets from one file).
  2. Map Columns: Select the key columns that link your data together, and choose the column you want to return.
  3. Run VLOOKUP: Click the button to process your data locally in your browser. Unmatched values can be left blank or filled with a custom fallback text.
  4. Download: Preview the results and download your updated spreadsheet, with your original row order completely preserved.

Why Use Our VLOOKUP Tool?

  • No complex formulas to remember
  • Process huge files directly in your browser
  • Total privacy - files are never sent to a server
  • Easily set custom fallback values for unmatched rows

Frequently Asked Questions

Common questions about the VLOOKUP tool

What happens if there are duplicate keys in the lookup table?+
If multiple rows in the lookup table share the same key, the tool uses the first match it finds. This mirrors standard Excel VLOOKUP behavior.
Are my files uploaded to your servers?+
No. All file parsing and processing is done entirely within your web browser using JavaScript. Your data is 100% private.
Does this support XLOOKUP or INDEX/MATCH?+
This tool performs a left-join operation similar to all of these functions. Since you visually select the lookup and return columns, it effectively replaces the need for XLOOKUP or INDEX/MATCH.