File Check
Give it a report. Get a list of what will trip up a script or a pivot table, with the cells each thing is in and what to do about it.
- Runs in your browser
- Opens no connection
- Changes nothing in the file
This tool works in your browser, so it needs scripts turned on.
No connection can be opened from this page
Choose a file
An Excel workbook (.xlsx or .xlsm) or a CSV file. The page reads it inside your browser and changes nothing in it.
Drop a workbook or a CSV file here
The sample report is a small workbook of invented visits with the usual kinds of mess in it. It is a good first run.
Go through the list
What needs fixing comes first. Each thing names its cells and says what to do about it.
Take the list
The same list as plain text, to keep or to hand to whoever will fix the file.
When to run the check
Before a pivot table
A pivot table needs one row of headings, a heading on each column, and no empty rows. The list says where a sheet falls short of that.
Before a script or a bot
A script stops on the one cell that is text in a column of numbers. The list names that cell before the script meets it.
Before asking for help
The list holds no value from a cell, so it can go into a chat or a ticket to say what is wrong with a file.