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.

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.

ToolCleaner CopyWhen someone needs the shape of the whole report, make a copy with randomized values.