Spreadsheet Compare Tools

Choose between CSV Diff and Spreadsheet Diff

Use CSV Diff for a delimited table. Use Spreadsheet Diff for a workbook with named sheets. The input structure determines what the comparison can inspect.

• CSV Diff compares two CSV, TSV, or other delimited tables. It detects headers and delimiters, matches rows by key columns or position, and reports added, removed, and changed rows and cells. Its policies cover case, whitespace, numeric values, and column order. You can export the result.
• Spreadsheet Diff compares two .xlsx, .xlsm, .xls, .xlsb, or .ods workbooks sheet by sheet. It compares dimensions, headers, formulas, and displayed values. Cell-formatting comparison is optional, and rows can be matched by key column or coordinate.

Compare CSV files by row and cell

CSV Diff reads each input as a delimited table. It detects headers and delimiters before matching rows. Key-column matching connects records through an identifying column when their positions differ. Position matching compares rows in order.

Comparison policies set how values and layout are checked. Case and whitespace policies affect text comparisons. Numeric policies affect number handling, while column-order policies affect the column-layout check. The report separates added and removed rows from changed rows and cells, and you can export it.

Compare workbook files sheet by sheet

Spreadsheet Diff reads workbook files sheet by sheet. It matches sheets by name and compares each sheet's dimensions, headers, formulas, and displayed values. You can include cell formatting when formatting changes are part of the review.

Use key-column matching when a row has an identifying value and its position may change. Coordinate matching checks cells at their worksheet locations, so the cell's position controls the comparison.

Choose row, cell, or sheet matching

Compare delimited exports by key column when record positions differ. CSV Diff shows changed cells alongside added and removed rows, then lets you export the result.

Compare workbooks with several sheets by matching sheets by name. Spreadsheet Diff checks formulas and displayed values, and can include formatting in the comparison.

Compare a TSV by position when row order is meaningful. CSV Diff then separates added, removed, and changed records.

Use Spreadsheet Tools for broader spreadsheet tasks

Use Spreadsheet Tools when you need to clean, validate, or convert CSV, TSV, and Excel files. Choose Spreadsheet Compare Tools when you have two inputs and need their differences organized by rows, cells, or workbook sheets.

Frequently asked questions