Spreadsheet tools

Compare spreadsheets

Find every difference between two versions of a spreadsheet: added, removed and changed rows, cell by cell, in a highlighted workbook.

FreeNo sign-upFiles deleted after processing

Choose files

The old file, then the new one; or one workbook with sheets = 'old, new'

Drop files here or choose filesCSV, Excel (.xlsx), Excel 97-2003 (.xls), Excel binary (.xlsb), JSON, OpenDocument spreadsheet, TSV · up to 25 MB each · up to 2 files

Options

Key

Column(s) identifying a row, comma-separated (e.g. Order ID). Empty: rows are lined up by content

Ignore letter caseTreat Pune and PUNE as equal

Tolerance

Numbers closer than this are equal (e.g. 0.01)

More options (8)

Sheets

Workbooks: empty for the first visible sheet, 'all' for every visible sheet, or sheet names or numbers separated by commas

HeaderThe first row holds the column names

Header row number

Row number of the column names, when there is a title above the table

Include hidden sheetsWith sheets = 'all', also read hidden sheets

Fill merged cellsRepeat a merged cell's value in every cell it covers

Detect numbers and datesCSV, TSV and JSON: read numbers, dates and TRUE/FALSE written as text as real values, when every value in the column fits

Delimiter

CSV input: the character between values

Ignore surrounding spacesTreat text that differs only in surrounding spaces as equal

Compare spreadsheets

1Choose files

2Options

3Get your result

Choose files

Options

Get your result