Start with a backup routine that covers both your spreadsheet and its associated local source folders, then check that you can restore everything together. A portable HDD may suit you if space for growing folders is your priority; an SSD is an option if you often take the drive with you or regularly transfer larger files. Also check the capacity, connection and format, and make sure sensitive data is appropriately protected.
Who is this choice relevant to?
Spreadsheet user focused on recovery
You want to be able to restore the right version of your spreadsheet and its local source files after an error or deletion. So consider folder selection and version history, and test a restore. The National Cyber Security Centre advises testing backups in practice.
Managing growing source folders
You’re storing more and more local exports or other source files alongside your spreadsheets, and want enough space for repeated backups. Compare the size of all your folders with the drive’s capacity, taking into account how long you want to keep previous versions. The National Cyber Security Centre notes that keeping files for longer requires more storage.
Working with sensitive data
You take confidential records with you on a drive or process personal data for an organisation. Consider access, transport and recoverability. The Dutch Data Protection Authority emphasises that appropriate security measures depend on the processing involved and the risks.
What should you look for when choosing?
First, work out which files and previous versions you need. The capacity should be suitable for this complete selection. A successful copy is only useful if you can also restore and open the files.
| Concern |
What to look for when buying |
Who is this important to? |
| Restoring spreadsheets and source files together |
Include all the folders you need and test whether you can restore and open files from both locations. Microsoft Support explains how to add folders outside the default libraries to File History. |
If I need both my spreadsheet and the files it relies on after an error, restoring them together is my priority. Around 33% of consumers share this main need. |
| Space for growing folders and versions |
Compare the total size of your source folders with the drive’s capacity, and decide how many previous versions you want to keep. According to the National Cyber Security Centre, a longer retention period requires more storage. |
When my source folders are growing and I want to keep older versions, enough capacity is essential. Around 27% of consumers prioritise archive storage. |
| Taking the drive with you and transferring files |
Check your computer’s port and the cable, and weigh portability against capacity. In 2022, the Consumers’ Association reported that HDDs are more susceptible to impact than SSDs. |
If I often carry my backup drive around or regularly copy larger folders, I pay extra attention to portability and file transfer. Around 20% of consumers prioritise mobile use. |
| Confidentiality of records |
Decide who needs access and how to enable security; an available security feature isn’t automatically switched on. The Dutch Data Protection Authority says that appropriate measures for organisations depend on the processing involved and the risks. |
When my records are confidential or stored on a drive I take with me, I want to know how access is protected and whether recovery is possible. Around 20% of consumers prioritise confidentiality. |
Common backup mistakes
-
Copying only the spreadsheet folder
A copy isn’t complete if the local source files are missing. Microsoft Support explains how to add other folders to File History too.
Select your source folders and test a restore. Then open files from both the spreadsheet folder and the source folders.
Finding or recreating missing local files later takes time.
-
Relying on an external drive as your only backup
A single drive won’t protect you against every fault, loss or incident at the same location.
Keep the original and make a separate copy as well. The National Cyber Security Centre recommends the 3-2-1 rule as a guideline for important data.
Keeping an additional copy separately means you’ll need a second storage device or another storage location.
-
Assuming every drive works with Time Machine straight away
A Windows-formatted drive isn’t necessarily suitable as a Time Machine destination. Apple states that formatting erases existing data.
Check the file system before putting files on the drive. Apple recommends APFS or APFS Encrypted for a new Time Machine backup drive.
Reformatting takes time and may mean you need a separate volume or another drive.
-
Taking a maximum SSD speed as a guaranteed backup speed
Advertised speeds apply under specific conditions. For the Crucial X9, the manufacturer lists factors including the capabilities of the host computer.
Check your computer’s port and cable, and decide whether speed matters more than extra capacity for your transfers.
Brands to consider
Western Digital
The My Passport range includes portable HDDs. The black version reviewed has a capacity of 2 TB.
- Western Digital identifies version WDBYVG0020BBK-WESN as My Passport 2TB Black.
- Check the exact version and its support for your computer; capacity alone says nothing about recoverability.
Samsung
The Portable SSD T7 is a portable SSD. The grey version reviewed, MU-PC1T0T/WW, has a capacity of 1 TB.
- For this model, Samsung lists USB 3.2 Gen 2, sequential speeds of up to 1.050/1.000 MB/s and optional password protection with AES 256-bit encryption.
- These speeds are the manufacturer’s specifications, not a guarantee for every computer. The security feature needs to be enabled.
Toshiba
Canvio Basics is a range of portable HDDs, including a 2 TB version reviewed here.
- For the Canvio Basics reviewed, Toshiba specifies USB power and NTFS for Windows.
- For macOS, Toshiba says reformatting is required, which may erase any data on the drive. This applies to the version reviewed, not necessarily to every Toshiba drive.
Seagate
Expansion Portable offers portable HDD storage in several capacities, including 2 TB.
- Seagate describes file transfer and compatibility with Windows and Mac.
- Seagate states that using the drive with Time Machine requires reformatting. A product description doesn’t mean backups happen automatically.
Crucial
The 1 TB X9 is a portable SSD with a USB-C connection.
- For this model, Crucial lists a maximum read speed of 1.050 MB/s under its own test conditions.
- Crucial notes that compatibility depends on factors including formatting and the capabilities of the host computer.
Products at Joybuy
This selection includes portable SSDs and HDDs for storing spreadsheets and source files locally. Compare the capacity with your complete backup selection, and check that the connection and file system are suitable for your computer.
No image available
SanDisk Portable SSD 1TB
A portable SSD option for keeping a local copy of your files.
Capacity: 1 TB.
View at Joybuy
No image available
SanDisk Extreme Pro Portable SSD 1TB 2000MB/s
A portable SSD option for taking with you and storing files locally.
Capacity: 1 TB. The product name lists 2000MB/s; check the conditions that apply to this speed rating.
View at Joybuy
No image available
WD Elements Portable 5TB USB-C Graphite Black
A portable HDD option for large or growing local source folders.
Capacity: 5 TB. The product name lists USB-C. According to the Consumers’ Association, HDDs are more susceptible to impact than SSDs.
View at Joybuy
No image available
WD My Passport for Mac 2TB Blue
An HDD option if you want to use a local copy as part of a Mac backup routine.
Capacity: 2 TB. The product name lists Time Machine support and password protection; check the format and set up security.
According to the Consumers’ Association, HDDs are more susceptible to impact than SSDs.
View at Joybuy
No image available
WD My Passport 6TB White
A portable HDD option for a large local copy of your files.
Capacity: 6 TB. The product name lists password protection and Auto Backup Software; check how to set up these features.
According to the Consumers’ Association, HDDs are more susceptible to impact than SSDs.
View at Joybuy
Frequently asked questions
How do I make sure my local source files are backed up too?
Check where your spreadsheet and its associated source files are stored, then add both locations to your backup. Microsoft Support explains how to add folders outside the default libraries to File History. Then restore files from both locations and open them as a test.
Can a Windows-formatted drive be used straight away as a Time Machine drive?
Not necessarily. Apple says that Time Machine can’t store backups on a Windows file system and that reformatting erases existing data. Apple recommends APFS or APFS Encrypted for a new Time Machine backup drive.
Is one external drive enough as my only backup?
For important data, the National Cyber Security Centre recommends keeping multiple versions on different types of media, with a copy at another location, in line with the 3-2-1 guideline. This advice is intended to avoid relying on a single drive that could fail or go missing.
Does the GDPR require an encrypted external drive for every spreadsheet backup?
No, the GDPR doesn’t require every buyer to use one specific type of drive. The Dutch Data Protection Authority says organisations processing personal data must determine appropriate security measures based on the processing involved and the risks. Whether encryption is needed depends on that assessment.