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. |
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.
No image available
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
No image available
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
No image available
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
No image available
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
No image available
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.