I will compare two google sheets tabs and create a clean diff report

China

I speak Chinese, English

Google Sheets and Apps Script Automation Engineer

Software engineer with 19 years of experience — including a decade building trading and market-data clients for securities firms and a fixed-income platform on Tencent QiDian — now focused on Google S...
About this Gig

Manually eyeballing two Google Sheets to find what changed is slow and error-prone and it gets worse as the rows grow.


I'll build you a Google Apps Script that compares two tabs by a key column and produces a clean Diff Report: rows only in Sheet A, rows only in Sheet B, and rows with the same key but a mismatched value. Row order doesn't matter, and your source tabs are never touched.


It runs from a simple custom menu inside your sheet no add-on, no monthly tool. The script is yours to keep.


What you get:

A working Apps Script installed in your sheet

A one-click "Compare" menu that writes a clean Diff Report tab

Clear setup steps + a short screen recording of it running


Great for: reconciling exports, inventory/SKU lists, customer/contact lists, price lists, and finance/operations checks.


Standard adds duplicate-key detection, multi-field mismatch, and a custom menu button. Premium adds scheduled auto-runs and a daily/weekly Gmail summary, so it just runs itself.


Message me your two-sheet structure and I'll tell you within an hour if it fits usually delivered within 1-2 days.

Technology:

Google Sheets

Expertise:

Data manipulation

Data validation

My Portfolio