EasyFilesConverter

VLOOKUP between two files

Matching two lists is the most common Excel task. Pick the two files, choose the column they share, tick what to bring over - done, with the rows that did not match listed separately.

1. Your main list (rows are kept)

2. The file to take values from

Free · No sign-up · Your files are processed on your device and never uploaded

How to use VLOOKUP between two files

  1. XLSXlist.xlsx + prices.xlsx
    1

    Choose your file

    Drop it on the page or pick it from your phone or computer.

  2. Pick the match column
    2

    Press "Pick the match column"

    Pick the options you want - the defaults suit most files.

  3. XLSXlist-matched.xlsx
    3

    Download the result

    Ready in seconds. Your file never left your device.

Features

  • Works with .xlsx and .csv, any sheet.
  • Ignore case, extra spaces and leading zeros options.
  • Counts: found, not found, only in the second file; warns about duplicate keys.
  • Download: matched list + not found + only in file 2, in one workbook.

How to use it

Choose your main list (its rows are kept) and the file to take values from.

Pick the match column in each (it is guessed from matching headers) and the columns to bring over.

Download the matched workbook.

Free and private

Everything happens inside your browser: your files are read on your own device and are never uploaded, stored or seen by anyone else.

Questions

What if a key appears twice in file 2?

Like VLOOKUP, the first match is used, and you are warned how many keys repeat.

Are my files uploaded?

No - matching happens in your browser.

Is it free?

Yes - free and unlimited, with no sign-up and no watermark.

More smart tools

All tools →

Is my PDF safe to send?

Check a PDF for hidden data before you send it: author names, comments, attached files, scripts, earlier saved versions and text still hidden under black boxes.

Where did my money go?

Turn a bank statement PDF, scan, CSV or Excel export into categorised spending: food, shopping, bills, transport and more, with monthly charts, top merchants and an Excel report.

Find my subscriptions

Find forgotten subscriptions and recurring charges in your bank statement (PDF, CSV or Excel): weekly, monthly, quarterly and yearly payments with the cost per year.

Rename PDFs by content

Rename many PDFs at once using what is inside them: invoice number, date, company and total.