First, choose a backup method that lets you restore older file versions: the drive itself does not store version history. An HDD may suit stationary backups that need plenty of space; an SSD may be a better choice if you’ll be carrying it around frequently or need to copy large files quickly. Also check your computer’s capacity, connection and backup format, and make sure confidential spreadsheets are protected from unauthorised access.
Which solution is right for you?
Teams with many spreadsheet versions
If project files change frequently and you need to retrieve a specific earlier version, setting up versioned backups is essential – not choosing a particular drive brand. Microsoft Support explains how to restore earlier file versions using Windows File History, while Apple Support covers the same process with Time Machine.
Project archives with growing storage needs
If you want to keep a large number of projects or a longer backup history, plan for the folders you need to back up and how long you want to keep them. Apple recommends using a device with at least twice the storage capacity of your Mac for a complete Time Machine backup; this is not a general minimum size for individual spreadsheet folders.
People who carry confidential backups with them
If you take spreadsheets containing sensitive information with you, check not only the connection and ease of use but also how the backup is protected from unauthorised access if it’s lost. The Federal Commissioner for Data Protection and Freedom of Information points out that an encrypted backup offers no protection if the device is switched on or unlocked.
What should you consider when buying?
Before choosing a drive, check which folders your backup method covers and whether you can test restoring an older version of a project.
| What you need |
What to check before buying |
Who should pay particular attention? |
| Earlier spreadsheet versions |
Include the relevant folders in your backup and check whether the method can restore multiple versions. |
If I want to return to a specific earlier project version after making a change, versioning is my top priority. Around 31% of consumers prioritise restoring older versions. |
| Space for projects and backups |
Work out how much data you have and how long you want to keep it; for complete Time Machine backups, follow Apple’s recommendation based on your Mac’s capacity. |
If you want to keep several projects and their backup versions, you’ll need enough storage for the history you want to retain. Around 31% of consumers put capacity first. |
| Confidential backups |
Check whether the backup can be encrypted and store the recovery password securely. |
If my project spreadsheets contain sensitive information and I’m carrying the drive with me, access protection matters most. Around 23% of consumers prioritise protecting confidential backups. |
| Connection and portability |
Check that the USB connection matches your computer and that you have the right cables; before setup, check the file system and whether formatting may be needed. |
If you use backups in different locations or with different devices, you’ll want a drive that’s easy to connect and carry. Around 15% of consumers put mobile access first. |
Common backup mistakes
-
Copying only the latest spreadsheet and assuming that’s versioned backup
A copy of the current file won’t automatically include earlier project versions. To restore a specific version, your backup method needs to keep multiple versions.
Include your project folders in the backup and try restoring an older version.
Overwritten project versions may be missing if they weren’t backed up beforehand.
-
Assuming a faster SSD can make up for insufficient storage
Transfer speed and capacity solve different problems. An HDD may suit backups that are mostly kept in one place, if storage space matters more than fast transfers.
First work out how much data you have and how much history you want to keep, then compare drive types and capacities.
If there isn’t enough storage for the backup history you want, you may need another drive.
-
Assuming the drive’s factory file system means it’s ready for Time Machine
A file system for general file sharing doesn’t mean the drive is already set up as a Time Machine backup volume. You may need to reformat it during setup, which can erase any existing data.
Before setting up the drive, check its format and any files stored on it, then configure the backup volume for the method you’ve chosen.
-
Assuming a permanently connected drive provides complete protection
Backup media can fail too. What matters is whether you can actually restore your files when you need them.
Consider keeping another copy separately and test restoring your files from time to time.
Keeping a separate backup and regularly checking that you can restore it take extra effort.
Relevant brands at a glance
Toshiba
The Canvio Basics range includes USB-powered external HDDs in several capacities for the EMEA market.
- Toshiba says the range is ready to use with Windows, with no additional installation required.
- Toshiba says the drive needs to be reformatted for use with a Mac. The range does not automatically set up versioned backups.
Seagate
Expansion Portable is a range of compact, USB-powered HDDs; the data sheet lists the STKM2000400 model with 2 TB of storage.
- For this range, Seagate lists simple file transfers and a Rescue Data Recovery Service.
- Seagate says the service is not available in every country. It is not a replacement for setting up version history.
Samsung
The Portable SSD T7 is a range of portable SSDs. The grey 1-TB version has the model number MU-PC1T0T/WW.
- Samsung lists USB-C and USB-A cables for this version, along with optional password protection using AES-256 hardware encryption.
- Check that the connection is compatible with your computer and decide whether you want to enable password protection for your backup.
Intenso
The external SSD Premium is a range of USB 3.2 Gen 1×1 SSDs. Intenso offers, among others, 1-TB versions with different product numbers.
- The manufacturer’s data sheet lists exFAT and cables for USB-A and USB-C.
- The factory file system does not mean the drive is set up as a Time Machine volume.
Crucial
The portable X9 SSD is listed as a 1-TB model, CT1000X9SSD9.
- Crucial lists Windows File History and Time Machine as possible backup methods.
- Crucial says the drive comes formatted as exFAT and can be reformatted; this will erase any existing data on the drive.
Joybuy products for external backups
This selection includes external HDDs and SSDs for backing up project spreadsheets, with options for both portable and mostly stationary use.
No image available
WD Elements Portable 5 TB USB-C
Could serve as a portable storage destination for backups as your storage needs grow; you’ll need to set up a backup method to keep older versions.
5 TB; USB-C; portable 2.5-inch drive, according to the product description.
View at Joybuy
No image available
WD Elements Portable 4 TB USB-C
Could serve as a portable storage destination for backing up several projects; you’ll need to configure your backup method to keep a version history.
4 TB; USB-C; portable 2.5-inch drive, according to the product description.
View at Joybuy
No image available
WD Elements 2 TB external hard drive, USB-C
A portable option for extra storage and backups; the drive itself won’t create older file versions.
2 TB; USB-C; preformatted as exFAT, according to the product description.
View at Joybuy
No image available
WD Elements 8 TB desktop hard drive, USB 3.0
Could suit large backups in a mostly stationary setup; the external power supply is required to operate the drive.
8 TB; USB 3.0; 3.5-inch drive, according to the product description.
View at Joybuy
No image available
Kexin M.2 SATA external SSD, 256 GB
Could suit portable backups if its stated capacity is sufficient for your files and the version history you want to keep.
256 GB; USB 3.1; supplied with USB-C and USB-A cables, according to the product description.
View at Joybuy
Frequently asked questions
Does an external hard drive automatically back up older versions of my spreadsheets?
No, you’ll need to set up a versioned backup method. Check that it includes your project folders: on Windows, File History can restore earlier versions; on a Mac, Time Machine can retrieve older file versions.
What should I bear in mind when setting up a backup on a Mac?
Before setting up the drive, check whether it needs to be formatted, as this can erase any stored data. Apple recommends using a device with at least twice the storage capacity of your Mac for a complete Time Machine backup; this is not a general minimum size for individual spreadsheet folders.
How can I check whether my backup will work when I need it?
Try restoring an older project file and check its contents. The Federal Office for Information Security emphasises that you also need to be able to restore data from your backup medium.
Is a particular encrypted drive required for project spreadsheets in Germany?
The term “project spreadsheets” alone does not mean that a particular drive is required. If an organisation processes personal data, Article 32 of the GDPR requires appropriate technical and organisational safeguards. The Federal Commissioner for Data Protection and Freedom of Information says that decisions about encryption should take risk and the level of protection required into account. So check what the spreadsheets contain and how they’ll be used.