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
-
Open Merge sheets by key from the Tabmeld menu.
-
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.
-
Add the key columns under Match rows by. Use more than one if a single column isn't unique.
-
Under Bring over, choose for each lookup column: update the column of the same meaning in your table, Add as new column, or Skip.
-
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.
-
Set the extras if you want them: Add lookup rows with no match to the end, and Add a "Match" column (Matched / No match).
-
Set Matching options: ignore case, extra spaces or punctuation in the key, so
ABC-123with a trailing space andabc-123count as the same key. -
Click Preview. It lists every cell edit, new column and new row.
-
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.
| Choice | Result |
|---|---|
| Price: update Price, Fill empty cells only | Blank prices are filled; prices you set stay |
| Stock: Add as new column | A Stock column appears with each SKU's stock |
| Add a "Match" column | Rows 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
- How to compare two Google Sheets for differences
- How to consolidate data from multiple sheets in Google Sheets
More Google guides
- How to move GA4 Reports Builder reports to Trafficledger (Trafficledger)
- How to make a copy of a template tab for each name in a list (Tabherd)
- How to email each person only their rows from a Google Sheet (Scheduled Sheet Reports)
- How to show dotted-line reporting on an org chart from Google Sheets (Rowtree)