Spreadsheets
Redacting spreadsheets safely
A spreadsheet that looks clean on screen can carry personal data in places nobody sees. Treat every export as a file to inspect, not a page to read.
Last reviewed against Information Commissioner's Office, GOV.UK and DLA Piper. Sources

The case
A council's FOI file
Southend-on-Sea City Council uploaded a spreadsheet on 17 May 2023 in answer to a Freedom of Information request, believing it held only anonymised job role data [11]. The Register reported that it could be interrogated to reveal personal and special category data for current and former staff, and that more than 2,000 people were affected [11]. The ICO's enforcement page records a reprimand dated 14 October 2024 [10].
What the ICO says
Three tiers
The ICO's spreadsheet checklist separates what you must, should and could do [6].
Must
Have policies for disclosing spreadsheets securely, use secure methods such as passwords and secure redaction, and meet your information access obligations when removing data [6].
Should
Train staff, avoid ineffective concealment, check for hidden personal information before disclosure and know how to deal with pivot tables, charts and external links [6].
Could
Use software to find hidden rows, columns, sheets and filters, convert to a simpler format such as CSV, and check that file size fits the volume of data you meant to release [6].
Ineffective tricks
What not to rely on
The checklist names hiding rows, columns or worksheets, moving data to remote cells and edit-only passwords as ineffective concealment [6]. If the data must not leave, it should not be in the file you send.
A cheap check
Compare the file size with what you expect for the rows you meant to release. The ICO's checklist suggests this as one way to spot embedded data [6].

Practical rule
Send a new file
Build the release file from scratch with only the fields required, rather than hiding fields in the working file. Then run the checks above on that new file. See the review workflow for who signs it off.
Keep reading
Read next
Exemptions
The exemptions that justify withholding material from an access request, how prejudice works and what to tell the requester, per the ICO.
Read the guide
Third party names
When to redact another person's name in a disclosure: the ICO's three questions, confidentiality, staff and what the requester already knows.
Read the guide
Undoing redaction
Why a blacked-out file can still reveal text, what the ICO advises on saving new files and checking paper, and how to test before release.
Read the guideHow CyPro can help
Need a hand getting ready?
Reading the rules is one job. Mapping them to your organisation, closing the gaps and showing the evidence are several more. CyPro's consultants can take any of them off your plate.
Fractional CISO for the board
A senior security lead who advises the board on what to fix first, what to accept and what to tell customers, and owns the decision record.
More on cypro.co.uk
Penetration testing
A focused test of your systems and the controls around them, so you know they hold before an attacker finds out for you.
More on cypro.co.uk
Hardening and segmentation
Our consultants put the controls in place that limit the damage when something is missed: firewall rules, network isolation and tighter admin access.
More on cypro.co.uk
24/7 security monitoring
Our SOC analysts watch your systems day and night for the signs of an attack in progress: unexpected processes, new outbound connections, logins that do not fit.
More on cypro.co.uk
Incident response
If you may already be compromised, our responders contain it, preserve the evidence, find out what was touched and get you running again safely.
More on cypro.co.uk
Vulnerability scanning
Find every internet-facing system you run, including the forgotten ones, and see which are still on a vulnerable build.
See the scanning service
Get ready
Need to know what this means for you?
A disclosure that leaks, or a redaction you cannot explain, becomes a complaint to the ICO. A GDPR consultant can review your disclosure workflow, exemption log and release checks before a request tests them.