Who is this guide for?

Anyone who wants to keep earlier spreadsheet versions

You want to be able to open a usable earlier version after a mistake or unwanted change, without relying on cloud storage. The National Cyber Security Centre advises not only backing up important files, but also checking that you can open files from the backup.

Anyone who stores sensitive data in spreadsheets

For example, you store customer or employee information and want to weigh up which access controls are appropriate for the risks. The Dutch Data Protection Authority emphasises that security measures should be proportionate to the risks involved in processing the data.

Anyone who uses different computers or connections

You want to back up files locally using Windows, a Mac or different USB connections. So check the connection, your backup method and the drive’s format.

What should you look for?

First decide how you want to store and restore files and earlier versions locally. Then compare capacity, connection, security and casing according to how you’ll use the drive.

What to consider What should you check? Who should consider this most?
Restorable versions Check which folders your backup method includes, then try restoring and opening a spreadsheet. The National Cyber Security Centre advises testing backups. I want to be able to retrieve an earlier version after a mistake, rather than just have a copy; around 36% of consumers who prioritise restorable versions share this as their main priority.
Privacy if the drive is lost Check whether the specific SSD has a security feature, whether you need to set it up and how authorised users can restore files later. Apple says you need the password to restore an encrypted Time Machine backup. If my spreadsheets contain sensitive data, I want to reduce the risk of someone accessing them if the drive is lost; around 29% of consumers who prioritise protecting sensitive data share this concern.
Connection and file format Check the ports, included cables and compatibility with your backup software. Crucial says the X9 comes formatted as exFAT; reformatting it to another format erases the data on the drive. I want to use the SSD with my computer and backup method, possibly across several devices; around 21% of consumers who prioritise a compatible connection and software combination have this as their main requirement.
Capacity and use Check how much space your files and the versions you want to keep will take up. Compare speed afterwards: stated maximums don’t guarantee how quickly your own backups will run. I want enough space for my own files and versions, without choosing solely on the basis of higher specifications; around 14% of consumers who prioritise suitable capacity have this as their main consideration.

Common pitfalls

  • Assuming a successful copy means your backup has been tested

    A file may have been copied, but that doesn’t tell you whether you can restore and open the version you need. The National Cyber Security Centre distinguishes between making a backup and testing a restore.

    After setting up your backup, restore a spreadsheet and open it. Repeat the test whenever you change your backup method.

  • Assuming the advertised maximum speed is your backup speed

    A stated maximum doesn’t tell you how long your spreadsheet backup will take. Crucial lists a maximum read speed for the X9 under specific conditions; your connection and setup also affect performance.

    First choose enough capacity and a backup method that works. Then compare speeds in relation to your own connection and files.

  • Assuming a security feature is already switched on

    A model with a security feature won’t automatically protect your backup if you haven’t set it up. Forgetting your password could also make it harder to restore your files.

    Set up your chosen security feature carefully and keep the recovery details somewhere appropriate, where authorised users can find them.

Brands to compare

Samsung

According to Samsung, the T7 is a portable SSD with optional password protection. The separate T7 Shield version is worth considering if physical protection matters to you too.

  • Samsung lists maximum read and write speeds of 1.050 MB/s and 1.000 MB/s respectively for the T7; these are product specifications, not measured spreadsheet backup speeds.
  • Samsung specifies IP65 for the T7 Shield version mentioned here; check the exact model and version.
  • A security feature doesn’t mean the drive is already protected. Check how to set it up and manage it.

Crucial

Crucial presents the X9 as suitable for file backups, among other uses, and says it supports Windows File History and Apple Time Machine.

  • Crucial says the X9 comes formatted as exFAT and can be reformatted.
  • Reformatting erases the data on the drive. Check the format before saving any files.
  • According to Crucial, the stated read speed of up to 1.050 MB/s is a maximum under specific conditions, not an independently measured real-world speed.

Kingston

According to Kingston, the XS1000 is a compact SSD range available in 1 TB and 2 TB versions.

  • Kingston lists a cable with an adapter for USB-A and USB-C hosts; check what’s included with the specific version.
  • Kingston says optimal speeds depend on a compatible USB 3.2 Gen 2 host.

SanDisk

The 1 TB SanDisk Extreme Portable SSD, model SDSSDE61-1T00-G25, is one version to compare if portability matters to you.

  • SanDisk lists USB 3.2 Gen 2 and a maximum sequential read speed of 1.050 MB/s for this version.
  • The stated specifications alone don’t determine whether the drive is suitable for your backup method or security needs.

SSDs at Joybuy

These SSD options are intended for storing spreadsheet files locally. Check the capacity and features of each model to see whether they suit your computer and backup method.

SanDisk Portable SSD 1TB

SanDisk Portable SSD 1TB

The stated 1 TB capacity is intended for local file storage; check whether it’s enough for the folders and versions you want to keep.

View at Joybuy
SanDisk Extreme Pro Portable SSD 1TB 2000MB/s

SanDisk Extreme Pro Portable SSD 1TB

According to the product name, this portable SSD has a capacity of 1 TB and a stated speed of up to 2000MB/s; this isn’t a measured speed for your spreadsheet backup.

View at Joybuy
My Passport SSD WDBAGF0010BGY, 1 TB

My Passport SSD WDBAGF0010BGY, 1 TB

The product name lists 1 TB of local storage. According to the product information, the optional password protection mentioned requires WD Security software; check whether it suits the way you plan to use the drive.

View at Joybuy
Portable SSD 1TB 1000MB/s

Portable SSD 1TB 1000MB/s

The product name lists 1 TB and 1000MB/s. Treat the speed as a stated maximum, not a prediction of how long your files will take to back up.

View at Joybuy
DigiEra 1TB Magnetic Portable SSD, model LPS2000M-3

DigiEra 1TB Magnetic Portable SSD, model LPS2000M-3

The product name lists 1 TB and a USB connection. Check that the version and connection described are compatible with your computer and backup method.

View at Joybuy

Frequently asked questions

How do I back up spreadsheets to an external SSD without using the cloud?

Use a local backup method that includes your spreadsheet folders. Microsoft explains how File History keeps versions of included libraries; add a folder outside those libraries if needed. Apple describes Time Machine as a way to back up to a connected external storage device. Then try restoring and opening a file.

Do I need to format a new SSD for Time Machine?

First check the instructions on your Mac and the drive’s current format, as setting it up may involve erasing the drive. Crucial says the X9 comes formatted as exFAT and that reformatting erases data. Don’t leave your only copy of any files on a drive that still needs to be formatted.

How can I check that my SSD backup is working?

Restore a file from the backup and open it to check that the version you need is usable. The National Cyber Security Centre advises testing backups technically and carrying out a restore as well. How often you do this will depend in part on how often your spreadsheets change and how old a restorable version can be.

Is encryption essential for every spreadsheet backup?

It isn’t a universal requirement for every user. The Dutch Data Protection Authority says organisations that process personal data must tailor security measures to the risks involved in their processing; examples won’t automatically be suitable for every situation. So consider what protection is appropriate for your data and risks when backing up too.

Will one SSD protect my backup from loss or damage?

No. An SSD can’t protect you if that same drive is lost. The National Cyber Security Centre advises organisations to keep multiple copies in different locations. If you don’t want to use the cloud and losing your data would have serious consequences, consider whether keeping a separate second physical copy would suit the way you work.