Who is local backup suitable for?

Spreadsheets that change frequently

If you want to restore earlier versions after accidentally deleting or overwriting a file, choose a local backup feature that actually covers the folders and versions you need. Microsoft explains how File History stores earlier file versions, while Apple describes backups using Time Machine.

Confidential work documents

For personal or other sensitive information, access protection and how the data is processed matter just as much as the ability to restore it. The German Federal Office for Information Security describes software- and hardware-based encryption. The right safeguards depend on the risks involved.

Growing local archives

If you want to keep other folders or several backup versions as well as spreadsheets, consider your total storage needs and the connection available on your computer. CHIP’s test of external 2.5-inch HDDs describes them as offering plenty of storage at relatively low cost. Portability and storage needs can help you decide between an HDD and an SSD.

What should you look for when buying?

Portable HDD

A good fit if: You want to store lots of files or several backup versions, and the drive will mostly stay in one place.

The trade-off: The CHIP test referenced describes 2.5-inch HDDs as offering plenty of storage at relatively low cost. According to the comparison, they’re not the right choice if you’re looking for the fastest transfer speeds.

Portable SSD

A good fit if: You’ll be taking the drive with you often or regularly copying large amounts of data.

The trade-off: The comparison referenced finds SSDs faster, but they tend to cost more for the same amount of storage. For small spreadsheet backups, top speeds may not be a deciding factor (CHIP; PC-WELT).

What you need What to check when buying Who it matters to most
Earlier spreadsheet versions Check whether the local backup feature covers the folders and versions you need, and allow enough space to keep them. If I want to restore older versions of my spreadsheets, I make sure the feature saves versions and lets me restore them. Around 36% of consumers put version recovery first.
A usable offline copy Check whether you can disconnect the drive after backing up, and whether it has enough space for future backups. If you want to keep a copy that’s disconnected from your computer, unplug the drive after backing up and test restoring a file. Around 29% of consumers prioritise protecting this offline copy.
Confidential spreadsheets Check encryption and operating system compatibility, and keep your recovery password somewhere safe. If my spreadsheets contain sensitive information, I need suitable access protection and a secure way to find the key when I need it. Around 21% of consumers put confidentiality first.
Capacity and cost Consider the size of all the folders and versions you’ve selected, and check that the connection and file system work with your computer. If I want to back up a larger archive, I compare the storage I need with how portable the drive is and its features. Around 14% of consumers prioritise storage needs and cost.

Avoid common mistakes

  • Confusing Windows Backup with a backup on a local drive

    Microsoft explains that the Windows Backup app syncs selected folders with OneDrive. This is not the same as a backup that stays exclusively on an external drive.

    Before setting it up, check which Windows feature you’re using and where it stores your files.

  • Leaving your only backup connected all the time

    If the backup drive stays connected to your computer, it could also be affected if something happens to the device. A disconnected copy also won’t protect you from changes made since your last backup.

    Connect the drive to back up your files, test that you can restore them, then disconnect it again. Keep another copy in a separate location.

  • Assuming an SSD’s advertised top speed applies to every backup

    Crucial quotes speeds of up to 1.050 MB/s for the X9 Pro under its own test conditions; your connection and computer can affect the results. For small spreadsheet collections, you may not notice this top speed in everyday use.

    First work out how much data you have, what connection your computer supports and how you’ll back it up. Then decide whether the quoted speed matters to you.

  • Only checking the format or connection after buying

    The Canvio Basics variants mentioned need to be reformatted for macOS. For the 2-TB HDTB520EK3AA variant, Toshiba specifies a Type-A-to-Micro-B cable; the manufacturer says an adapter is required separately to use the Crucial X9 Pro with older USB-A computers.

    Check the file system, connection and what’s included with the specific variant against your computer before buying.

    Depending on your computer, you may need to spend extra time setting it up or buy an adapter.

Key brands to consider

Toshiba

Canvio Basics is a range of portable HDDs for local files and larger backups.

  • For the variants tested, Toshiba specifies USB connectivity and a file system pre-formatted as NTFS for Windows.
  • Toshiba says the drive needs to be reformatted for macOS. For the HDTB520EK3AA variant, the manufacturer specifies a Type-A-to-Micro-B cable; check that the connection works with your computer. These details are no guarantee against drive failure.

Seagate

Expansion Portable includes portable HDD variants, such as the 2-TB STKM2000400 model listed in the data sheet.

  • Seagate describes the drive as USB-powered and says a USB 3.0 cable is included.
  • Seagate’s 2021 data sheet specifies a two-year limited warranty for EMEA and notes that Rescue services are not available in every country. Check the terms for the specific variant and market where you’re buying it; a recovery service is no substitute for keeping an additional backup copy.

Crucial

The X9 Pro is a range of portable SSDs for people who value easy portability and fast copying.

  • Crucial quotes speeds of up to 1.050 MB/s for the X9 Pro under its own test conditions, as well as IP55 protection and a USB-C cable.
  • The manufacturer says an adapter is required separately for older USB-A computers. In its test of the X9 Pro range, PC-WELT praised its compact design and noted the lack of a USB-A adapter as a drawback. These details do not automatically apply to other Crucial ranges.

Samsung

The Portable SSD T7 Shield is an SSD option for people who carry their drive around frequently.

  • PC-WELT gave positive feedback on the everyday performance and protective design of the 4-TB model it tested.
  • The PC-WELT test dated 10 June 2023 noted a high price and slower performance when writing small 4K files. The results apply to the 4-TB variant tested, not every capacity.

Joybuy products for local backups

The portable HDDs and SSDs below can be used as local storage for copies of your files and spreadsheets. Compare the capacity and connection with the details for each variant, and make sure they suit your backup routine.

WD Elements Portable 5TB USB-C

WD Elements Portable 5TB USB-C

This portable HDD is an option if you want to store other files locally as well as spreadsheets.

5 TB storage; USB-C.

Joybuy
WD Elements Portable 2TB, USB-C, USB 3.2 Gen 1, 2.5-inch, exFAT

WD Elements Portable 2TB, USB-C

This portable HDD could be a good choice for storing spreadsheets and other files locally.

2 TB; USB-C; USB 3.2 Gen 1; 2.5-inch; exFAT.

Joybuy
Crucial X10 Portable SSD 1TB

Crucial X10 Portable SSD 1TB

This portable SSD is an option if you want a drive for local files that you can take with you often.

1 TB storage.

Joybuy
WD My Passport External Hard Drive 2 TB

WD My Passport External Hard Drive 2 TB

This portable HDD lists password protection and automatic backup scheduling among its features for local files.

2 TB; USB 3.0; the product description says password protection and backup scheduling need to be set up using downloadable software.

Joybuy
Samsung Portable SSD T7 2TB, Titanium Grey

Samsung Portable SSD T7 2TB, Titanium Grey

This portable SSD gives you a way to keep spreadsheets and other local files on a drive you can take with you.

2 TB; USB Type-C 3.2 Gen 2.

Joybuy

Frequently asked questions

How can I back up earlier versions of my spreadsheets in Windows without the cloud?

File History can save earlier versions to an external drive, as Microsoft Support explains. Check that your spreadsheet folder is included, then test restoring an older file. According to Microsoft, the separate Windows Backup app syncs selected folders with OneDrive, so it isn’t a substitute for backing up folders exclusively to a local drive.

Can I back up my Mac without the cloud, and how much storage do I need?

Yes. Apple Support describes using Time Machine with a connected external storage device. For a full Mac backup, Apple recommends a drive with at least twice the capacity of your Mac. This recommendation is for Time Machine and isn’t a general minimum for individual spreadsheets. Setting it up may erase the destination volume.

Do I need a particular encrypted SSD for business spreadsheets?

No. The European Data Protection Board’s guidelines do not require a particular SSD model in every case. For controllers and processors, technical and organisational measures need to be appropriate to the risks. The right safeguards depend on the data and how it is processed. The German Federal Office for Information Security describes software- and hardware-based encryption.

What should I check about warranties and data recovery services before buying?

Check the terms for the specific variant and market where you’re buying it. Seagate’s 2021 data sheet specifies a two-year limited warranty for Expansion Portable in EMEA and notes that the Rescue service is not available in every country. This does not guarantee that recovery will be successful or that every purchase comes with the same service terms.