Who is this relevant to?

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.

Membership data administrator

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.

Group with rotating volunteers

When several volunteers use different computers, connections, formatting and arrangements for managing the backup are important considerations.

What should you look for?

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.

Common pitfalls

  • Assuming one drive is a complete backup strategy

    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.

  • Assuming a high MB/s rating means better recovery

    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.

  • Choosing password protection without arranging access for successors

    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.

Brands to consider

Samsung

The T7 Shield is worth considering if you carry your drive around frequently and password protection is important to you.

  • Samsung lists IP65 protection, USB 3.2 Gen 2 and AES 256-bit hardware encryption with password protection for the T7 Shield 1 TB.
  • These features are no substitute for a second backup or a restore test. Also arrange how authorised successors will get access.

Kingston

The XS1000 is a compact option to consider if you use different computers and connections.

  • Kingston's datasheet lists 1 TB and 2 TB versions, as well as a USB-C-to-USB-A cable with an adapter.
  • The quoted transfer speeds are manufacturer specifications and also depend on the computer. For sensitive files, check separately how the backup is protected.

Crucial

The X9 is worth considering if simple USB-C storage and support for your existing backup software suit the computers you use.

  • For the X9 1 TB, Crucial lists support for Windows File History and Apple Time Machine, with exFAT as the default format.
  • Before transferring files, check that the computer and formatting suit your setup.

External SSDs at Joybuy

These product picks focus on external SSD storage for spreadsheet backups, with capacity and connections in mind, as well as security features where specified.

Portable SSD 1 TB

Portable SSD 1 TB 1000 MB/s

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.

View at Joybuy
Samsung Portable SSD T7 2 TB, blue

Samsung Portable SSD T7 2 TB USB Type-C 3.2 Gen 2, blue

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.

View at Joybuy
Samsung Portable SSD T7 1 TB, blue

Samsung Portable SSD T7 1 TB USB Type-C 3.2 Gen 2, blue

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.

View at Joybuy
Samsung MU-PE2T0R 2 TB USB Type-C 3.2 Gen 2, blue

Samsung MU-PE2T0R 2 TB USB Type-C 3.2 Gen 2, blue

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.

View at Joybuy

Frequently asked questions

Is one external SSD enough for a backup?

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.

How can you check that a spreadsheet backup works?

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.

Should a community group encrypt an external SSD?

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.

Does losing an SSD always have to be reported to the UK Information Commissioner's Office?

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.