A spreadsheet diff tool lets you compare two spreadsheets or CSV files side-by-side at the cell level — instantly seeing which rows were added, removed, or have changed values. Business analysts, data teams, and anyone who works with tabular data use spreadsheet diffs to audit changes, validate exports, and reconcile datasets without manual row-by-row checking.
Diff Results
How to Use the Spreadsheet Diff Tool
Manually comparing two versions of a spreadsheet is error-prone and time-consuming. A spreadsheet diff automates this by parsing both datasets into a grid and highlighting every change at the cell level — so you can instantly see what changed, what was added, and what was removed.
Step 1: Paste or Upload Your Data
Paste your original spreadsheet data into the left panel and the updated version into the right panel. You can paste directly from Excel, Google Sheets, or any CSV editor. The tool auto-detects whether your data is comma-separated (CSV), tab-separated (TSV), or semicolon-separated. Alternatively, click "Upload file" to load a .csv, .tsv, or .txt file directly.
Step 2: Click Compare
Click the Compare button to run the diff. The tool detects header rows (the first row is treated as headers if it contains non-numeric values). Rows are matched by their first column value when possible, so reordered rows are still correctly identified as matches rather than remove+add pairs.
Step 3: Read the Color-Coded Results
The diff grid uses three colors: green cells or rows were added in the updated dataset, red cells or rows were removed from the original, and yellow cells have changed values. Hover over any yellow cell to see a tooltip showing the original value. The summary row above the table shows total rows added, removed, cells changed, and rows unchanged.
Exporting Results
Use the "Export Diff" button to download a CSV file with a Status column added (ADDED, REMOVED, CHANGED, UNCHANGED). This lets you filter and analyze changes in your spreadsheet application. The "Copy Diff" button copies the diff table to your clipboard as tab-separated text, ready to paste into Excel or Google Sheets.
Common Use Cases
The spreadsheet diff tool is useful for comparing database exports before and after a data migration, auditing changes to financial data over time, reconciling two versions of a customer or inventory list, verifying that a data transformation produced the expected output, and checking whether a vendor's data feed changed from the previous delivery.
FAQ
Is the spreadsheet diff tool free?
Yes, completely free with no account required. All comparison logic runs in your browser — your data is never sent to any server.
Is my spreadsheet data private?
Yes. The diff algorithm runs entirely in client-side JavaScript. Nothing is uploaded or stored. You can safely compare confidential financial data, customer lists, or proprietary business data.
Can I compare Excel files?
You can compare Excel data by first saving your file as CSV (File > Save As > CSV in Excel or Google Sheets) or by copying cells and pasting directly into the text areas. The tool auto-detects comma, tab, and semicolon delimiters.
What file formats does the tool support?
The tool accepts CSV (comma-separated), TSV (tab-separated), and semicolon-separated formats. You can paste data directly or upload .csv, .tsv, or .txt files using the file upload buttons.
How does the cell-level comparison work?
The tool parses each input into a 2D grid, then aligns rows using the first column as a key (if values look like identifiers). Each cell is compared individually. Green cells are new in the second dataset, red cells were removed, and yellow cells have changed values. Hover over a changed cell to see the original value.
What does the Export Diff button do?
The Export Diff button downloads a CSV file with all differences annotated. Each row includes a Status column (ADDED, REMOVED, CHANGED, UNCHANGED) so you can filter and analyze changes in your spreadsheet application.
Can I compare spreadsheets with different numbers of columns?
Yes. If one spreadsheet has more columns than the other, the extra columns are shown as added or removed. The tool aligns data by column position, and the header row (if detected) is used to label columns in the diff view.