ScrubDrop

ScrubDrop › Guides

A pre-send checklist for Office files: the ICO's sign-off requirement, automated

Last updated: 30 September 2026

Short answer: across its recent enforcement documents the ICO keeps asking for the same two things before a file is disclosed: a check of the file for hidden data, and a second person who signs it off. Strictly, the second is a recommendation rather than a legal rule — the ICO says so — but the Cabinet Office sets it as the expectation for central government spreadsheets. A tool can do most of the first step and give the second person a record to sign. It cannot do the reading.

Where the "sign-off" comes from

Four documents, in date order:

The ICO's current guidance, Disclosing documents to the public securely, frames the underlying duty in its checklists: you should "check documents appropriately before disclosing them, considering the circumstances, including the risk of harm". Its spreadsheet checklist lists, among the things you could do, using software tools to identify hidden data.

None of this is legal advice, and your own organisation's procedure is what binds you. But the direction is clear: check, then have someone else confirm the check.

The checklist

Before you start

  1. Choose the format. If the recipient needs figures, not a workbook, send CSV or a table in the letter. The ICO, the Cabinet Office and the PSNI's own post-incident guidance all point this way.
  2. Work on a copy made for sending, not the working file. In the PSNI case described on our FOI leaks page, the file sent was the file the analysis was done in.

Any Office file

  1. Document properties: author, company, last saved by, custom properties.
  2. Comments.
  3. Embedded files and objects. The ICO suggests keeping only a picture where the object itself is not needed.
  4. Custom XML data.
  5. Images: EXIF and similar metadata, which the ICO lists among what Document Inspector can find.
  6. Text formatted to be invisible, such as white on white. The ICO lists this as an ineffective technique to avoid.

Excel

  1. Hidden sheets, and very hidden sheets, which the Unhide command does not list.
  2. Sheets that are simply scrolled out of view along the tab bar.
  3. Hidden rows and columns, filters, and cells far from the visible table.
  4. Pivot tables and their caches.
  5. External links and defined names.
  6. File size: larger than the data would explain?

Details and sources for each are in our Excel guide.

Word

  1. Tracked changes: decide whether to accept or reject, and by whom — see accept or reject?
  2. Hidden text, headers and footers.
  3. Editing-session identifiers (rsid) where the document's ancestry matters — see our rsid guide.

PowerPoint

  1. Speaker notes on every slide.
  2. Off-slide objects and hidden slides or shapes.

Sign-off

  1. A second person repeats or reviews the check and records that they did, against a specific file.
  2. Someone reads the visible content of the final file — every page, sheet and slide.

What a tool can take over

Steps 3 to 19 are a search through the file's parts. That is mechanical, and it is where people miss things, because most of what they look for does not appear on screen. It is the part worth automating.

ScrubDrop does it in the browser; the file is not uploaded. It lists everything it finds in those categories for free. It flags white or tiny text and cells outside the print area but does not remove them, because only a person can tell whether they matter. When you ask it to remove categories, it rebuilds the file from what is known to be needed, then re-reads the result with separate parsers (fflate, xmldom, SheetJS and docx-redline-js) and will not offer a file that fails. The free version removes properties, comments and tracked changes from one file at a time; ScrubDrop Pro adds the structural categories, several files at once, rejecting tracked changes or choosing per author, and an audit report.

For step 20, the audit report is the useful part. It records, for each file, the SHA-256 of the original and of the file written, what was found, what was removed, what the re-check looked at and found nothing of, and anything it could not check. A reviewer can sign against that report and confirm, by the hash, that the file being sent is the file that was checked.

What a tool cannot take over

Office's own Document Inspector on Windows covers many of steps 3 to 19 and is a reasonable first pass; if you use it, write down what it reported, for the reviewer. On the Mac, Microsoft says Word has no document inspector.

How to check this yourself

  1. Save a copy of the file for sending.
  2. On Windows, run File › Info › Check for Issues › Inspect Document (Microsoft's instructions) and note what it reports.
  3. Work through the Excel, Word or PowerPoint items above by hand, including the ones the inspector does not cover.
  4. Hand the file and your notes to a second person, who repeats the check and reads the visible content.
  5. Record who checked which file and when, in whatever log your procedure uses.

Questions

Is a second-person sign-off a legal requirement?

Strictly, it is a recommendation rather than a legal rule. The Hammersmith & Fulham reprimand states that its recommendations are not legally binding, but the Cabinet Office guidance expects every disclosure by spreadsheet to be "reviewed by two separate individuals before a response is sent".

Should I send a CSV instead of a workbook?

If the recipient needs figures, not a workbook, send CSV or a table in the letter. The article says the ICO, the Cabinet Office and the PSNI's own post-incident guidance all point this way.

What can a tool check, and what can't it?

A tool can search the file's parts, which the article calls the mechanical part, and ScrubDrop lists what it finds in the browser without uploading the file. Free: one file at a time; every kind of hidden data is listed, and properties, comments and tracked changes are removed. It does not decide whether visible text is sensitive and does not read text inside images, so a second person still reads the visible content of the final file.

Run the mechanical part of the check in your browser. Free: one file at a time; every kind of hidden data is listed, and properties, comments and tracked changes are removed. Check a file.