Choose an external SSD that works with the computers involved, and use a backup method that lets you restore a file before the handover. If the spreadsheets contain personal data, also review access security and your agreement with the client. Keep a separate copy too, so the SSD isn’t the only usable version.
Who is this guide for?
People handing over confidential client data
You want to hand over or take a copy with you without making unauthorised access easy. First, check whether the spreadsheets contain personal data and how the recipient can open protected files. The Dutch Data Protection Authority stresses that organisations should tailor appropriate security measures to the risks.
People managing spreadsheet versions
You want to be able to retrieve an earlier spreadsheet version after a mistake or change. So check which files are included in the backup, and try restoring a file before the handover. The Digital Trust Center recommends testing backups regularly by restoring data.
People transferring files between different computers
You may not know which connection or process the client uses, and you want to be able to open files on both devices. Check the USB connections, file format and any security features before handing over the SSD. Samsung, Kingston and Transcend describe different connection options for the models mentioned here.
What should you look for in an SSD for a client handover?
| What to consider |
What should you check? |
Who is this important for? |
| Confidentiality |
Check whether the exact model offers password protection, set it up and test that the recipient can unlock the files. |
If you’re handing over client files that may contain personal data, you’ll want to decide who can open the copy and how. Around 31% of consumers rank confidentiality as their top purchasing priority. |
| Version recovery |
Check which folders and versions are saved, and try restoring a file. |
If you want to retrieve an earlier spreadsheet after a mistake or change, a tested recovery method matters more than simply making a copy. Around 25% of consumers rank recoverability as their top priority. |
| Connection and access |
Check the USB ports, file format and any software needed to access protected files on both computers. |
If you and your client use different computers, you’ll want to know whether the SSD and its files can be accessed on both. Around 19% of consumers prioritise compatibility between devices. |
| Capacity and speed |
Count the files and versions you want to keep. Choose a capacity to suit that amount, and don’t make maximum speed your only criterion. |
If you need space for files and multiple versions, match the capacity to your own backup needs. Around 13% of consumers prioritise having enough storage over speed for its own sake. |
| Protection in transit |
Compare the protection offered by the exact model, and keep a separate copy as well. |
If you’re taking the SSD to a client, consider the risk of knocks, dust or water while you’re travelling. Around 12% of consumers rank protection in transit as their top priority. |
Common pitfalls when backing up spreadsheets
-
Assuming a high quoted speed means a reliable backup
An SSD may transfer files quickly, but that doesn’t tell you whether the right folders and versions have been saved or whether you can restore them.
First, decide which files you want to keep and how you’ll restore them. Then compare the interface and speed with the way you plan to use it. The Digital Trust Center recommends using multiple storage locations and testing restores regularly.
-
Assuming a security feature is already set up
Password protection won’t protect a copy being handed over as intended if you haven’t set it up or the recipient can’t unlock it. The Dutch Data Protection Authority identifies the loss of a storage device containing unencrypted personal data as a possible data breach.
Set up your chosen security feature before copying files, then test access with the authorised recipient.
-
Reformatting a Time Machine drive without securing the existing copies
Apple warns that reformatting a Windows-formatted drive for Time Machine may erase existing data.
Decide in advance whether the SSD is for a Mac backup or for regular file transfers. Check the format and secure any existing data before reformatting.
Brands and models to compare
Samsung
The T7 is worth considering if you’re looking for password protection and supplied connection cables. The T7 Shield is designed for people who also want to factor in its stated protection in transit.
- Samsung lists USB-C and USB-A cables and configurable AES 256-bit password protection for the T7.
- Samsung rates the T7 Shield IP65 and says it can withstand drops from up to 3 metres. These features don’t automatically apply to every T7; set up security and test access.
Kingston
The XS1000 is worth comparing if capacity and connection options matter for your handover setup.
- Kingston specifies 1 TB and 2 TB versions of the XS1000, and lists a supplied USB-A cable and USB-C adapter.
- These model specifications don’t in themselves mean the SSD has built-in password protection. Check separately how you plan to secure the files.
Transcend
The ESD310 may be a good fit if you want to switch between USB-A and USB-C ports without a separate connection cable.
- Transcend lists built-in USB-A and USB-C connectors and an exFAT format as supplied for the ESD310.
- Check that the devices involved and your backup method work with the format and connections. These are features of this model.
Crucial
The X9 Pro is worth considering if support for password locking and firmware management matters to you.
- Crucial’s support page lists a Windows utility for locking and unlocking the X9 Pro with a password, as well as firmware updates.
- Before the handover, check how the recipient can open files on their own system. This information isn’t an independent performance test.
External SSDs on Joybuy
The portable external SSDs below are designed for storing and transferring spreadsheet files. Compare each model’s security, connections and capacity, along with any software requirements or compatibility conditions for the computers you use.
No image available
SanDisk Portable SSD 1 TB
A portable SSD for taking a copy of your files to a client.
The product information lists 1 TB of storage and a maximum read speed of 800 MB/s. It also states drop protection from up to 2 metres.
View at Joybuy
No image available
SanDisk Extreme Pro Portable SSD 1 TB
An option to compare if you’re considering a transfer copy with password protection and extra protection in transit.
The product information lists 256-bit AES hardware encryption, IP65 and drop protection from up to 3 metres. A compatible USB 3.2 Gen 2x2 device is required to reach the stated maximum read speed of 2000 MB/s; write speed is lower. According to the product information, password protection works on compatible Windows and macOS systems and may require software.
View at Joybuy
No image available
WD My Passport SSD WDBAGF0010BGY 1 TB
A portable option to compare if you want to protect files with password protection and hardware encryption.
The product information lists USB-C, read speeds of up to 1050 MB/s and write speeds of up to 1000 MB/s, along with compatibility with Windows and macOS. WD Security software must be downloaded and installed for password protection and hardware encryption; check that this suits your handover.
View at Joybuy
No image available
Portable SSD 1 TB
A portable option for storing files and connecting to different devices.
The product information lists a USB 3.2 Gen 2 interface and a maximum speed of 1000 MB/s. It also lists an integrated USB-C cable with a USB-C-to-USB-A adapter, and compatibility with Windows, macOS, iPadOS and Android.
View at Joybuy
No image available
Samsung Portable SSD T7 2 TB
An option to compare if you need more storage and connection options for different computers.
The product information lists read speeds of up to 1050 MB/s, write speeds of up to 1000 MB/s and AES 256-bit encryption. It also lists compatibility with Windows, macOS and Android, plus supplied USB-C-to-C and USB-C-to-A cables. Check the security settings and test that the recipient can open the files.
View at Joybuy
Frequently asked questions
Is copying spreadsheets to an SSD enough for a backup?
Not unless you’ve checked that the right files and versions have been saved and can be restored. Keep a separate copy and try restoring a file; the Digital Trust Center recommends using multiple storage locations and testing restores regularly.
How can you retrieve earlier versions of spreadsheets in Windows?
You can use Windows File History with an external drive. Check that the right folders are included in the backup, and test restoring an earlier version, as described by Microsoft Support.
Can you use the same SSD for Time Machine and regular file transfers without any changes?
No. First check the format and intended use. Apple says that a Windows-formatted drive can’t be used directly as a Time Machine drive, and that reformatting may erase existing data.
Is encryption legally required for every SSD transfer?
This depends in part on the data and the risks involved in processing it; the Dutch Data Protection Authority doesn’t specify one security setting for every transfer. Organisations processing personal data must determine appropriate measures based on the risks, and losing a storage device containing unencrypted personal data may result in a data breach.
Do you need a data processing agreement for a client handover?
You may need one if one party processes personal data on behalf of another organisation and doesn’t use it for its own purposes. The Dutch Data Protection Authority says that a written data processing agreement is required in this situation. First, establish the roles of the parties and whether personal data is involved.