Who is this choice relevant to?

Spreadsheet user who wants to restore earlier versions

If you want to restore an earlier version after a mistake or computer problem, it helps to have a backup set up for the right folders. Microsoft Support explains how File History can help restore earlier versions of backed-up files.

User with limited desk space

If space is tight, you’ll want a small drive that works with an available port on your computer, without unnecessary cables or adapters. Dimensions and included cables vary by model.

User managing sensitive files

If you store spreadsheets that shouldn’t be accessible to others, consider whether encryption is appropriate and how you’ll retain access when restoring files. The Dutch Data Protection Authority highlights the security of personal data as an important consideration for organisations that process it.

What should you look for?

First, decide how you want to restore files and check which connection your computer has. Then choose the storage capacity and any security features based on your files and backup method.

What to consider What should you check? Who is this most relevant to?
Restorable backups Check that the right folders are included, when the last copy was made and whether a test restore works. If I want to restore an earlier spreadsheet version after a mistake, I need to know that the right folder is included and that restoring works. Around 36% of consumers put the ability to restore files first.
Connection and size Check your computer’s port and the included cables. The Kingston XS1000 measures 69,54 × 32,58 × 13,5 mm, according to Kingston Technology. If I have limited desk space, I want a drive that fits without the hassle of extra cables. Around 29% of consumers value connectivity and compact size most.
File protection Check whether you need encryption, whether you need to set it up and how you’ll keep the password available for restoring files. If my spreadsheets contain sensitive data, I want to be able to restrict access if the drive is lost and still restore files myself later. Around 21% of consumers give data protection their highest priority.
Capacity Check the size of the folders you want to keep and allow for multiple versions. For Time Machine, Apple ideally recommends a drive with at least twice the storage capacity of your Mac. This isn’t a general requirement for backing up individual spreadsheet folders. If I want to keep several folders or versions, I need enough space without treating my spreadsheet backup as a full computer backup. Around 14% of consumers put the storage space they need first.

Common buying pitfalls

  • Moving files instead of copying them

    A backup is a separate copy you can use if the original file or device is lost. If you move your only file, you won’t have a copy left behind.

    Keep the original file, regularly copy the right folders and test that you can restore a file.

  • Focusing only on the quoted MB/s

    A manufacturer’s maximum speed doesn’t tell you how quickly spreadsheet files will be backed up on your computer. Kingston and Crucial say that quoted speeds depend on the computer and conditions of use.

    Check your computer’s port, cable and backup settings first. Don’t choose a speed rating in isolation from these factors.

  • Formatting a Mac backup drive when it already contains files

    Apple notes that a drive may need to be reformatted for Time Machine. Any existing files on the drive could be erased in the process.

    Check the drive format and move any files you want to keep before setting up Time Machine.

  • Assuming optional encryption is already enabled

    Samsung describes password protection for the T7 as a feature you can set up. Its availability doesn’t mean it has already been configured.

    Decide whether you need protection, set it up and store the password somewhere that will let you restore your files.

Brands to compare

These brands and product ranges offer useful options to compare for size, connections and backup use. Always check the exact variant; a brand being mentioned doesn’t necessarily mean it’s available.

Kingston

The XS1000 is a compact external SSD available in 1 TB and 2 TB versions. Kingston says it’s suitable for document backups.

  • Kingston lists dimensions of 69,54 × 32,58 × 13,5 mm and a five-year limited warranty for the XS1000.
  • Check the cable setup: USB-C on the drive, with a USB-A cable for the computer and an adapter. The quoted speed is a manufacturer’s maximum, not a measure of spreadsheet backup performance.

Samsung

The T7 is a compact SSD with USB-C and USB-A cable options and configurable device security.

  • For the 1 TB T7 sold in the Netherlands, Samsung lists both cable types and configurable password protection with AES 256-bit encryption.
  • You’ll need to set up the security feature. Speed and drop-resistance claims are product specifications, not a guarantee against data loss.

Crucial

Crucial says the X9 works with Windows File History and Apple Time Machine.

  • Crucial lists a size of 65 × 50 mm and a quoted read speed of up to 1.050 MB/s. The manufacturer notes that performance varies depending on the computer.
  • According to Crucial, the X9 comes formatted as exFAT. You may need to reformat it for Time Machine.

SanDisk

The Portable SSD (V3) is an external SSD with USB 3.2 Gen 2. Check the exact generation when comparing models.

  • For the V3, SanDisk quotes a read speed of up to 1.000 MB/s and a three-year limited warranty.
  • These are manufacturer specifications for this generation. They don’t show a specific benefit for small spreadsheet backups and don’t automatically apply to older Portable SSD versions.

External SSDs at Joybuy

This selection includes external SSDs for spreadsheet backups on a small desk. Focus on the storage space you need, your computer’s connection and any data protection features.

SanDisk Extreme Pro Portable SSD 1TB

SanDisk Extreme Pro Portable SSD 1TB

An option if you want to keep an external copy of your documents. Check that your computer supports the connection.

The quoted speed of up to 2.000 MB/s requires a compatible USB 3.2 Gen 2x2 host. The listed write speed is lower. You may need to download software to use password protection.

View at Joybuy
WD My Passport SSD 1 TB

WD My Passport SSD 1 TB

Suitable if you want to store files externally and are checking whether optional encryption suits the way you use the drive.

The product information lists USB-C and hardware encryption with password protection. You’ll need to install WD Security software to use this feature.

View at Joybuy
Portable external SSD 1 TB, 1.000 MB/s

Portable external SSD 1 TB, 1.000 MB/s

An option for keeping an external copy of your documents when desk space is limited. Check that the built-in cable works with your computer.

The product information lists USB-C and USB 3.2 Gen 2. You may need to format it before first use with Windows.

View at Joybuy
Samsung Portable SSD T7 2 TB, blue

Samsung Portable SSD T7 2 TB, blue

Suitable if you want external storage and the option of using both USB-C-to-C and USB-C-to-A cables.

The product information lists USB 3.2 Gen 2 (3.1 Gen 2), AES 256-bit encryption and included cables for both connections. Samsung Magician software is required to encrypt data.

View at Joybuy
Samsung Portable SSD T7 1 TB, blue

Samsung Portable SSD T7 1 TB, blue

Suitable if you want to keep an external copy and have the choice of USB-C-to-C and USB-C-to-A cables.

The product information lists USB 3.2 Gen 2 (3.1 Gen 2), AES 256-bit encryption and cables for both connections. Samsung Magician software is required to encrypt data.

View at Joybuy

Frequently asked questions

How can I keep earlier versions of my spreadsheets in Windows?

Set up File History with an external drive and check that the folder containing your spreadsheets is included. According to Microsoft Support, you can then restore earlier versions of backed-up files.

Can I use a new SSD with Time Machine straight away?

Not always without setting it up first. Apple recommends APFS or APFS Encrypted; Time Machine may ask to erase and reformat a drive that uses a different format. Move any files you want to keep before doing this.

How much space do I need for a Mac backup?

For Time Machine, Apple ideally recommends a backup drive with at least twice the storage capacity of your Mac. This advice applies to that backup method, not as a general requirement for copying spreadsheet folders separately.

Do I have to encrypt my spreadsheets?

There’s no general rule that applies to every spreadsheet. The Dutch Data Protection Authority says organisations must protect personal data appropriately; the right measures depend on the risks. Encryption is one possible measure, not a standard SSD product specification.