Skip to content
SheetCompare is in private beta.Join the beta →
SheetCompare
Menu

Docs

Documentation

Everything you need to run a comparison and read the result.

Getting access

SheetCompare is in private beta. Beta testers receive access instructions by email after requesting access.

Run a comparison

  • Open your spreadsheet and start SheetCompare from the Extensions menu. A sidebar opens.
  • Choose the old tab and the new tab.
  • Choose the key column for each tab, the column that identifies a row, such as an ID or email.
  • Optionally turn on the settings to ignore extra spaces and capitalization.
  • Click compare. A new report tab is created and selected when it finishes.

Reading the report

The top of the report shows the tabs compared, the key column, the time, and the totals. Below is one row per difference:

  • Status: added (only in the new tab), removed (only in the old tab) or changed.
  • Key: the value that identifies the row.
  • What changed: the columns that differ.
  • Old value / New value: the values before and after.
  • Go to old tab / Go to new tab: links to the matching rows.

Unchanged rows are counted in the summary but not listed.

How rows are matched

  • Rows are matched by key, so sorting or inserting rows doesn't matter.
  • Keys ignore leading and trailing spaces and are case-insensitive when you enable those options.
  • A number stored as text, such as "1001", matches the number 1001. Text with leading zeros, such as "007", stays text.
  • Only columns present in both tabs are compared. Columns that exist in just one tab are listed as not compared.
  • Dates are compared by their exact date and time.

If the run stops

SheetCompare stops, instead of guessing, when a key is blank or duplicated, when a header row is empty or has duplicate or blank names, or when a tab is too large. The message lists the row numbers or the problem to fix. Your original tabs are not changed.

Limits

  • Tested with up to 100,000 rows and 600,000 cells per tab.
  • The report lists up to 30,000 differences. If there are more, it says so at the top.
  • Google limits how long a script can run (about 6 minutes), so very large comparisons may be slow or stop.

Not supported yet

  • Excel files, and comparing two separate spreadsheet files directly.
  • Exporting the report as a PDF.

More questions? See the FAQ or Support.