Who is this choice relevant to?

Project worker with frequent revisions

Want to restore an earlier project version after a mistake or an overwritten worksheet? Check which files your backup method includes and test that you can restore a version. Microsoft Support explains how to restore versions from selected libraries using File History.

Manager of sensitive records

If your spreadsheets contain personal data or confidential project information, consider more than just the SSD: look at security and how you store the separate backup, too. The Dutch Data Protection Authority says organisations must protect personal data in a way that is appropriate to the risks.

User of multiple computers

If you want to use the SSD with different devices, check that the supplied cable or adapter fits and that the format works with your backup software on each device.

What should you look for?

First decide how you want to restore older files. Then choose the storage capacity, security and connection that suit your approach.

What to consider What to look for when buying Who is this important for?
Restoring older versions Check which folders and versions the backup software keeps, and try restoring a file. If I want to be able to restore an overwritten worksheet, my backup method needs to keep earlier versions. Around 36% of consumers say version recovery is their main consideration.
Protecting sensitive data Check which encryption options are available and how you manage your password or recovery key. If my project files contain personal data or confidential information, I also want to know how to protect the separate backup. Around 29% of consumers prioritise data security.
Space for your backup history Choose a capacity that suits the selected folders and the number of backups you want to keep. If my project archive is growing, I want enough space for both the data and the backup history I need. Around 21% of consumers prioritise archive space.
Connecting to your devices Check the available USB ports, supplied cables or adapters, and the required format. If I want to use the SSD with my existing computers, the connection and backup software need to be compatible. Around 14% of consumers say device compatibility is their main consideration.

Common buying mistakes

  • Mistaking a one-off copy for a version archive

    An SSD won’t automatically keep a series of restore points for every spreadsheet. A copy containing only the latest version won’t help if you need to retrieve an earlier worksheet.

    Start by choosing a method that supports version retention. Then check which folders are included and test that you can restore an older version.

  • Leaving the SSD connected as your only backup

    The Dutch Data Protection Authority warns that malware can also affect connected files and backups. KVK recommends disconnecting a separate business backup from the company network and storing it securely.

    Consider keeping an additional copy in a separate location as well as your external SSD, and disconnect the separate backup after use.

    Disconnecting and storing it separately means an extra step after use.

  • Making the advertised speed your deciding factor

    Your computer’s port may limit transfer speeds, and speed tells you nothing about whether the right spreadsheet version will be kept or restored.

    Check version retention, connection and storage capacity first. Then compare the advertised speed with your equipment.

  • Setting up a new Time Machine drive without checking what’s on it

    Apple says you may be asked to erase the selected drive when setting up Time Machine.

    Choose a suitable separate drive or volume, and check first whether it contains files you want to keep.

    Any existing data on the selected drive could be lost if you erase it.

Relevant brands to compare

Samsung

The Portable SSD T7 is worth considering if you want a compact SSD supplied with USB-C and USB-A connection options, plus optional password protection.

  • Samsung specifies maximum read and write speeds of 1.050 MB/s and 1.000 MB/s respectively for the blue 1 TB T7. These are advertised maximums, not measured speeds for a spreadsheet backup.
  • Enable security if you need it, and check that the connection is right for your computer’s port.

Kingston

The XS1000 range is designed as a compact, lightweight SSD for backing up documents from devices with USB-A or USB-C.

  • Kingston lists a USB-A cable with a USB-C adapter and a five-year limited warranty for the XS1000.
  • Don’t assume this model has built-in hardware encryption; check which protection suits your needs.

Crucial

The X9 Pro is worth considering if protection during transit and compatibility with your operating system’s encryption are important to you.

  • Crucial lists support for BitLocker To Go and FileVault, and a maximum speed of 1.050 MB/s for the 1 TB X9 Pro.
  • Crucial marks this version as EOL. Reformatting erases the data on the drive, so check the encryption and format you need beforehand.

Western Digital

The My Passport SSD range is one to compare if you’re looking for password-protected hardware encryption.

  • Western Digital’s product specifications list maximum read and write speeds of 1.050 MB/s and 1.000 MB/s respectively.
  • These advertised maximums don’t automatically make the SSD more suitable for small spreadsheet files. Compare the model with your own backup setup.

SanDisk

The Portable SSD, with an advertised read speed of up to 800 MB/s, is an option if portability matters more to you than the highest advertised speed.

  • SanDisk says this specific Portable SSD can withstand drops of up to two metres.
  • Don’t confuse this version with other SanDisk Portable models that have different advertised speeds.

Joybuy products

These portable external SSDs are designed for storing spreadsheet backups. Choose one to suit the capacity, connection and security you need; restoring versions also requires a backup method to be set up.

SanDisk Portable SSD 1 TB

SanDisk Portable SSD 1 TB

The 1 TB version provides space for backup files; set up separately which versions you want to keep.

The description lists read speeds of up to 800 MB/s and drop protection up to two metres.

Joybuy
SanDisk Extreme Pro Portable SSD 1 TB

SanDisk Extreme Pro Portable SSD 1 TB

This version offers password protection with 256-bit AES hardware encryption if you need this feature.

The description lists 1 TB capacity, a weight of 46,9 g, and a USB-C cable and USB-A-to-USB-C adapter in the box. The advertised maximum read speed of 2.000 MB/s requires a compatible USB 3.2 Gen 2x2 host; write speeds are lower.

Joybuy
Western Digital My Passport SSD WDBAGF0010BGY, 1 TB

Western Digital My Passport SSD WDBAGF0010BGY, 1 TB

This 1 TB version is an option if you want to use password protection and hardware encryption for your backup.

According to the product description, you need to use WD Security and its settings to enable this protection. The description lists support for Windows and macOS, and a USB-C connection.

Joybuy
Portable SSD 1 TB, 1.000 MB/s

Portable SSD 1 TB, 1.000 MB/s

The 1 TB capacity is designed for storing backup files; set up version retention using your chosen backup method.

The description lists read speeds of up to 1.000 MB/s, an integrated USB-C cable, and support for Windows 10+, macOS 13+ and Android 13+. A USB-C-to-USB-A adapter may be needed to connect to USB-A.

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

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

The 2 TB version provides room for a larger archive; use a separately configured backup method to keep earlier spreadsheet versions.

The description lists AES 256-bit encryption, password protection, and USB-C-to-C and USB-C-to-A cables. It recommends Samsung Magician software for setting up encryption.

Joybuy

Frequently asked questions

Does an external SSD automatically save multiple versions of your spreadsheets?

No. You need to set up a backup method that keeps different versions. Microsoft Support explains how to restore earlier versions from selected libraries using File History; Time Machine backs up to a Mac drive configured for that purpose. Test that you can restore an older version before relying on your backup.

Can you use Excel version history for a file stored only on your external SSD?

Don’t assume you can: Microsoft says version history in Microsoft 365 only works for files stored in OneDrive or SharePoint in Microsoft 365. For a file stored only locally or on the SSD, set up a separate backup method.

What should you do after setting up your backup drive?

Check that your project folder is included, run a test backup and restore an earlier version. For a separate business backup, KVK recommends disconnecting it from the company network and storing it securely.

Does a manufacturer’s warranty of a few years cover all your Dutch consumer rights?

No. According to ACM ConsuWijzer, your statutory guarantee is separate from any manufacturer’s warranty. If a product is faulty despite normal use, the retailer is responsible for providing an appropriate solution; what applies depends on the purchase and circumstances. This answer relates to a consumer purchase.

Is encryption compulsory for every spreadsheet backup in the Netherlands?

That depends on the processing involved and the risks. The Dutch Data Protection Authority says organisations must protect personal data in a way that is appropriate to the risks. Consider which measures suit your data and how you store the backup.