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

A wireless signal above a padlock

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].

A cloud with a vault dial at its centre

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].

A person holding two chain links apart

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].

A tangled green line leading to an arrow

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].

A hooded figure holding up three masks

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.

How 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.

Security lead advising a board

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 tester probing an application for weaknesses

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
Cyber security consultants planning hardening work

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
Security analysts monitoring systems around the clock

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 responders containing an attack

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
Scanner checking internet-facing systems for weaknesses

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
Rocket launching from a cloud

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.