What should you consider when choosing?
First, decide how you want to keep and restore versions. Then choose the storage capacity, size and connection to suit your computer and workspace.
| What to consider |
What should you look for? |
Who is this important for? |
| Restorable versions |
Decide how you’ll back up spreadsheet folders and earlier versions, and test that you can restore a file. |
If I need an earlier version after making a change or deleting something, I want to be sure the right folders are included. Around 26% of consumers give recoverability their highest priority. |
| Storage capacity |
Count the folders you want to keep and decide how many versions you need; then compare this with the capacity of the exact model. |
If I want to keep other folders and older versions as well as spreadsheets, I’ll focus on how much space my backup plan needs. Around 26% of consumers prioritise capacity. |
| Desk space |
Check the dimensions, where the cable connects and whether the drive needs a separate power supply. |
If I have little free space on my desk, I want a drive that fits easily beside my computer. Around 21% of consumers say a small workspace is a deciding factor. |
| Connection and operating system |
Check your computer’s ports, the cables included and the drive format required by your backup method. Apple recommends APFS or APFS Encrypted for a new Time Machine drive. |
If I want to use the same drive with different computers or backup methods, the connection and format need to be suitable. Around 16% of consumers prioritise system compatibility. |
| Confidential files |
Check whether your backup method offers encryption and access restrictions, and where you’ll keep an additional copy. |
If my spreadsheets contain information that isn’t meant for everyone, I want to restrict unauthorised access to the backup. Around 11% of consumers give confidentiality their highest priority. |
Joybuy products
These product picks are portable external SSDs and HDDs for storing spreadsheet backups and other files.
No image available
SanDisk Portable SSD 1TB
A portable SSD option for anyone who wants to store backup files on a drive they can take with them.
The product name specifies 1 TB of storage.
View at Joybuy
No image available
WD My Passport for Mac 2TB Blue
A portable HDD option for anyone looking for a backup drive for Mac; check that its format suits your chosen backup method.
The product name specifies 2 TB, Time Machine Ready and password protection.
View at Joybuy
No image available
WD Elements Portable 2TB USB-C Graphite Black
A portable HDD option for anyone who wants to store files and is looking for a USB-C model.
The product name specifies 2 TB and USB-C.
View at Joybuy
No image available
WD My Passport 2TB Red
A portable HDD option for anyone who needs space for spreadsheet backups and other files.
The product name specifies 2 TB, password protection and backup software.
View at Joybuy
No image available
Toshiba Canvio Ready 1 TB
A portable HDD option for anyone who wants to keep spreadsheets on a separate drive.
The product name specifies 1 TB, a 2.5-inch form factor and a Micro-USB B connection. Handle the drive with care and avoid physical knocks.
View at Joybuy
Frequently asked questions
How can you automatically back up your spreadsheets in Windows?
Windows File History can back up libraries and added folders to an external drive and restore earlier versions. Check that the folder containing your spreadsheets is included, and try restoring a file.
Can a drive formatted for Windows and Mac be used straight away with Time Machine?
Not necessarily: Apple recommends APFS or APFS Encrypted for a new Time Machine drive. You may need to reformat it, which could erase existing data, so check before using the drive for other files too.
Is one external drive enough for important spreadsheets?
Don’t rely on a single external drive as your only way to protect important data. The National Cyber Security Centre recommends keeping multiple versions on different storage media, with a copy in another location; you should also test that you can restore files.
Does the GDPR require you to buy a specific encrypted external drive?
The guidance from the Dutch Data Protection Authority doesn’t specify a particular drive model. If an organisation processes personal data in spreadsheets, it must take appropriate security measures based on the risks; this should include reviewing access to and protection of the backup.
What are your warranty rights in the Netherlands if a drive stops working?
When you buy as a consumer, a product must meet what you could reasonably expect from it under normal use. According to ACM ConsuWijzer, statutory warranty in the Netherlands has no fixed time limit, and the seller is responsible for providing an appropriate free solution if the product is faulty; a manufacturer’s warranty doesn’t replace this right.