How to update one Google Sheet from another by a key column

By Jake Marsh · Updated

To update one Google Sheet from another by a key column, open Extensions, Tabmeld, Merge sheets by key, pick your table and the lookup table, add the key under Match rows by (such as SKU or Email), and choose for each lookup column whether to update a matching column, add it as a new column, or skip it. Click Preview to see every cell that will change, tick the confirmation, and click Update table. Tabmeld makes a backup tab first.

A lookup without formulas

The usual way is a VLOOKUP or XLOOKUP column for each field you want to bring over. That works until someone sorts the table, pastes over a formula, or the lookup tab moves to another file. Merge by key writes plain values into your table, only into the cells that should change, and can be run again whenever the lookup table changes.

Steps

  1. Open Merge sheets by key from the Tabmeld menu.

  2. Pick the two tables. The table to update must be a tab in this spreadsheet. The lookup table can be a tab here or in another file you pick.

  3. Add the key columns under Match rows by. Use more than one if a single column isn't unique.

  4. Under Bring over, choose for each lookup column: update the column of the same meaning in your table, Add as new column, or Skip.

  5. Choose how to write:

    • Fill empty cells only never touches a value you already have.
    • Overwrite with the lookup's values replaces them.

    Either way, a blank in the lookup never erases a value, and formula cells are never overwritten.

  6. Set the extras if you want them: Add lookup rows with no match to the end, and Add a "Match" column (Matched / No match).

  7. Set Matching options: ignore case, extra spaces or punctuation in the key, so ABC-123 with a trailing space and abc-123 count as the same key.

  8. Click Preview. It lists every cell edit, new column and new row.

  9. Tick I checked the preview, then click Update table.

An example

Your product tab has SKU, Name and Price, with some prices blank. A supplier sends a price list with SKU, Price and Stock.

ChoiceResult
Price: update Price, Fill empty cells onlyBlank prices are filled; prices you set stay
Stock: Add as new columnA Stock column appears with each SKU's stock
Add a "Match" columnRows the supplier list doesn't have say No match

Only the cells that change are written, so the rest of the table keeps its formatting, notes and formulas.

If names don't match exactly

Merge by key matches keys exactly, after the cleanup options. When the two sides spell names differently, like "Acme Inc." and "ACME Incorporated", a fuzzy match is what you need, and Fuzzwell matches and joins lists by similarity.

What it costs

Tabmeld is $4.99 a month or $39 a year per Google account. Free trial: 14 days or 20 runs, whichever comes first. No card needed. Every plan and the install link are on the Tabmeld page.

Tabmeld: Combine, Merge & Compare Sheets

Combine, consolidate, compare and merge Google Sheets tabs and files in one add-on $4.99 a month or $39 a year per Google account.


Questions

Can I undo a merge?

Yes. Every merge makes a backup tab before it writes. Click Restore next to it in the sidebar's Backups card.

What happens if the data changed after the preview?

Tabmeld checks the plan again when you click Update table. If anything is different, it shows a fresh preview instead of writing.

Will it overwrite my formulas?

No. Formula cells are skipped, even with Overwrite chosen.

Can it add rows that are only in the lookup table?

Yes. Tick Add lookup rows with no match to the end. They're added below your table instead of over anything already there.


More Tabmeld guides


More Google guides