Who is this choice relevant to?

Anyone handing over files who wants to check they can be restored

You want to check before the handover that the right spreadsheet version has been saved and can be restored. The National Cyber Security Centre recommends carrying out a recovery test.

Anyone handing over files containing confidential customer data

You want to know who can access files that may contain personal data, and what safeguards are appropriate for processing them. The Dutch Data Protection Authority stresses that security measures depend on the specific processing activity and its risks.

Anyone handing over files between different computers

For example, you may work on both Windows and Mac and want to check in advance that the connection, formatting and backup method work on both computers. Microsoft Support and Apple Support explain the options and requirements for their backup features.

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.

Pitfalls when choosing a backup drive

  • Assuming a copied folder is a tested backup

    A successful copy doesn’t prove that the right files and versions can be restored. You may only discover a problem when it’s time to hand them over.

    Make the copy before the handover, restore a test file and keep a separate backup. The National Cyber Security Centre recommends carrying out a recovery test.

    Missing versions could cost you time or may no longer be available when you need them for the handover.

  • Assuming a brand name or encryption claim means security is enabled

    Features vary between product ranges, and you may need to set up security features before using them. Manage the password carefully so authorised users can restore the files too.

    Check support for the exact model, enable your chosen protection and ask an authorised user to test recovery.

    Western Digital warns that data on drives supporting WD Security could be lost if you forget the password.

  • Erasing a Windows-formatted drive for Time Machine before securing any copies

    Apple Support says that reformatting a drive for Time Machine can erase existing data on it.

    Check the file system and make sure any files already on the drive are safely stored elsewhere before setting up the backup volume.

    Files already on the drive could be lost if you don’t copy them somewhere safe first.

Brands worth considering

Samsung

The T7 range is worth considering if you’re looking for a portable SSD with optional password protection. Check the exact model.

  • For the 1 TB T7, Samsung lists USB-C-to-C and USB-C-to-A cables in the box, plus optional password protection with AES-256 encryption.
  • The quoted speed is a manufacturer specification, not a measured advantage for small spreadsheets. Features of the T7 Shield don’t automatically apply to the standard T7.

Western Digital

Elements Portable and My Passport are different product ranges. Compare them based on the features you need.

  • According to its product page, the 1 TB Elements Portable reviewed here is formatted for Windows.
  • WD lists My Passport, but not Elements, among drives that support WD Security. Check the exact model and set a password if you use this feature.

Kingston

The XS1000 is a compact external SSD for anyone looking for a portable copy of their files and a connection to USB-A or USB-C devices.

  • Kingston lists 1 and 2 TB capacities for the XS1000 and includes a cable and adapter.
  • The specifications reviewed don’t confirm built-in password protection, so don’t assume it’s available without checking the exact model.

Seagate

The Expansion Portable is an HDD range for transferring files and adding extra storage.

  • Seagate describes file transfers using drag and drop and lists a USB 3.0 connection.
  • This product description doesn’t confirm access protection, and the drive isn’t automatically a tested or sole backup.

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.

SanDisk Portable SSD 1 TB

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
WD My Passport for Mac 2 TB Blue portable hard drive

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
WD Elements Portable 2 TB USB-C Graphite Black

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
Samsung Portable SSD T7 1 TB USB Type-C 3.2 Gen 2 Blue

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
Samsung MU-PE1T0S 1 TB USB Type-C 3.2 Gen 2 Black

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.