What should you look for when choosing?
Portable SSD
A good fit if: you regularly take the copy with you or transfer it between computers.
Bear in mind: check the connection and security features of the exact model. A quoted speed doesn’t guarantee a particular transfer speed on your computer.
External HDD
A good fit if: the drive will mainly stay in one place and you need space for files or multiple versions.
Bear in mind: check the formatting on the computer you’ll use to access the backup. Reformatting can erase existing files.
Start by considering recovery, confidentiality and which computers you’ll need to access the files on. The National Cyber Security Centre recommends testing recovery, while the Dutch Data Protection Authority explains that security should reflect the risks involved in processing the data.
| What to consider |
What to look for |
Who should prioritise this? |
| Restoring the right version |
Check which folders and versions are included, then restore a test file before the handover. |
If I want to be sure I can restore the right spreadsheet version, I’ll test the recovery process in advance. Around 40% of consumers give recoverability top priority. |
| Confidential files |
Check that security features are supported on the exact model and have actually been set up. Make sure passwords are managed securely too. |
If my spreadsheets contain customer data, I want to control who can open the drive and how access is restricted. Around 30% of consumers prioritise confidentiality. |
| Compatibility |
Check the connection, formatting and backup method on both the computer the files come from and the one you’ll use to restore them. Apple Support warns that Time Machine won’t save backups to a Windows-formatted drive. |
If I switch between computers, I want to be able to copy and restore files on the right devices. Around 20% of consumers give compatibility top priority. |
| Storage capacity |
Check the size of your folders and decide how many versions you want to keep before choosing the capacity. |
I want to choose a capacity that suits my project files and retention period, without paying for space I don’t need. Around 10% of consumers prioritise storage capacity. |
Drives for backing up spreadsheets
The options below include portable SSDs and HDDs for keeping an external copy of your spreadsheets. Check the connection, formatting and any security settings for each model.
No image available
SanDisk Portable SSD 1 TB
An external SSD for a portable copy of your files. Check whether 1 TB is enough for the folders and versions you want to keep.
View at Joybuy
No image available
WD My Passport for Mac 2 TB Blue, portable hard drive
For a Mac backup with Time Machine and password protection. According to the product information, you need to activate password protection through WD Discovery.
The product name lists 2 TB, a Mac version and Time Machine support. Keep the password safe and test that you can restore the backup.
View at Joybuy
No image available
WD Elements Portable 2 TB USB-C Graphite Black
A portable HDD for storing project files. Compare its capacity with the folders and versions you want to keep.
The product name lists 2 TB and USB-C. Check the formatting and backup method on the computer you’ll use to restore files.
View at Joybuy
No image available
Samsung Portable SSD T7 1 TB USB Type-C 3.2 Gen 2 (3.1 Gen 2) Blue
A portable SSD for an external copy of your spreadsheets. Check the security settings on this exact model before saving confidential files to it.
The product name lists 1 TB and USB Type-C 3.2 Gen 2 (3.1 Gen 2). Test a file restore after copying.
View at Joybuy
No image available
Samsung MU-PE1T0S 1 TB USB Type-C 3.2 Gen 2 (3.1 Gen 2) Black
A portable SSD for a copy you want to take with you. According to the product information, you need to set up password protection using software.
The product name lists 1 TB and USB Type-C 3.2 Gen 2 (3.1 Gen 2). Test that an authorised user can restore the protected backup.
View at Joybuy
Frequently asked questions
How can you check that your backup is usable before handing files over to a client?
Check that the right folders and spreadsheet versions are included, then restore a file as a test. The National Cyber Security Centre recommends carrying out a recovery test. Also keep a separate copy, so the external drive isn’t your only recovery option.
Can you use the same drive for Windows backups and Time Machine without preparing it first?
First check the formatting and destination. Apple Support says Time Machine won’t save backups to a Windows-formatted drive, and reformatting can erase existing files. Also check which folders you want to include with Windows File History.
Does the GDPR mean you must always buy an encrypted external drive?
No. The GDPR doesn’t require the same drive model or a specific encryption method for every spreadsheet. If your organisation processes personal data, your security measures must be appropriate to the risks. The Dutch Data Protection Authority lists encryption as one possible safeguard. Assess the contents, access and consequences of loss before making your choice.
Is a data processing agreement always required when handing files over to a client?
Not just because files are being handed over. According to the Dutch Data Protection Authority, a written data processing agreement is required when one party processes personal data on behalf of a data controller. Work out which roles and data are involved in the specific handover.
What should you check when using password protection?
Check that the security software supports your exact drive and the computer you’ll use for recovery, and make sure authorised users will still be able to access the files. Western Digital warns that data on drives supporting WD Security could be lost if you forget the password. Don’t assume other models have the same feature without checking.