Who is this buying guide for?

Anyone responsible for older project versions

If you want to recover an overwritten or deleted spreadsheet, you’ll need a system that’s set up to save older versions, along with a tested way to restore them. Microsoft Support and Apple Support explain the relevant File History and Time Machine features.

Anyone managing growing project archives

If you keep several project folders and older versions, base the capacity on the amount of data you actually have and how much history you want to retain. Apple Support recommends using a Time Machine backup drive with at least twice the storage capacity of your Mac. This recommendation applies to that particular use case.

Anyone working on the move with confidential spreadsheets

If you carry the drive and spreadsheets between devices or work locations, check the connections, the restore process and whether you need suitable access protection. Germany’s Federal Commissioner for Data Protection and Freedom of Information describes risk-appropriate technical and organisational measures for data controllers and processors.

What should you look for when buying?

First, set up version backups and test that you can recover an older version. You can then choose an SSD based on the size of your archive, the devices you use and whether you need access protection.

What you need What to look for Who it matters most to
Restore older versions Check that the backup feature covers the relevant project folders and keeps older versions. Test restoring a file. If I need to recover an overwritten or deleted spreadsheet, a tested version history matters more than the SSD’s top speed. Around 36% of consumers put restoring older versions first.
Space for project versions Check the size of the folders you need to back up and allow for the history you want to keep. Compare the result with the capacity of the specific model. If I need to keep several project folders and their older versions, I need enough space for the whole archive. Around 29% of consumers prioritise having enough storage for archives and versions.
Access across multiple devices Check the USB ports, cables and backup feature of the operating system you use. Make sure the drive can also be read by the device you’ll use to restore files. If I back up or restore files on different devices, the connection needs to work in both cases. Around 21% of consumers prioritise device access.
Protect confidential spreadsheets Check whether encryption is available for your devices and how you’ll keep the recovery password safe. Protection for the casing does not protect access to your data. If my spreadsheets contain confidential information and I take the drive out and about, I want to consider how to prevent unauthorised access. Around 14% of consumers prioritise protecting confidential data.

Which assumptions should you avoid?

  • Confusing a current file copy with a version archive

    A single copy of your current spreadsheet won’t automatically keep earlier versions. You’ll only be able to access them if you set up a suitable backup system.

    Set up versioning for the relevant project folders and test that you can restore an earlier version.

  • Treating the maximum MB/s figure as the most important factor for small spreadsheets

    The stated maximum speeds for USB 3.2 Gen 2x2 require a compatible host device and suitable cables. For occasional backups of small spreadsheets, a higher maximum speed alone doesn’t guarantee a corresponding time saving.

    Check capacity and connection requirements first. Give higher speeds more weight if you regularly transfer large project folders and your devices support the required connection.

  • Confusing casing protection with data protection or a second backup

    An IP rating relates to external conditions the casing can withstand; it doesn’t protect access to the spreadsheets stored on the drive. A single SSD is not a substitute for a separately stored backup either.

    For important files, keep another copy in a separate location. If your spreadsheets are confidential, also consider suitable access protection.

Which brands are worth considering?

Samsung

The T7 Shield and T9 differ in areas including connection requirements and stated casing features.

  • Samsung states that the T7 Shield has an IP65 rating under controlled conditions. For the T9, the manufacturer quotes speeds of up to 2,000 MB/s when the host device, cable and enabled UASP meet the requirements.
  • Samsung notes that liquid and dust damage to the T7 Shield is not covered by the warranty. The T9’s maximum speed is not a guaranteed speed for spreadsheet backups.

Kingston

The XS1000 is a Gen 2 option, while the XS2000 is designed for larger transfers over USB 3.2 Gen 2x2.

  • Kingston quotes read speeds of up to 1,050 MB/s for the XS1000 and lists USB-A cables and adaptors for the range. For the XS2000, the manufacturer quotes speeds of up to 2,000 MB/s and an IP55 rating with the removable rubber sleeve fitted.
  • These specifications apply to the respective product ranges and their connection and protection requirements. They don’t mean that versioning happens automatically or that your data is backed up without another copy.

Crucial

The X9 Pro is a compact external SSD for anyone who wants a portable backup drive with a stated level of dust and splash resistance.

  • Crucial quotes speeds of up to 1,050 MB/s and an IP55 rating for the X9 Pro. The speed figure is based on a manufacturer test and requires a suitable USB 3.2 Gen 2 connection.
  • The maximum speed recorded in the manufacturer’s test does not guarantee the same performance with every device or backup task.

Joybuy products for spreadsheet backups

These external SSDs can be used as storage destinations for spreadsheet backups. To keep older project versions, you’ll also need to set up a backup system.

KEXIN external SSD with 256 GB

KEXIN external SSD, 256 GB, USB 3.1 Type-C

A suitable storage destination for spreadsheet backups if 256 GB is enough for your files and the history you want to keep. To retain older versions, you’ll need to set up an additional backup system.

256 GB; USB 3.1 Type-C; up to 500 MB/s.

Joybuy
Kexin M.2 SATA external SSD with 256 GB

Kexin M.2 SATA external SSD, 256 GB, USB 3.1

A suitable storage destination for spreadsheet backups if 256 GB is enough for the folders you need to back up and the history you want to keep. The SSD does not create a version history by itself.

M.2 SATA; 256 GB; USB 3.1; up to 500 MB/s.

Joybuy
Kexin M.2 SATA external SSD with 512 GB

Kexin M.2 SATA external SSD, 512 GB, USB 3.1

A suitable storage destination for spreadsheet backups if its capacity is right for your files and the history you want to keep. You’ll need a separate backup system to restore older versions.

M.2 SATA; 512 GB; USB 3.1; up to 500 MB/s.

Joybuy
KEXIN external SSD with 512 GB and USB-C

KEXIN external SSD, 512 GB, USB-C

A suitable storage destination for spreadsheet backups if 512 GB is enough for the folders you need to back up and their older versions. The SSD is not a substitute for separately configured versioning.

512 GB; USB-C.

Joybuy
MOVESPEED Portable SSD YSPSRX20M-1TTG with 1 TB

MOVESPEED Portable SSD YSPSRX20M-1TTG, 1 TB, USB 3.2 Gen 2x2

The 1 TB model could be a suitable storage destination if its capacity matches your project files and the history you want to keep. Its advertised top speed requires a compatible port and suitable cable. Older versions must be backed up separately.

1 TB; USB 3.2 Gen 2x2; advertised top speed: 2,060 MB/s.

Joybuy

Frequently asked questions about SSD backups

Does every external SSD automatically save older versions of my spreadsheet?

No. On Windows, configured File History can restore earlier versions of folders it covers. On a Mac, Time Machine can restore earlier versions of files. Check that the relevant project folder is included.

How can I check that my backup works after setting it up?

Try restoring an older spreadsheet version or a sample file, then open it. Germany’s Federal Office for Information Security notes that you need to make sure your data can be restored.

How much storage does Apple recommend for a Time Machine backup?

Apple recommends a backup drive with at least twice the storage capacity of your Mac. This is a recommendation for Time Machine, not a general minimum for all spreadsheet backups. Also check the setup instructions, as the selected volume may be erased during the process.

Is a higher top speed worth it for spreadsheet backups?

If you mainly work with small spreadsheets, the advertised sequential top speed won’t necessarily be the deciding factor. To reach the stated Gen 2x2 maximum speeds, both the host device and cable must support USB 3.2 Gen 2x2. If you regularly transfer large files, this connection requirement may affect your choice.

Does an SSD containing project data about people need to be hardware-encrypted in Germany?

You can’t infer a blanket requirement to buy a hardware-encrypted SSD. For data controllers and processors within the scope of the GDPR, Germany’s Federal Commissioner for Data Protection and Freedom of Information describes risk-appropriate technical and organisational measures. Whether encryption is necessary for your spreadsheets depends on the data and how it is processed.