Who is this guide for?

Manager of linked spreadsheets

Your spreadsheet refers to local source workbooks or other data files. If you need to restore it, you want to recover not just the spreadsheet but also its source files and working links. Microsoft Support explains how workbook links refer to source files and why their locations in relation to one another can matter.

Creator of regular version backups

You update files frequently and want to be able to restore an earlier version too. The space you need depends on your files, your backup method and how many versions you want to keep. Microsoft Support and Apple Support describe backup features for Windows and Mac respectively.

User with sensitive files

You carry administrative or other confidential files and want to factor in the risk of loss and unauthorised access. The Dutch Data Protection Authority says that organisations processing personal data must determine appropriate security measures for themselves.

What should you consider when choosing?

Start by listing your spreadsheets, source files and the versions you want to keep. Then check capacity, connectivity and security. Assess the advertised speed in the context of your computer and backup routine.

What to consider What to look for when buying Who is this more important for?
Complete recovery Identify your source files and where they’re stored. Restore a test copy and check the data connections and workbook links. If I use linked spreadsheets, I want to be able to restore the necessary source files and their folder structure too; around 31% of consumers prioritise complete recovery.
Previous versions Decide how many versions you want to keep and check which folders your chosen backup software actually includes. If I update files regularly, I want to be able to restore an earlier version; around 25% of consumers prioritise version recovery.
Confidentiality Check that your SSD, computer and backup process support appropriate encryption and access protection when used together. If I carry confidential files, I want to consider access if they’re lost while still allowing authorised people to recover them; around 19% of consumers put confidentiality first.
Connectivity and use Check your computer’s ports, the cable or adapter supplied and the requirements of your backup software. If I want to use the SSD with my own computers, I want to make sure it’s compatible with my devices and easy to use; around 13% of consumers prioritise usability.
Overall backup setup Decide what copies and storage locations you need in addition to the SSD, and how they fit into your retention schedule. If I’m setting up a complete backup routine, I want to know in advance what other copy and storage location I’ll need; around 12% of consumers look at the overall setup first.

Common pitfalls

  • Copying only the spreadsheet file

    A spreadsheet may refer to separate source workbooks or external data files. Without those files, a restored spreadsheet may be missing essential data or links.

    Make a note of your source files and where they’re stored. Test a restore to a different location and check that the links still work.

  • Assuming one connected SSD is a complete backup strategy

    The National Cyber Security Centre’s guidance for important business data recommends at least three versions: the original files and two backups. One SSD won’t create those versions for you.

    Decide what other copy you need in addition to the SSD, and test that you can restore files from it.

  • Assuming maximum MB/s figures reflect the speed of your own backup

    An advertised maximum isn’t the same as a measurement of your files and computer. The connection you use and your backup method also make a difference.

    First, check your computer’s port and cable. Then weigh the advertised speed against capacity and recoverability.

Relevant brands to consider

Samsung

The Portable SSD T7 is a compact option for file backups; the T7 Shield is a separate product range.

  • Samsung lists maximum read and write speeds of 1.050 MB/s and 1.000 MB/s respectively for the T7 MU-PC1T0T/WW. USB-C-to-C and USB-C-to-A cables are listed for this model; AES-256 password protection is optional.
  • These are manufacturer maximum speeds, not a measurement of a spreadsheet backup. Check the specifications for the exact version.

Kingston

The XS1000 is a compact option if USB-A and USB-C connections are part of your workflow.

  • Kingston lists 1 TB and 2 TB versions, USB 3.2 Gen 2 and maximum read and write speeds of 1.050 MB/s and 1.000 MB/s respectively. The brand says a cable and adapter for USB-A and USB-C are included.
  • These are manufacturer maximum speeds, not a guarantee of how quickly your backup will run. Check which cables and adapters are included with the specific version.

Crucial

The X9 is a USB-C option for file storage; Crucial says it works with Windows File History and Apple Time Machine.

  • Crucial lists a maximum read speed of 1.050 MB/s for the X9 CT1000X9SSD9 and says it comes formatted as exFAT.
  • Compatibility can depend on your computer and formatting. Crucial says reformatting erases the existing data on the drive, so make a copy of anything stored on it first.

SanDisk

The Portable SSD is a portable product range for general storage. Specifications for an Extreme model don’t automatically apply to this range.

  • SanDisk’s Portable SSD data sheet lists read speeds of up to 800 MB/s and drop protection from heights of up to two metres.
  • These claims apply to the product range named above. Check the specifications for the exact version, and don’t assume that features of another model apply to this SSD.

External SSDs at Joybuy

This selection includes external SSDs for storing copies of spreadsheets and source files, with compact options and a model for anyone who values physical protection. An SSD on its own won’t automatically manage versions or provide a second backup.

SanDisk Portable SSD 1TB

SanDisk Portable SSD 1TB

This 1 TB external SSD could suit copies of spreadsheets and source files. Check that there’s also enough room for the versions you want to keep.

View at Joybuy
SanDisk Extreme Pro Portable SSD 1TB 2000MB/s

SanDisk Extreme Pro Portable SSD 1TB 2000MB/s

This 1 TB option could suit you if physical protection is a priority. Check that your computer’s connection can support the transfer speed you want.

View at Joybuy
My Passport SSD WDBAGF0010BGY 1 TB

My Passport SSD WDBAGF0010BGY 1 TB

This 1 TB external SSD is worth considering for confidential files. Check that its connection suits your computer and backup process.

View at Joybuy
Portable SSD 1TB 1000MB/s

Portable SSD 1 TB 1000 MB/s

The product name lists 1 TB and 1.000 MB/s. Check that your computer and backup software suit the connection and the way you plan to use it.

View at Joybuy
Samsung Portable SSD T7 2TB USB Type-C 3.2 Gen 2 (3.1 Gen 2), Blue

Samsung Portable SSD T7 2TB USB Type-C 3.2 Gen 2 (3.1 Gen 2), Blue

The listed 2 TB capacity could suit a larger collection of files and versions. Work out how much space you need based on your own retention schedule.

View at Joybuy

Frequently asked questions

Is a copy of just your spreadsheet enough?

Not if you also need local source workbooks or external data files to restore it. Include those files, preserve their locations in relation to the spreadsheet where necessary, and check the links after a test restore. The files you need depend on the spreadsheet and the connections it uses; Microsoft Support explains how workbook links work with source files.

Can you automatically keep older versions on an external SSD?

That depends on your backup software and the folders you select. Microsoft Support explains version recovery with File History, while Apple Support describes automatic backups with Time Machine. When setting up your backup, check that it includes both your spreadsheets and local source files.

What should you consider when formatting a drive for your computer?

First, check the requirements of your operating system and backup method. Crucial says the X9 comes formatted as exFAT and that reformatting erases existing data on the drive. Don’t assume the factory format is suitable for every backup task without checking first.

If a product develops a fault, are you limited to the manufacturer’s warranty?

No. When you buy as a consumer in the Netherlands, you have statutory rights in addition to any commercial or manufacturer’s warranty. According to the Authority for Consumers & Markets’ ConsuWijzer, the seller is responsible if a product used normally doesn’t do what you could reasonably expect. There isn’t one fixed time limit in years that applies to all products.

Does the GDPR require you to buy a particular type of encrypted SSD?

No. The Dutch Data Protection Authority’s guidance cited here doesn’t prescribe one specific type of SSD for everyone. An organisation processing personal data must determine appropriate security measures based on the risks. The right level of security for your situation therefore depends on the data and how you use it.