Group accounts administrator
You want to be able to open the right spreadsheet version after an error or a device failure. The National Cyber Security Centre recommends testing backups by opening files from them.
Start with a backup process that lets you restore an earlier spreadsheet version; one SSD with one copy is not a complete backup strategy. The National Cyber Security Centre recommends keeping multiple versions of important data and checking that you can restore them. Then compare the connections, capacity you need and appropriate access controls. A higher advertised speed alone is no guarantee of a better recovery.
You want to be able to open the right spreadsheet version after an error or a device failure. The National Cyber Security Centre recommends testing backups by opening files from them.
If your spreadsheets contain personal data, security measures should match the risks, and it should be clear who has access. The UK Information Commissioner's Office highlights that appropriate measures depend on the processing involved and the privacy risks.
When several volunteers use different computers, connections, formatting and arrangements for managing the backup are important considerations.
First decide which versions you need to be able to restore and who needs to be able to do it. Then take stock of the computers and the storage space you need.
| Priority | What should you check? | Who should give this more weight? |
|---|---|---|
| Restorable versions | Decide which spreadsheets you need, how long to keep earlier versions and who will carry out restore tests. | If I need to restore an earlier spreadsheet after an error, I want to know that the right version has been kept and that I can open it. Around 36% of consumers prioritise recoverability. |
| Data protection | Establish whether the files contain personal data, who needs access and which measures are appropriate for the risks. | If the drive contains personal data, I want to be able to decide who can open the backup and how a successor can get access. Around 29% of consumers prioritise confidentiality. |
| Connection and compatibility | Check USB-A or USB-C connections, supplied cables and adapters, formatting and recovery software on the computers you use. | If volunteers use different computers, I want the drive to work with those devices. Around 21% of consumers prioritise compatibility. |
| Capacity and use | Consider the size of your current files, expected growth and how many versions you want to keep. | I want enough space for my backup plan without choosing storage or speed as an end in itself. Around 14% of consumers prioritise suitable capacity. |
If the only drive is lost or fails, the backup could be lost too. The National Cyber Security Centre recommends keeping multiple versions of important data and storing a copy in a different location.
Plan your copies and where they will be stored before choosing an SSD. Then test whether you can actually restore and open a spreadsheet.
A second copy, a separate storage location and time for restore checks can all be part of your process.
Advertised sequential speeds depend on factors such as the computer and how you use it. They do not show how quickly small spreadsheet files will copy in your setup.
First check the connection and test that the backup and restore work on the computer you use.
A protected backup will not help with recovery if authorised volunteers cannot access the drive or the necessary login details.
Record who has access and test restoring files with your chosen security settings. If the files contain personal data, make sure your measures match the risks.
The T7 Shield is worth considering if you carry your drive around frequently and password protection is important to you.
The XS1000 is a compact option to consider if you use different computers and connections.
The X9 is worth considering if simple USB-C storage and support for your existing backup software suit the computers you use.
These product picks focus on external SSD storage for spreadsheet backups, with capacity and connections in mind, as well as security features where specified.
No image available
An option for groups looking for an external SSD with a USB-C connection.
It is listed with 1 TB of storage, USB 3.2 Gen 2 and compatibility with Windows and macOS. The product description mentions drop protection from heights of up to 2 metres.
No image available
This version is suited to anyone looking for 2 TB of storage and password protection for an external backup drive.
The description lists AES 256-bit hardware encryption, USB-C, USB-C-to-USB-C and USB-C-to-USB-A cables. It also mentions drop protection from heights of up to 2 metres.
No image available
This version is an option for groups considering a 1 TB external SSD with password protection.
The description lists AES 256-bit encryption, USB-C, USB-C-to-USB-C and USB-C-to-USB-A cables, and compatibility with Windows and macOS.
No image available
An option for groups looking for a 2 TB external SSD that they can carry around regularly.
The description lists IP65 protection, drop resistance from heights of up to 3 metres and password protection. Compatibility with Macs, PCs, Android devices and games consoles is also mentioned.
One SSD with one copy does not protect you if that drive is lost or fails. For important data, the National Cyber Security Centre recommends keeping three copies on two types of media, with one copy stored elsewhere. This is a recommendation, not a specific legal requirement for SSDs.
Restore a file and open it to check that recovery works. The National Cyber Security Centre recommends checking both the recovery process and the restored files.
It depends on the data and the risks; there is no single setting that suits every group. If the group processes personal data, its security measures should match the risks. The UK Information Commissioner's Office gives the loss of a device containing unencrypted personal data as an example of a personal data breach.
No. Losing a device does not automatically mean you have to report it. If personal data is involved, the organisation must assess the circumstances and the risk. According to the UK Information Commissioner's Office, a report is required unless a risk to people's rights and freedoms is unlikely.