Update one spreadsheet from another — without writing XLOOKUP.
Merge & Update matches rows between your tables, refreshes only the columns you pick, and adds records that aren’t there yet. You review change counts and a sample of the result before applying a manual merge.
14-day full-feature trial, no card required. Your spreadsheet contents stay inside Google.
Example: refresh customers from a weekly export
Illustrative sample data — not a customer result.
| Phone | Plan | ||
|---|---|---|---|
| 2 | ada@example.com | 555-0100 | Starter |
| 3 | grace@example.com | Starter | |
| 4 | alan@example.com | 555-0133 | Pro |
| Phone | Plan | ||
|---|---|---|---|
| 2 | ada@example.com | 555-0188 | Pro |
| 3 | grace@example.com | 555-0121 | Starter |
| 4 | alan@example.com | 555-0133 | Pro |
| 5 | katherine@example.com | 555-0147 | Starter |
Three steps in the sidebar.
The add-on opens beside your sheet. Nothing is written until you confirm the preview.
Choose your tables
Pick the main table that receives updates, then one or more lookup tables — other tabs, or other spreadsheet files from your Drive.
Match and map columns
Match on email, SKU, or a combination of columns. Then map which lookup columns update existing columns and which become new ones.
Preview, then merge
See how many rows and cells change, approve the overwrite explicitly, and apply. Run it again any time, or on a schedule.
Built for the messy parts of real spreadsheets.
Single or composite keys
Match on one column, or several columns together when no single field is unique.
Several lookup tables
Add multiple lookups, across different spreadsheet files, processed in the order you arrange them.
Update or fill only
Replace existing values, or restrict the merge to cells that are currently empty.
Append what’s missing
Lookup rows with no match can be added to the bottom of the main table, and unmapped columns can become new columns.
Multiple matches, handled
Use the first match, append the extras, or insert them beside the matching row.
Preview and confirmation
A sample of the result plus row and cell counts, with an explicit approval step before anything is written.
Backups and highlighting
Optionally back up the main tab before a merge, highlight changed cells, and add a row-status column.
Formula-safe
Formulas outside the merged columns are left untouched, and imported text that looks like a formula stays literal text.
Saved workflows
Save a configuration, edit or delete it later, and export or import workflows as JSON.
Scheduled runs
Daily, weekly, and monthly schedules — including patterns like the last Monday — with pause, resume, and run history.
One plan. Per user, across all of your spreadsheets.
Free trial
- Every feature unlocked
- No credit card required
- Saved workflows are kept if the trial ends
Pro
or $3.99 / month
- Saved workflows and scheduled merges
- Multiple lookup tables and cross-file merges
- Licensed per user, for every spreadsheet you work in
- Email support
Merges run inside your Google account, so Google’s Apps Script execution limits (runtime and daily quotas) apply to large jobs.
Questions people ask first.
Do I still need XLOOKUP or VLOOKUP formulas?
No. You choose the tables and columns in the sidebar, and the add-on writes values directly into your main table. Because the result is values rather than a formula chain, it doesn’t break when rows move or a source file is renamed. Formulas you already have outside the merged columns are left alone.
Can it pull from other spreadsheet files?
Yes. Lookup tables can be other tabs in the current file or tabs in other spreadsheets — found through Drive search or by pasting a spreadsheet URL. You can add several lookups and set the order they run in.
What if a merge goes wrong?
Each manual merge starts with a preview: a sample of the result and counts of the rows and cells that would change. You have to approve overwriting existing values explicitly before anything is written. You can also back up the main tab automatically before each run, highlight changed cells, or write results to a new spreadsheet instead of the original.
Can merges run automatically?
Yes. Save a workflow, then schedule it daily, weekly, or monthly — including patterns like the last Monday of the month. Schedules run under your Google account, can be paused and resumed, and keep an execution history. Google may delay a scheduled run, and failed runs pause so you can inspect them.
What happens to my data?
Your spreadsheet contents stay within Google: the add-on reads and writes through Google Sheets™ in your own account, and table data isn’t sent to Codeprint. Codeprint does handle account and plan information — your Google account email and your entitlement — so we can tell whether you’re on a trial or a paid plan. See the Privacy Policy for details.
How big a merge can it handle?
Merges execute in your Google account under Apps Script’s runtime and quota limits, so very large tables may need to be split into smaller ranges or runs. Choosing an explicit range instead of a whole sheet usually helps.