Upload two Excel or CSV files, choose a column in each to match, and download the rows that appear in both. No VLOOKUP formulas needed. Files are processed in your browser and are not uploaded.
Drop a file here or
No file selected
Drop a file here or
No file selected
Matching ignores capitalization and leading or trailing spaces. Rows with blank match values are skipped; duplicate values produce every matching row combination.
Combine two Excel sheets by matching a shared value, such as a customer ID, email address, or SKU, without formulas. This VLOOKUP alternative matches the selected columns and puts the matching rows together in a new Excel workbook.
Upload both CSV files, choose the ID column in each, then select Find matching rows. Matching ignores capitalization and surrounding spaces. The result includes rows whose nonblank IDs are present in both files; it does not include unmatched rows from either file.
To look up details from a second worksheet, use a shared key such as an ID. In these examples, the ID is in column A on both sheets, and the values to return are in columns B through D on Sheet2. Enter the formula in the first result cell on Sheet1, then fill it down for the rest of your rows.
=XLOOKUP(A2,Sheet2!$A:$A,Sheet2!$B:$D,"No match")
XLOOKUP finds the ID from A2 in Sheet2 column A and returns the corresponding values from columns B through D. In supported Excel versions, the results spill into adjacent cells.
=IFERROR(VLOOKUP($A2,Sheet2!$A:$D,2,FALSE),"No match")
Use an exact match with FALSE. The number 2 returns column B from the selected range; use 3 for column C and 4 for column D. Fill each formula down to look up the other rows.
These formulas return a lookup result for each source row, and a lookup generally returns the first matching row. To combine every matching row, including duplicate-key combinations, from two files without writing formulas, use the matcher above.
Use this tool when you want to join two files by a common column without setting up formulas. Unlike a left join, it returns only values found in both spreadsheets.
| Feature | VLOOKUP or XLOOKUP formula | Excel Lookup |
|---|---|---|
| How you match data | Write and maintain a spreadsheet formula | Upload two files and select each matching column |
| Output | Formula results in a spreadsheet | Matched rows from both files in a new Excel workbook |
| Unmatched rows | Depends on the formula and setup | Excluded; this is an inner join |
| File processing | Inside your spreadsheet application | Locally in your browser; file contents are not uploaded |
Excel Lookup is an online alternative when you need to combine two files by a shared column without writing a VLOOKUP or XLOOKUP formula. Choose the matching column in each spreadsheet to create a downloadable workbook of matched rows.
Yes. Upload two Excel workbooks, choose the columns that contain the same values, and download the merged Excel workbook. The first worksheet in each uploaded workbook is used.
Yes. Upload two CSV files and select the shared column in each. Matching is case-insensitive, ignores leading and trailing spaces, and skips blank values.
No. The tool performs an inner join: it includes rows with matching, nonblank values in both files. Rows without a corresponding match are not included.
Spreadsheet contents are processed locally in your browser and are not uploaded to a server. You can preview the matched rows before downloading the result.