What should you look for when buying?
First check whether your local method saves older spreadsheet versions and lets you restore them. Then consider device compatibility and whether there’s enough space for the versions you want to keep. For confidential data, you should also plan how it will be encrypted and accessed later.
| What you need |
What to check before buying |
Who it matters most to |
| Restore older spreadsheet versions |
Choose a local method that keeps versions, then test restoring an older file. |
If I need an earlier copy after overwriting a file, being able to restore it matters more than a high peak speed. Around 36% of consumers prioritise having versions they can restore. |
| Protect confidential spreadsheets |
Check how files or the drive are encrypted, and how you’ll unlock them on the device used for recovery. |
If the SSD contains sensitive personal or work-related records, I want to limit access if the drive is lost while still being able to find the key. Around 29% of consumers prioritise protecting confidential data. |
| Use with more than one device |
Test the connections, file system and any unlocking requirements on every computer you plan to use. |
If I need to open the backup on different computers, the entire restore process must work on each one. Around 21% of consumers name device compatibility as their top priority. |
| Space for data and versions |
Take into account the amount of data you have, how many older copies you want to keep and the usable capacity. |
If my spreadsheets are growing or I want to keep several older copies, I need enough usable storage space. Around 14% of consumers prioritise storage capacity. |
Joybuy products for local backups
The products below are external SSDs that could be used as local storage for spreadsheet backups. Older versions can only be restored if you set up a suitable backup method.
No image available
KEXIN external SSD 256 GB
Suitable as local storage; access to older versions depends on the backup method you set up.
256 GB; USB-C; up to 500 MB/s according to the product name.
Joybuy
No image available
KEXIN external SSD 1 TB
Suitable as local storage; access to older versions depends on the backup method you set up.
1 TB; USB-C; up to 500 MB/s according to the product name.
Joybuy
No image available
KEXIN external SSD 512 GB
Suitable as local storage; access to older versions depends on the backup method you set up.
512 GB; USB-C; up to 500 MB/s according to the product name.
Joybuy
No image available
Samsung Portable SSD T7 1 TB, Grey
Suitable as local storage; you’ll also need a version backup to keep older copies of your spreadsheets.
1 TB; USB Type-C; USB 3.2 Gen 2 (3.1 Gen 2).
Joybuy
No image available
Samsung Portable SSD T7 2 TB, Titanium Grey
Suitable as local storage if you’re planning space for data and several backup versions; you’ll need a suitable backup method to restore them.
2 TB; USB Type-C; USB 3.2 Gen 2.
Joybuy
Frequently asked questions
Is it enough to copy the spreadsheet to the SSD now and then?
Only if you can also restore the earlier version you need. For spreadsheets you update frequently, a local method that keeps several saved versions can help. Test restoring a file before relying on it.
How do I set up a backup without the cloud in Windows?
Microsoft explains how to use File History with an external drive as the backup destination. Check that the folder containing your spreadsheets is included, then try restoring an older version.
What should I check regularly after making a backup?
Check that new spreadsheets appear in the backup and that you can open a restored file. Keep another copy in a separate location in case the original location is damaged; Germany’s Federal Office for Information Security highlights recovery and keeping copies in separate locations as important considerations.
What ongoing costs and support should I plan for?
Keeping another copy separately may require an additional storage device. Check the warranty terms for the specific product; a manufacturer’s warranty is no substitute for a second backup.
Does the law require an SSD with a particular type of hardware encryption for spreadsheets containing personal data?
The official guidance cited here does not set out a blanket requirement for a particular type of SSD hardware encryption. If you process personal data for business purposes, the European Data Protection Board says you need suitable technical and organisational measures that are appropriate to the context and risk. Assess encryption and recoverability accordingly, and distinguish these from any software encryption you may use.