SheetCompareHow to Compare Two Google Sheets
Diff two Google Sheets, or two versions of one, and see exactly what changed by exporting and comparing.
Google Sheets has version history for a single document, but it can't show you a clean diff between two separate sheets, or between a Google Sheet and a file someone emailed you. For that you need to get both into a comparable format and run a real comparison.
The quickest path is to export each sheet to CSV (or Excel) and compare the two files. Because the export is plain tabular data, a diff can align rows by a key column and highlight every change, the same way it would for any spreadsheet.
- 1
Export each Google Sheet
In each sheet, choose File, then Download, then Comma-separated values (.csv) or Microsoft Excel (.xlsx). Do this for both sheets.
- 2
Drop both exports in
Put the first export on the left and the second on the right. Files are parsed in your browser and never uploaded.
- 3
Match on a key column
Pick the column that uniquely identifies each row so the comparison matches records by value. Row order between the two sheets then doesn't matter.
- 4
Review and export
Added, removed, and changed rows are color-coded. Export the result to Excel to share the differences.
Frequently asked questions
Can I compare two tabs in the same Google Sheet?▾
Yes. Export each tab separately to its own CSV or Excel file, then compare the two files.
Does this work for a Google Sheet versus an Excel file?▾
Yes. Export the Google Sheet to CSV or XLSX and compare it against the Excel file directly, cross-format comparison is built in.
Why not just use version history?▾
Version history shows edits within one document over time. It can't compare two distinct files, and it doesn't produce a shareable, exportable diff.