📊 Data

VLOOKUP Simulator

Match two tables on a shared key column and merge them. Like Excel VLOOKUP but for full tables. Paste CSV, pick keys, download.

Table 1 (base)Lookup key in Table 1

Table 2 (lookup)Lookup key in Table 2

[ Ad · 728×90 ]

Related Tools

CSV Cleaner

Upload a CSV and remove duplicates, blank rows, and whitespa...

JSON to CSV Converter

Paste JSON and instantly convert to CSV. Handles nested obje...

CSV to JSON Converter

Paste CSV data and instantly convert to a clean JSON array. ...

Remove Duplicate Lines

Paste any text and instantly remove duplicate lines. Case-se...

How this compares to Excel VLOOKUP

Excel VLOOKUP looks up a value in the first column of a range and returns a value in the same row from another column. This tool does the same thing but for two full tables — it merges all matching rows from both tables based on a common key column. This is equivalent to a SQL LEFT JOIN or a two-column VLOOKUP.

Left join behaviour

All rows from Table 1 are kept. Rows that match in Table 2 get the extra columns appended. Rows in Table 1 with no match in Table 2 get blank values for the Table 2 columns.