text.compare

Compare Excel and CSV files

Drop two .xlsx, .csv or .tsv files and open the Data tab to compare them as tables. Rows are matched by the first column when it holds a unique key, so sorting or reordering rows doesn't show up as a change. Each changed cell shows its old and new value.

Columns are matched by their header, and any column that was added or removed is listed separately. Excel workbooks are converted to CSV in your browser; nothing is uploaded.

How to compare spreadsheets

  1. Drop the two files, one on each side. Excel sheets are turned into CSV text.
  2. Open the Data tab to see added, removed and changed rows.
  3. Switch back to Side by side to see the raw text differences.

Questions

How are rows matched?

By the first column when its values are unique in both files, such as an id or SKU. Otherwise rows are matched by their order.

What about workbooks with several sheets?

Each sheet is included with a heading. The Data view works best with one sheet per file, so export the sheet you care about as CSV if needed.

Is my text uploaded anywhere?

Not to compare it. The comparison runs entirely in your browser, and the text you paste and the files you open are never sent to a server for that. There are no ads. The site counts visits with Google Analytics, which sees which page you opened, and keeps its own anonymous tally of what kind of comparisons are made (for example “a Word file, about 500 lines”), but neither ever sees the text you compare. If you copy a share link, the text is packed into the link itself, in the part after the # that is never sent to a server or to analytics. Your history and saves stay in your browser unless you sign in. If you do, they are uploaded to your account, but only after they are encrypted in your browser with a passphrase only you know, so nobody else can read them. The site stores your email address and that encrypted data, and can see how much you have saved but not what it says.

text.compare

Compare two texts and see exactly what changed. The comparison runs in your browser, and this site has no ads.

Privacy

Keyboard

F7 or Alt ↓
Next change
Shift F7 or Alt ↑
Previous change
Ctrl F
Find and replace in a side
Ctrl Z
Undo an edit or merge
Ctrl S
Save the comparison to your library
?
Show this help

Tips

Free and open source under the GNU AGPL-3.0 license, made by James Patton. Get the code on GitHub and host your own copy. If it saves you time, you can buy me a coffee.

Copy this

Your browser blocked automatic copying. Select the text below and copy it.