Drop in the workbook the business runs on. Get a dry health report back, worked out in your browser.
Four tabs called FINAL. One is.
Drop in an .xlsx or .csv, or try the sample. It's read here, in your browser. Nothing is uploaded or kept.
The sample is a made-up workbook: Q3 numbers FINAL (1).xlsx
health report
The report shows here.
Drop a workbook in, or try the sample. The report is the same either way: dry.
A first look, not an audit. It reads what is in the cells, not what the business meant by them. Password-protected files and the old .xls kind won't open; save a copy as .xlsx first.
Downloads propellr-xray-reminder.ics. Opens in Outlook, Google or Apple calendars. No sign-up, no email.
9:00Run the X-ray againpropellrco.com/tools/xray
How this works
An .xlsx is a zipped folder of plain text. Your browser unzips it and reads each tab's cells, their sums and their shading. Nothing leaves the page: there is no upload and nothing is stored, so closing the tab is the end of it.
Tabs like FINAL = tab names with FINAL, v2, copy, old, (1) or "use this" in them Typed over = a typed number sitting between sums in the same column Spelled two ways = the same once spaces, capitals and full stops are tidied, different as typed
Errors are the cells showing #REF!, #DIV/0!, #N/A and the rest, plus sums that point at a tab or file that has gone. Numbers stored as text are the ones a sum quietly skips. Colours counts the cells with a fill, and how many different fills, since a key is rarely kept.
The sample is made up. Run through the same checks it finds 4 tabs like FINAL, 11 sums typed over, 6 error cells and 23 names spelled two ways. A .csv has no tabs, sums or colours, so only the errors and the doubles are checked.
It leaves out whether the sums are the right sums. That one needs a person, and usually a cup of tea.
We did one like it
The work · Advise
Eleven trackers. Keep, fix or replace?
A spreadsheet system only one coordinator understood, and an owner who wanted rid of it without losing what was in it. We looked before anyone rebuilt: a decision for every tracker, the rules written down, and a brief for the build.