Compare Excel files and CSV spreadsheets

Compare two XLSX or CSV files by row position or a key column. Find changed cells, added and removed rows, then download a CSV report.

Processed in your browser: your data are not uploaded.

Set your data

First file No file selected Worksheet

Second file No file selected Worksheet

Mode

Key column number

First row contains headersIgnore surrounding whitespaceIgnore letter case

XLSX or UTF-8 CSV: up to 10 MB per file, 10,000 rows, 256 columns and 200,000 cells per sheet. Compares saved values, not formulas, formatting or macros. Select each worksheet separately.

10 MB per file; 10,000 rows, 256 columns and 200,000 cells per sheet. Empty or duplicate keys are rejected. Up to 100,000 differences, with 500 in the preview. Saved values only; formulas are not recalculated.

Result

Enter your values to see the result.

Download result

We count which tools are used most, without including entered values or file contents in the statistics. Privacy

How to use it

Select two XLSX or UTF-8 CSV files and their worksheets. Compare by position or specify a key column numbered from 1. Set header, whitespace and case options, then download the report.

Method

Position mode compares matching row and column positions. Key mode matches unique identifiers even after rows are reordered. Changed cells, added rows and removed rows have separate counts.

Reading the result

A reordered row can look different in position mode. Use a unique key to follow it independently of position. Numbers are compared as saved text values: 1 and 1.0 may differ.

Worked example

Input: id,value A,10 B,20 → id,value B,20 A,12 C,30
Result: A: 10 → 12; C: +30

Position mode compares matching row and column positions. Key mode matches unique identifiers even after rows are reordered. Changed cells, added rows and removed rows have separate counts.

Limits and data handling

Processing takes place in your browser. The tool does not save the values you enter.

Sources

RFC 4180 — CSV

Frequently asked questions

How do I compare reordered rows?

A reordered row can look different in position mode. Use a unique key to follow it independently of position. Numbers are compared as saved text values: 1 and 1.0 may differ. Processing takes place in your browser. The tool does not save the values you enter.