Who is this choice relevant to?

Shared work files manager

You store spreadsheets on a computer used by several people and need to decide who can open the backup, particularly if the files contain personal data.

Creator of restorable spreadsheet backups

You want to be able to restore an earlier version after an accidental change or deletion, rather than simply copying files to a drive.

User of different workstations

You connect the drive to different computers, so you want to make sure the connection, cable and backup software you choose all work together.

What should you look for?

External HDD

A good fit if: the drive usually stays at one workstation and you need space for successive backups.

Bear in mind: in July 2022, Consumentenbond described an HDD as more susceptible to shocks than an SSD.

External SSD

A good fit if: you often move the drive between workstations or also transfer larger files.

Bear in mind: claimed top speeds are not a measurement of your spreadsheet backup, and an SSD is no substitute for a backup and recovery process that you have set up.

What to consider What to look for Who is this important for?
Access to the backup Decide who can access the drive and its files; check that security is enabled. I don’t want everyone who uses the shared computer to be able to view my spreadsheets. Around 31% of consumers give restricted access their highest priority.
Restoring earlier versions Check which folders and versions the software saves, and test whether you can restore a file. If a spreadsheet is changed accidentally, I want to be able to retrieve a usable earlier version. Around 31% of consumers put version recovery first.
Connection and routine Make sure the USB port and cable suit the workstation, and check that the backup method works with the operating system. I want to be able to connect the drive at my workstation and back up my files as part of a manageable routine. Around 25% of consumers prioritise connection and regular use.
Storage space and retention period Work out the total size of the files to be backed up and decide how many earlier copies you want to keep. I want enough space for my files and the retention period I need, rather than considering the spreadsheet files alone. Around 13% of consumers make capacity their first priority.

On Windows, File History can restore earlier versions of files included in the backup. Apple describes Time Machine as a way to back up files automatically using a compatible external storage device. For both systems, check your chosen destination, settings and connection. The National Cyber Security Centre recommends carrying out a restore to check that a backup can be used.

Common buying mistakes

  • Confusing a file copy with a restorable version history

    A copy of the current state may not help if a spreadsheet was changed incorrectly some time ago.

    Decide which folders and versions your backup method saves, then test the restore process with a file you can open.

    If the right earlier version is missing, restoring your work may take extra time and effort.

  • Assuming a drive is automatically private on a shared computer

    Anyone with access to the connected drive may be able to view spreadsheets that aren’t meant for them. Organisations processing personal data need to put appropriate security measures in place.

    Decide who needs access and check that any password or encryption features are actually enabled.

  • Choosing an SSD based only on its claimed top speed

    A manufacturer’s speed specification doesn’t tell you how long your spreadsheet backup will take on the workstation you use.

    First check the connection, how often you move the drive and how much data you copy. Then compare the different options.

  • Keeping an extra drive as your only backup

    Storage media and the location of a backup can fail too.

    For important work files, consider keeping multiple copies on different media or in different locations, in line with your own backup policy.

    A second copy or another storage location may require extra storage space.

Brands to consider

Seagate

The Expansion range includes portable HDDs for external file storage. Seagate lists the STKM2000400 variant, among others, with 2 TB of storage.

  • Seagate lists USB 3.0 and a USB-A cable included with the Expansion range.
  • Dragging files onto the drive isn’t the same as setting up version history or access controls.

Samsung

The Portable SSD T7 is a compact SSD option; the T7 Shield is a separate range with a more robustly designed casing.

  • Samsung lists a USB-C-to-C cable and a USB-C-to-A cable for the T7 MU-PC1T0H/WW.
  • Samsung’s claimed top speeds for the T7 Shield MU-PE1T0R/EU are not a measurement of a spreadsheet backup on your workstation.

Western Digital

The My Passport range may be worth considering if you’re looking into password protection for a portable drive.

  • Western Digital describes 256-bit AES hardware encryption for the My Passport models discussed, with password setup through supported software.
  • Check the exact variant and enable security yourself; an unprotected or unlocked drive won’t manage shared access automatically.

Kingston

Kingston offers portable SSD ranges, including models with both USB-A and USB-C, as well as a separate IronKey range.

  • Kingston lists both connections for the Dual Portable SSD.
  • Security features Kingston lists for IronKey do not automatically apply to the XS1000 or other Kingston SSDs.

External drives on Joybuy

These Joybuy products include portable external HDDs and SSDs for spreadsheet backups. Compare them based on connection, storage space, portability and the security or backup features you need.

SanDisk Portable SSD 1TB

SanDisk Portable SSD 1TB

A portable SSD option if you’re looking for an external place to store spreadsheet copies and want to take the drive between workstations.

Storage capacity: 1 TB.

Joybuy
WD Elements Portable 5TB USB-C, Graphite Black

WD Elements Portable 5TB USB-C, Graphite Black

A portable HDD option if you want to store files externally and use USB-C with your workstation.

Storage capacity: 5 TB. Connection: USB-C.

Joybuy
WD My Passport for Mac 2TB Blue

WD My Passport for Mac 2TB Blue

This portable HDD is designed as a Mac backup destination; check that its settings suit your Mac and backup routine.

Storage capacity: 2 TB. The title states that it is Time Machine-ready. The product description mentions a USB-A cable with a USB-C adapter and password protection via WD Discovery; enable this security feature yourself.

Joybuy
WD My Passport 6TB White

WD My Passport 6TB White

A portable HDD option to compare if you need space for files and several saved versions.

Storage capacity: 6 TB. The product description lists USB 3.0, 256-bit AES hardware encryption and password protection; enable the security feature using the supplied software.

Joybuy
WD My Passport 2TB Blue

WD My Passport 2TB Blue

A portable HDD option for spreadsheet copies if 2 TB suits your files and chosen retention period.

Storage capacity: 2 TB. The product description lists USB 3.0, 256-bit AES hardware encryption and password protection via WD Discovery; enable the security feature yourself.

Joybuy

Frequently asked questions

Is connecting an external drive enough to keep earlier spreadsheet versions?

No. Set up a backup of the right folders and check that your chosen method saves earlier versions. Microsoft says File History can restore earlier versions of files included in the backup; then test whether you can restore and open a file.

Can I use the same external drive for Windows and Time Machine without any further checks?

First check the computers and the backup method you plan to use. Apple explains which external destinations Time Machine can use, but a general compatibility statement doesn’t prove that the current format and settings are suitable for both backup tasks.

What if the external drive isn’t connected when Windows needs to make a backup?

Microsoft says the external drive needs to be connected. Reconnect it and check that the next scheduled backup takes place, or start one manually by following Microsoft’s instructions.

What guarantee applies when buying for personal use in the Netherlands?

According to ACM ConsuWijzer, as a consumer you have a statutory guarantee in addition to any manufacturer’s or seller’s guarantee if, under normal use, the product doesn’t meet reasonable expectations; the seller is your point of contact. This guidance doesn’t automatically establish which terms apply to a business purchase or to recovering lost files.

Do spreadsheet backups on a shared workstation need to be protected under the GDPR?

If an organisation processes personal data, it must protect that data appropriately. Whether this applies to your spreadsheets depends on their contents and how they’re used: information about an identifiable person is personal data, while the Dutch Data Protection Authority says the GDPR doesn’t apply to processing carried out solely for personal or household purposes. The Dutch Data Protection Authority lists access controls, backups and encryption as possible measures, but doesn’t require every buyer to encrypt every drive.