Who is this choice relevant to?

Project worker who needs to retrieve previous versions

If you regularly edit spreadsheets, you’ll want to restore an earlier version of your project if something goes wrong. Microsoft explains how to restore versions using File History, while Apple explains automatic backups with Time Machine.

Manager of growing project archives

If you keep several projects and backups from different points in time, it helps to choose a capacity that suits the amount of data and how long you want to keep it. Toshiba Storage and Seagate product information lists 2 TB for specific HDD models.

Mobile or confidential project worker

If you take the drive with you or your files contain confidential information, consider how you’ll carry it, its connection and suitable security features. The Dutch Data Protection Authority stresses that security measures depend on the data and how it is used.

What should you consider?

External HDD

Choose this when: the drive will mostly stay at a fixed workstation and you want to set aside space for multiple backups.

Trade-off: the Dutch Consumers’ Association describes HDDs as more vulnerable to impact than SSDs.

External SSD

Choose this when: you regularly take your backup drive between work locations; the Dutch Consumers’ Association describes SSDs as less vulnerable to impact than HDDs.

Trade-off: stated maximum sequential speeds don’t necessarily indicate how quickly a small spreadsheet backup will run in your situation.

Choose your backup method and retention period before deciding on the drive capacity.

What to consider What to look for when buying Who should pay particular attention?
Restoring versions Check that your backup software monitors the right folders and keeps previous versions. If I want to restore an earlier spreadsheet after something goes wrong, I’ll check the version settings first; around 36% of consumers prioritise version recovery.
Space for archives Compare the amount of data you have now with how long you want to keep it. For Time Machine, Apple recommends a drive with at least twice the storage capacity of your Mac. If my projects are growing, I’ll want enough space for older backups too; around 29% of consumers give archive space top priority.
Portability and connections Check that the port and cable are compatible with your computer, and bear in mind that HDDs are more susceptible to impact. If I carry the drive between work locations, I’ll look for a suitable connection and a drive type that fits the way I’ll use it; around 21% of consumers prioritise portability.
Confidential files Check that encryption is actually enabled and that you know how to store a recovery password securely. If I want to limit who can open files on a lost drive, I’ll check the security features available; around 14% of consumers prioritise confidentiality.

Common buying pitfalls

  • Assuming a drive automatically keeps a version history

    Restoring versions depends on backup software that has been set up in advance and is monitoring the right folders.

    Set up your backup and try restoring an earlier version of a spreadsheet.

  • Leaving your only backup permanently connected

    An incident could affect both your working files and a connected backup. The Dutch National Cyber Security Centre recommends keeping at least three versions of important business data: the original and two backups.

    Consider keeping a separate backup in addition to your external drive, taking the risks associated with your data into account.

  • Formatting a drive without checking what’s on it

    Apple warns that Time Machine won’t store backups on a drive formatted for Windows. Reformatting can erase existing files.

    First save the contents somewhere else and check the drive format before confirming the reformat.

Brands to compare

Toshiba

Canvio Basics is a portable HDD range; Toshiba lists a capacity of 2 TB for model HDTB520EK3AA.

  • Toshiba specifies USB power and includes a Type-A to Micro-B cable.
  • The model listed is formatted as an NTFS drive for Windows. You may need to reformat it to use it with macOS; check the contents before erasing a drive.

Seagate

Expansion Portable is a portable HDD range; the Seagate data sheet lists STKM2000400 as a 2 TB model in black.

  • According to Seagate, power and connectivity are both handled by a single USB cable.
  • The Rescue service mentioned is available in some countries but not others; check the terms for the specific product you’re buying.

Samsung

The portable T7 Shield is an SSD range. The blue model tested, MU-PE1T0R/EU, has a capacity of 1 TB.

  • Samsung specifies USB 3.2 Gen 2, maximum sequential read and write speeds of 1,050 and 1,000 MB/s respectively, and IP65 protection for this model.
  • These are Samsung’s figures, not independent tests of spreadsheet backups. Dust and water resistance don’t replace a separate backup copy.

Crucial

The Crucial X9 is a compact external SSD range; model CT1000X9SSD9 is the 1TB version.

  • Crucial lists USB-C connectivity and compatibility with Windows File History and Apple Time Machine.
  • Crucial’s stated maximum sequential speed is measured under specific test conditions; real-world performance may differ.

Joybuy backup products

This selection from Joybuy includes portable HDDs and SSDs for project backups. Choose a capacity and connection that suit your needs, and set up backup software to keep previous versions.

SanDisk Portable SSD 1TB

SanDisk Portable SSD 1TB

A good fit if you want to take a portable SSD with you for project backups; you’ll still need to set up software to restore previous versions.

1 TB; external SSD.

View at Joybuy
My Passport for Mac 2TB Blue

My Passport for Mac 2TB Blue

An option to consider for a Mac backup with Time Machine; check the drive format and set up your backup method.

2 TB; blue model. The product name mentions 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 good fit if you’re looking for a portable HDD for project backups; set up the software if you want to keep older spreadsheet versions.

2 TB; USB-C; Graphite Black.

View at Joybuy
My Passport 2TB Red

My Passport 2TB Red

An option to consider if you’re looking for a portable HDD with the backup software mentioned; check that the software keeps the older versions you need.

2 TB; red model. The product name mentions Password Protection and Auto Backup Software.

View at Joybuy
Samsung Portable SSD T7 2TB USB Type-C 3.2 Gen 2 Blue

Samsung Portable SSD T7 2TB USB Type-C 3.2 Gen 2 (3.1 Gen 2) Blue

A good fit if you want to use a portable SSD for project files; your backup software determines whether previous versions are kept.

2 TB; USB Type-C 3.2 Gen 2 (3.1 Gen 2); blue model. Check that the connection is compatible with your computer and cable.

View at Joybuy

Frequently asked questions

Can I restore an older spreadsheet version on Windows?

Yes, if File History was enabled in advance, included the folder and kept the version you need. Microsoft explains how to restore previous versions of files and folders from an external drive or network location.

Can I use a drive set up for Windows with Time Machine straight away?

Check the drive format first. Apple says Time Machine won’t store backups on a drive formatted for Windows, and reformatting will erase existing data. So make a copy somewhere else first.

How can I check that my backup is usable?

Restore some files and open the recovered project files. The Dutch National Cyber Security Centre recommends carrying out a restore and checking that the software reports it was successful.

What does the legal guarantee mean for an external drive in the Netherlands?

A legal guarantee applies in addition to any manufacturer’s warranty. According to ACM ConsuWijzer, it depends on what you could reasonably expect from the product under normal use; this doesn’t mean there’s a set guarantee period for every external drive.

Is encryption a legal requirement for every project spreadsheet?

No, the rules cited don’t impose a universal encryption requirement for every drive. If an organisation processes personal data, the GDPR requires appropriate security measures based on the risks. The Dutch Data Protection Authority gives encryption as one possible example.