Check a spreadsheet for errors
Scan an XLSX workbook or UTF-8 CSV up to 5 MB. Find saved errors and data issues, with locations and a separate report. Your file is not changed.
A real sample result
This is the report for a sample workbook, bookkeeping-sample.xlsx. It reads saved results and does not recalculate formulas.
118 cells scanned; 25 formulas scanned; 2 limits noted below.
- Error values: 1
- Whole-column references: 8
- Exact duplicate rows: 1
- Numbers stored as text: 2
- Leading or trailing spaces: 1
- Mixed data types within columns: 2
The other 11 checks found nothing in this file.
Where the report points
- Leading or trailing spaces: Transactions, C5
- Numbers stored as text: Transactions, E7
- Mixed data types within columns: Transactions, E7
- Exact duplicate rows: Transactions, A10
- Whole-column references: Summary, B2
- Error values: Summary, D5
A free report shows every error and the first place each other issue appears. 9 other locations are not shown here.
Not checked
- Formulas were not recalculated; results are as last saved: 25 cells
- Findings that rely on saved results, which may be out of date: 1 cell
What it checks
- Numbers typed directly into formulas
- Formula or value breaks its column pattern
- Error values
- Volatile functions
- References to blank cells
- Whole-column references
- External workbook links
- References to deleted ranges
- Text results among numeric formula results
- Exact duplicate rows
- Duplicate values in inferred key columns
- Dates stored as text
- Numbers stored as text
- Leading or trailing spaces
- Category casing differences
- Blank rows inside data
- Mixed data types within columns
What it does not check
- This is a static scan. It reads results saved in the file and does not recalculate formulas. Every report states this.
- Macro-enabled workbooks, older .xls files and password-protected files are not supported.
- The result states what was checked and what was not. A scan cannot establish that every result in the workbook is correct.
How it works
1. Choose a file
Sign in and upload an XLSX workbook or UTF-8 CSV up to 5 MB.
2. Read the scan
Review counts, findings, locations and the stated coverage. The scan reads saved results without recalculating formulas.
3. Review the report
The scan writes a separate report. For a simple data file, you can request cleanup and get a cleaned copy with a Changes sheet listing every edit.
Frequently asked questions
What can I see for free?
Free shows every count, every error and the first place each other issue appears. Pro shows every location and includes the report and cleaned files.
Will it change my original file?
No. It writes a separate report. Requested cleanup for a simple data file produces a cleaned copy with a Changes sheet listing every edit.
Does it recalculate formulas?
No. It reads the results saved in the file. Every report says the scan does not recalculate formulas and lists what was not checked.
Which files can I use?
XLSX workbooks and UTF-8 CSV up to 5 MB. Macro-enabled workbooks, older .xls files and password-protected files are not supported.
See what your file needs
Read the findings and coverage before deciding what to change.