If you’ll be taking the drive with you regularly during your move, a portable SSD is a practical choice. According to the Dutch Consumers’ Association, it’s more compact and less vulnerable to knocks than a traditional HDD. An HDD may suit you if you want to store lots of other files as well as spreadsheets, and can protect the drive in transit. Check how much storage you need, the connection and formatting, and test that you can restore a spreadsheet. One external drive isn’t a complete backup strategy.
Who is this guide for?
Moving with important records
Wants to be able to restore spreadsheet versions after losing or damaging a computer. The National Cyber Security Centre advises keeping at least three versions of important business data: the original files and two backups.
Moving and taking the drive with you
Moves the backup between locations, so a compact size and protection in transit are important. The Dutch Consumers’ Association says SSDs are less vulnerable to knocks than traditional HDDs.
Moving with lots of extra files
Wants to store larger folders as well as spreadsheets, and compares the space needed and connection with their own computer.
What should you look for in an external backup drive?
Portable SSD
Choose this option: if you’ll be taking the drive with you and value compactness and greater resistance to knocks.
Bear in mind: a rugged design or a high stated speed doesn’t replace keeping a second copy somewhere separate.
Portable HDD
Choose this option: if you want to store lots of other files as well and can protect the drive while it’s in transit.
Bear in mind: according to the Dutch Consumers’ Association, an HDD is more vulnerable to knocks than an SSD, so protect it in transit.
| What to consider |
What should you check? |
Who is this for? |
| Restorable backup |
Make a recent copy, restore a spreadsheet as a test and keep an extra copy in a different location. |
I want to be able to restore the right spreadsheet version after losing or damaging my computer. Around 33% of consumers put the ability to restore files first. |
| Protection in transit |
Compare the size and protection specified for the exact model; carry the drive protected and disconnected. |
If I need to take the drive between locations, I look for a compact design and protection against knocks. Around 25% of consumers prioritise durability in transit. |
| Confidentiality |
Check what encryption is available and test that you can open the backup using the password you’ve kept safe. |
My spreadsheets may contain confidential information, so I want to protect them if the drive is lost. Around 17% of consumers put confidentiality first. |
| Connection and backup method |
Check the port, supplied cable or adapter, and required drive format before saving any existing files to it. |
I want to be able to use the drive with my computer and chosen backup method without losing existing files. Around 17% of consumers focus mainly on the connection and setup. |
| Storage space needed |
Check the size of the folders you want to keep and decide whether you need to store files or a full system image as well. |
I want to take lots of other files with me alongside my spreadsheets, so I’ll choose a suitable capacity. Around 8% of consumers prioritise storage space. |
Common mistakes when backing up on the move
-
Taking your only backup with your computer
If they’re both kept in the same place, one incident could affect both the original and the backup.
Keep another copy in a different location too, and test that you can restore a spreadsheet.
-
Formatting a drive without checking what’s on it
You may need to reformat a drive for Time Machine, which can permanently erase any files already on it.
Before setting it up, check whether the drive contains files you want to keep and move them somewhere else first if needed.
-
Treating ruggedness or data recovery as a replacement for a second copy
Protection against dust, water or drops won’t prevent every kind of data loss. Seagate’s Rescue Data Recovery Services are also not available in every country.
Think of protection as an extra feature, keep a separate backup and check the terms of any recovery service for the exact model.
Brands and product ranges to consider
Samsung
The Portable SSD T7 Shield is a range of portable SSDs, with a documented 1 TB model.
- For the blue MU-PE1T0R/EU, Samsung specifies IP65 and drop resistance of up to 3 metres.
- These are manufacturer claims for this model, not a guarantee that your data will survive an accident. The stated 1.050/1.000 MB/s refers to sequential read and write speeds, not the speed of a spreadsheet backup.
Seagate
The Expansion Portable range includes portable HDD models, including the 2 TB STKM2000400.
- According to Seagate, this model is powered via USB.
- According to the Dutch Consumers’ Association, an HDD is more vulnerable to knocks than an SSD. Seagate says Rescue Data Recovery Services aren’t available in every country.
Kingston
The XS1000 is a compact external SSD range, with 1 TB and 2 TB models.
- Kingston lists a USB-A cable and USB-C adapter, and stated read and write speeds of up to 1.050/1.000 MB/s.
- Check the exact colour and model, and make sure your files have the protection you need for the way you’ll use it.
Crucial
The X9 Portable SSD is a compact SSD range; the product variant described is the 1 TB CT1000X9SSD9.
- Crucial lists USB-C and a stated read speed of up to 1.050 MB/s.
- According to Crucial, compatibility may depend on the formatting and the capabilities of the connected device.
Joybuy products for backups during a move
This selection includes portable SSDs for carrying and backing up files, plus a portable HDD for anyone who also wants to store larger folders.
No image available
SanDisk Portable SSD 1 TB
A 1 TB portable SSD for spreadsheet files you want to take with you during your move.
1 TB storage; stated read speed of up to 800 MB/s; drop protection up to 2 metres.
View at Joybuy
No image available
SanDisk Extreme Pro Portable SSD 1 TB
A 1 TB portable SSD for backups you want to take with you; the description mentions password protection.
USB-C; USB-C cable and USB-A adapter included; IP65; drop protection up to 3 metres; 256-bit AES encryption.
View at Joybuy
No image available
Portable SSD 1 TB 1.000 MB/s
A 1 TB portable SSD for spreadsheet files you want to take between locations.
USB-C; stated read speed of up to 1.000 MB/s; drop protection up to 2 metres.
View at Joybuy
No image available
Samsung Portable SSD T7 2 TB USB Type-C Blue
A 2 TB portable SSD for spreadsheets and extra folders; the description mentions password protection.
USB-C; USB-C to USB-C and USB-C to USB-A cables included; AES 256-bit hardware encryption; drop resistance up to 2 metres.
View at Joybuy
No image available
WD Elements Portable 2 TB USB-C Graphite Black
A 2 TB portable HDD for anyone who wants to store larger folders as well as spreadsheets, and can protect the drive in transit.
2 TB storage; USB-C. According to the Dutch Consumers’ Association, an HDD is more vulnerable to knocks than an SSD.
View at Joybuy
Frequently asked questions
How can you make a backup of your spreadsheets before your move and check that it works?
Make a recent copy of your files, check that you’ve included the right folder and restore a spreadsheet as a test. Microsoft explains how File History can save files and earlier versions to an external drive. Keep another copy in a different location too.
Can you use the same drive for Time Machine straight away?
Not always: a drive formatted for Windows may need to be reformatted for Time Machine, which permanently erases any files already on it. Apple therefore recommends checking the required format before setting it up and keeping your files somewhere else.
Should you encrypt spreadsheets on a drive you take with you?
If they contain confidential information, encryption is a relevant way to protect them. For organisations that process personal data, the Dutch Data Protection Authority says the appropriate measures will depend on the circumstances. Check that your chosen drive and backup method support encryption, and keep the password safe.
Does a manufacturer’s warranty mean you’ll get your files back if the drive fails?
No. Don’t assume a manufacturer’s warranty covers data recovery. The Dutch Government says that if a product is faulty, the seller must provide a solution, and that there is no fixed statutory warranty period in the Netherlands. Keep separate backups and check any data recovery services separately.