Who is this guide for?

Anyone who wants to restore spreadsheets safely

If you want to restore an earlier version after a mistake, deletion or fault, a tested backup routine is more useful than a high speed rating. The National Cyber Security Centre recommends keeping multiple versions of important files; you should also test that you can restore them.

Anyone short on desk space

You’ll want a drive that takes up little room and, ideally, works without a separate power adaptor, so it won’t get in the way during everyday use.

Anyone using Windows and Mac

If you want to share files between computers or back them up on different systems, check not only the cables but also the format required by your chosen backup method.

What should you consider when choosing?

First, decide how you want to keep and restore versions. Then choose the storage capacity, size and connection to suit your computer and workspace.

What to consider What should you look for? Who is this important for?
Restorable versions Decide how you’ll back up spreadsheet folders and earlier versions, and test that you can restore a file. If I need an earlier version after making a change or deleting something, I want to be sure the right folders are included. Around 26% of consumers give recoverability their highest priority.
Storage capacity Count the folders you want to keep and decide how many versions you need; then compare this with the capacity of the exact model. If I want to keep other folders and older versions as well as spreadsheets, I’ll focus on how much space my backup plan needs. Around 26% of consumers prioritise capacity.
Desk space Check the dimensions, where the cable connects and whether the drive needs a separate power supply. If I have little free space on my desk, I want a drive that fits easily beside my computer. Around 21% of consumers say a small workspace is a deciding factor.
Connection and operating system Check your computer’s ports, the cables included and the drive format required by your backup method. Apple recommends APFS or APFS Encrypted for a new Time Machine drive. If I want to use the same drive with different computers or backup methods, the connection and format need to be suitable. Around 16% of consumers prioritise system compatibility.
Confidential files Check whether your backup method offers encryption and access restrictions, and where you’ll keep an additional copy. If my spreadsheets contain information that isn’t meant for everyone, I want to restrict unauthorised access to the backup. Around 11% of consumers give confidentiality their highest priority.

Common pitfalls

  • Assuming a copied file is a tested backup

    A successful copy doesn’t prove that the right folders and versions can be restored later.

    Set up version history and try restoring a spreadsheet from your backup.

  • Confusing file sharing with Time Machine compatibility

    A pre-formatted drive may be suitable for ordinary file access, while Time Machine may require a different drive format.

    Before using the drive, decide whether you want to share files or set it up as a Time Machine destination. Save any data already on it before reformatting, as this may erase it.

  • Making top SSD speed your main reason to buy

    A maximum sequential speed measured under the manufacturer’s test conditions doesn’t tell you how long it will take to back up small spreadsheets.

    Choose based first on your restore method, required capacity, format and connection. Speed matters most if you’ll also be transferring large files.

  • Assuming the manufacturer’s warranty covers data recovery

    Your statutory rights if a product is faulty and an additional manufacturer service are two different things. Seagate states that the Rescue service mentioned isn’t available in every country.

    Check the terms for the exact model and keep a separate backup of important files.

Brands to consider

Seagate

The Expansion Portable is a portable HDD designed for a one-USB-cable set-up.

  • According to Seagate, the drive is powered via USB, so there’s no need for a separate power adaptor. The product listing reviewed specifies a 2 TB model, STKM2000400.
  • The product information says the Rescue service isn’t available in every country; check the terms for use in the Netherlands. Also bear in mind that an HDD can be more susceptible to knocks if you move it around often.

Toshiba

The Canvio Flex range is designed to provide file access across compatible Windows, Mac and other devices.

  • Toshiba lists USB-A and USB-C cables as included, with 1, 2 and 4 TB models available.
  • A pre-formatted drive for sharing files between devices isn’t automatically ready for a new Time Machine backup. Apple recommends APFS or APFS Encrypted for this.

Crucial

The X9 is a portable SSD for anyone short on desk space or who regularly takes their drive with them.

  • Crucial lists the X9’s dimensions as 65 × 50 mm and says it supports Windows File History and Apple Time Machine.
  • You may need to use a different format for Time Machine. The read speed of up to 1.050 MB/s listed by Crucial is a maximum manufacturer measurement on a test computer, not a promised speed for spreadsheet backups.

Samsung

The T7 Shield is a portable SSD for anyone who regularly uses their drive away from their desk too.

  • For the 1 TB blue model, MU-PE1T0R/EU, Samsung lists an IP65 rating and drop resistance of up to 3 metres.
  • These are manufacturer specifications, not a guarantee against data loss; keeping a second backup is a separate precaution. The stated sequential speed is mainly relevant if you also transfer large files.

Joybuy products

These product picks are portable external SSDs and HDDs for storing spreadsheet backups and other files.

SanDisk Portable SSD 1TB

SanDisk Portable SSD 1TB

A portable SSD option for anyone who wants to store backup files on a drive they can take with them.

The product name specifies 1 TB of storage.

View at Joybuy
WD My Passport for Mac 2TB Blue

WD My Passport for Mac 2TB Blue

A portable HDD option for anyone looking for a backup drive for Mac; check that its format suits your chosen backup method.

The product name specifies 2 TB, Time Machine Ready and password protection.

View at Joybuy
WD Elements Portable 2TB USB-C Graphite Black

WD Elements Portable 2TB USB-C Graphite Black

A portable HDD option for anyone who wants to store files and is looking for a USB-C model.

The product name specifies 2 TB and USB-C.

View at Joybuy
WD My Passport 2TB Red

WD My Passport 2TB Red

A portable HDD option for anyone who needs space for spreadsheet backups and other files.

The product name specifies 2 TB, password protection and backup software.

View at Joybuy
Toshiba Canvio Ready external hard drive 1 TB

Toshiba Canvio Ready 1 TB

A portable HDD option for anyone who wants to keep spreadsheets on a separate drive.

The product name specifies 1 TB, a 2.5-inch form factor and a Micro-USB B connection. Handle the drive with care and avoid physical knocks.

View at Joybuy

Frequently asked questions

How can you automatically back up your spreadsheets in Windows?

Windows File History can back up libraries and added folders to an external drive and restore earlier versions. Check that the folder containing your spreadsheets is included, and try restoring a file.

Can a drive formatted for Windows and Mac be used straight away with Time Machine?

Not necessarily: Apple recommends APFS or APFS Encrypted for a new Time Machine drive. You may need to reformat it, which could erase existing data, so check before using the drive for other files too.

Is one external drive enough for important spreadsheets?

Don’t rely on a single external drive as your only way to protect important data. The National Cyber Security Centre recommends keeping multiple versions on different storage media, with a copy in another location; you should also test that you can restore files.

Does the GDPR require you to buy a specific encrypted external drive?

The guidance from the Dutch Data Protection Authority doesn’t specify a particular drive model. If an organisation processes personal data in spreadsheets, it must take appropriate security measures based on the risks; this should include reviewing access to and protection of the backup.

What are your warranty rights in the Netherlands if a drive stops working?

When you buy as a consumer, a product must meet what you could reasonably expect from it under normal use. According to ACM ConsuWijzer, statutory warranty in the Netherlands has no fixed time limit, and the seller is responsible for providing an appropriate free solution if the product is faulty; a manufacturer’s warranty doesn’t replace this right.