📎 Merging

VLOOKUP for Lists

Add search volumes, target URLs or owners to your list without building a spreadsheet: paste the table and every line gets its value.

  • 100% free, no limits
  • No sign-up
  • Your data never leaves your browser
  • Results in under a second
Use the VLOOKUP for Lists tool now ↓ Open it in the full Notepad

Free tool Paste your list — the VLOOKUP for Lists tool does the rest

The example below is already loaded, so you can see exactly what you get. Replace it with your own list and the result updates as you type.

Got a bigger job? The full Notepad runs the same engine on lists of any size — chain this with dedupe, sort and filter, undo any step, and save the whole routine as a recipe for next time.

Example VLOOKUP for Lists tool: before and after

Before
running shoes
trail shoes
socks
Second list
Running Shoes | 49,500
trail shoes | 12,100
After
running shoes | 49,500
trail shoes | 12,100
socks | (not found)

How it works What the VLOOKUP for Lists tool does

Like VLOOKUP: for each line in your list, finds it in a “key | value” table (the second list) and adds the value — search volume, a URL, a category — or marks it as not found.

Works like VLOOKUP in a spreadsheet. Paste a two-column table in the second box (“key | value”, or a tab between them) and each line of your list gets the matching value appended. Lines with no match get a “not found” marker, which you can change.

Matching ignores capitals by default, so “Running Shoes” in the table matches “running shoes” in your list.

3 steps How to use the VLOOKUP for Lists tool

  1. Paste your list into the box above — one item per line, and the second list into its own box. Keyword exports, crawl exports and spreadsheet columns all work.
  2. Check the settings and adjust them to your job — the result updates as you type.
  3. Copy the result and paste it wherever it needs to go. Nothing is uploaded, so client and confidential data stay on your machine.

Use it to When to use the VLOOKUP for Lists tool

  • Add search volumes from a keyword tool export to your own list
  • Attach target URLs or owners to a list of keywords
  • Look up the status code of each URL from a crawl export

FAQ VLOOKUP for Lists tool questions

Is Look Up Values from a Table free to use?

Yes. Look Up Values from a Table runs entirely in your browser, on this page and in the full Notepad, with no sign-up, no limits, and nothing sent to a server.

What separators can the table use?

A | (pipe), a tab, → or => between key and value. Tabs let you paste two spreadsheet columns directly.

What if a key appears twice in the table?

The first value wins, just like VLOOKUP.

Pairs well with More Merging tools, all free

📎 Merge Two Lists

Two exports, one clean list: merge them and drop the duplicates in a single step.

📎 Keyword Mixer

Ten modifiers × fifty products is five hundred keywords you would otherwise type by hand. Paste both lists an…

📎 Find Common Lines in Two Lists

See exactly where two lists overlap: the keywords you and a competitor both rank for, the URLs in both crawls.

📎 Keyword Gap Finder

Your next content wins are the keywords your competitors rank for and you don’t. Paste both lists and see the…

Stop fixing lists by hand

The VLOOKUP for Lists tool is one of the free tools inside Seowolf’s Notepad. Paste a list once, then dedupe, filter, sort, compare and format it in seconds — every step undoable, nothing uploaded, no account.

Open the Notepad — it’s free
← Browse all free tools
KnownHost