Who is this guide for?

Shared spreadsheet administrator

Want to restore an older version after a file has been deleted or overwritten? Choose a backup method with version history, and test the recovery process before relying on it.

Administrator of restricted files

If you store spreadsheets where unauthorised access is a risk, consider who can take the drive away or unlock it. For personal data, security measures must be appropriate to the risks involved in processing it; the Dutch Data Protection Authority recommends carrying out a risk assessment.

Team working from different locations

Do you take the backup drive with you or connect it to different computers? Check the available ports, cables and backup software on each computer.

What should you look for when buying?

Portable external HDD

A good fit if: you’ll mainly connect the drive at a fixed workstation and storage space matters.

Bear in mind: overwriting a file won’t automatically save earlier versions. Check the backup software and plan to keep a copy in another location too.

Portable external SSD

A good fit if: you regularly take the drive between computers or locations.

Bear in mind: the stated maximum speeds aren’t a measure of your spreadsheet backups. An SSD is no substitute for version history, a recovery test or a second copy.

What to consider What to look for Who is this important for?
Restoring old versions Check whether the backup software keeps the version history you need, and plan a recovery test. If a shared spreadsheet is accidentally overwritten, I want to be able to restore an earlier version. Around 40% of consumers say version recovery is their main reason for buying.
Restricting access Check what security settings are available and who can take the drive away or unlock it. If you store files where unauthorised access is a risk, you’ll want to control access to the copy. Around 30% of consumers prioritise restricted access.
Capacity and a second copy Work out how much space you need based on your files and retention period; plan to keep a copy in another location too. If you want to keep several versions and avoid relying on a single location, you’ll need space for your backup plan and a separate copy. Around 20% of consumers prioritise this.
Connecting to multiple computers Check the USB ports, cables and backup software on each computer. If you work in different locations, you’ll want to be able to connect and use the drive with the computers you work on. Around 10% of consumers name compatibility with different workstations as their main priority.

Common buying mistakes

  • Repeatedly overwriting the previous copy with the latest spreadsheet

    If a file is accidentally overwritten, you may no longer have the earlier version that you could still use.

    Choose a backup method with suitable version history, and try restoring a file in advance.

  • Keeping your only external copy in the same studio

    If you lose access to that location, the backup stored there may also become inaccessible. The Digital Trust Center advises against relying on a single storage location.

    As well as a local drive, include a separately stored copy in your backup plan and decide who can access it.

  • Choosing an SSD based only on its maximum MB/s

    A stated maximum speed doesn’t tell you how quickly backups will run on your studio’s computers and spreadsheets.

    First check the ports, cables, software and recovery process. Then consider whether portability is important for the way you work.

  • Assuming consumer returns rights apply to a business order

    According to Ondernemersplein, statutory consumer cancellation periods and consumer guarantees don’t apply in the same way to business-to-business purchases.

    Before placing your order, check who is legally making the purchase and confirm the applicable warranty and returns terms.

Relevant brands for reference

Samsung

The portable SSD T7 is an option if you want to take a backup between workstations. T7 Shield is a separate product range, not the same model.

  • Samsung says the grey 1 TB T7 sold in the Netherlands (MU-PC1T0T/WW) comes with USB-C-to-C and USB-C-to-A cables.
  • Samsung lists configurable password protection with AES 256-bit encryption; you’ll need to enable this feature.
  • The manufacturer’s stated maximum transfer speeds aren’t a measure of spreadsheet backup performance in your studio.

Toshiba

Canvio Basics is a range of portable HDDs for local copies.

  • Toshiba says the 2 TB Canvio Basics, part number HDTB520EK3AA, is powered via USB.
  • According to Toshiba, this model is pre-formatted as NTFS for Windows. Check the file system if you want to use the drive with macOS.

Seagate

Expansion Portable is a range of portable HDDs for a USB-powered backup setup.

  • Seagate lists Expansion Portable STKM2000400 as a 2 TB model.
  • A drive, or copying files to it, won’t by itself create automatic backups with version history.

Kingston

The XS1000 is a compact SSD range for use between computers.

  • Kingston lists 1 TB and 2 TB models, USB 3.2 Gen 2, a USB-A cable and a USB-C adapter.
  • Kingston states that it comes with a five-year limited warranty.
  • The stated speed of up to 1.050 MB/s isn’t a measured backup speed for your studio.

Crucial

The X9 is a range of portable SSDs for which Crucial lists support for backup software.

  • Crucial lists support for Windows File History and Apple Time Machine, among other software.
  • That support is no substitute for setting up your backup software appropriately and testing recovery.

Joybuy products for local backups

These portable SSDs and HDDs are options for keeping a local spreadsheet copy. Check the connection on each computer, and set up version history and recovery separately.

SanDisk Portable SSD 1TB

SanDisk Portable SSD 1TB

A 1 TB portable SSD for a local copy you want to take between workstations.

The product description lists read speeds of up to 800 MB/s and drop protection from heights of up to 2 metres; these aren’t measurements specific to your studio.

View at Joybuy
My Passport for Mac 2TB Blue portable hard drive

My Passport for Mac 2TB Blue

A 2 TB portable HDD for a local copy; the description says it works with Time Machine.

The product description lists pre-formatting for Mac, password protection, hardware encryption, a USB-A cable and a USB-C adapter. Check that these suit your studio’s computers and software.

View at Joybuy
WD Elements Portable 2TB USB-C Graphite

WD Elements Portable 2TB USB-C Graphite

A 2 TB portable HDD for a local copy, with USB-C connectivity as stated in the product name.

The product description mentions plug-and-play use. Check the connection and backup software on the computers you want to use the drive with.

View at Joybuy
My Passport 2TB Red portable hard drive

My Passport 2TB Red

A 2 TB portable HDD for local copies; the product description mentions scheduled, configurable backups.

The description lists password protection, 256-bit AES hardware encryption, USB bus power and a USB-A-to-Micro-B cable. Set up security and a backup schedule to suit your studio’s needs.

View at Joybuy

Frequently asked questions

Does a synchronised spreadsheet folder count as a backup?

Not necessarily: changes and deletions may also be synchronised. Use a separate backup feature that lets you actually restore the earlier versions you need.

How often should the studio make and check copies?

Set the frequency according to how much work you could afford to lose if something went wrong. The Digital Trust Center gives daily or weekly backups as examples and recommends periodically restoring a backup to check that it works. These are recommendations, not fixed legal deadlines.

Can any external drive be used between Windows and Mac without preparation?

No. Check the file system and backup software. Toshiba says Canvio Basics drives are formatted as NTFS for Windows and need to be reformatted for macOS. Back up any existing data before reformatting a drive.

What warranty or cancellation period applies when buying for the studio?

That depends on who is legally making the purchase. According to Ondernemersplein, statutory consumer guarantees don’t apply to business-to-business sales, so make sure the business warranty terms are clear. The statutory 14-day cancellation period for the specified consumer distance purchases doesn’t apply to a business purchase made by a business owner.

Is encryption a legal requirement for every spreadsheet backup?

There isn’t one fixed encryption specification for every drive. If your studio processes personal data, the GDPR requires appropriate security based on a risk assessment, according to the Dutch Data Protection Authority. Encryption and restricted access may be suitable measures; the right choice depends on the risks involved in processing the data.