Free Online Diff Tool to Compare Two Excel Spreadsheet Files
How to compare two excel files for differences?
Using this free web tool, you can compare any Excel / Calc document easily. Just select first/original file in left window and second/modified file in right window. Your data will automatically be extracted. First sheet is automatically selected and you can change it in the dropdown.
Alternatively you can also copy and paste directly into left and right windows.
After that click on Check button to find diff. The Diff data will be highlighted in a nice format.
You can export the diff as .csv file or .xls file.
For Excel export, you must have Excel or compatible spreadsheet application installed.
Otherwise you can also select all (
Ctrl-A) and copy (
Ctrl-C) and then paste in your spreadsheet software (
How to Compare two excel sheets in same file
To diff two sheets, you can upload same file for both original/modified section and choose sheet accordingly from the dropdown.
What does +++/— indicate?
- +++ This has been added in second/modified file.
- — This has been removed in second/modified file.
What spreadsheet file formats does this Excel diff tool support?
This tool can read following worksheet/workbook formats:
- Excel 2007+ (XLS/XLSX/XLSM/XLSB)
- Delimiter-Separated Values Text files (CSV/TXT) (Use CSV Compare tool if CSV parsing fails)
- Data Interchange Format (DIF)
- OpenDocument Spreadsheet (ODS/FODS)
- HTML Tables
Does this compare against formulas?
No, this tool only does value based comparisons. Two files are compared per row/column wise. So, to get better results your sheets should be organized (sorted/ similar column layout).
What about my data?
This is a web based tool. All data extraction/comparison is done in the browser itself. Nothing is uploaded to our server if you are only comparing.
However, if you want to share results with others, you must choose to save the result. (Feature under development)
You’ll be given a unique URL for your result & your result will be viewable to anyone with that unique URL.