Who should consider this?

Manager of linked spreadsheets

You want to be able to restore a spreadsheet together with the local files it depends on. Microsoft Support explains how links between workbooks and other files should be maintained, so check that the related source files are included in your backup.

User of multiple computers

You might create the copy on one device and open it later on another. In that case, the drive’s connectors need to fit the ports on the devices you’ll use to copy and restore your files.

Manager of sensitive records

You store spreadsheets containing personal data or other sensitive information, so you need to consider both unauthorised access and whether the files can be restored. The Dutch Data Protection Authority cites losing a USB flash drive containing unencrypted personal data as an example of a data breach.

What should you look for in a USB flash drive?

First, identify the complete set of files. Then check the connections on both devices and consider what protection and copying time suit the way you use them.

What to consider What to look for Which consumers it suits
Complete set of files Include spreadsheets, linked source folders and any versions you want to keep in your size estimate. Microsoft Support recommends maintaining workbook links; after copying, test that the restored files work together properly. If I want to be able to restore a spreadsheet in full later, my copy needs to include the required source files too. Around 36% of consumers would consider recoverability their main purchasing concern.
Connector Check the ports on both the device you’re copying from and the one you’ll use to restore your files. A drive with both USB-A and USB-C can be connected to devices with either compatible port. If I need my copy to work on devices with different USB connections, I don’t want to rely on an adapter. Around 29% of consumers would prioritise compatibility with their devices.
File protection Consider what information is in your spreadsheets and source files, and what access protection is appropriate. The Dutch Data Protection Authority links appropriate security for organisations to the risks involved in processing data. If I store sensitive files, I want to take the risks of loss and unauthorised access into account. Around 21% of consumers would consider confidentiality their main purchasing concern.
Write speed Check the advertised write and read speeds for the exact model. Manufacturer figures aren’t a measure of your backup speed: the port you use and the files you’re copying also matter. If I often copy large source files, I want to know roughly how long writing them might take. Around 14% of consumers would prioritise copying time.

Common backup mistakes

  • Copying only the spreadsheet file

    A workbook may link to other workbooks or external sources. A standalone copy of the spreadsheet may not be enough to restore or update the data you need.

    Identify the linked sources, copy the required files as well and test a restoration. Finding and relinking missing source files can take extra time.

  • Assuming maximum read speed is backup speed

    Backing up to a drive involves writing data. Samsung describes the advertised speed of the BAR Plus as its read speed; Verbatim lists read and write speeds separately for the Dual QuickStick.

    Compare the advertised write speed for the exact model, and treat it as a manufacturer’s figure rather than a guaranteed speed on your computer.

  • Keeping a USB flash drive as your only copy

    An external drive can become damaged too. If you have only one copy, damage could make it difficult to access your backup.

    Keep a separate, appropriately protected backup as well, and test periodically that you can restore your files.

Brands to consider

Kingston

Kingston offers USB-A drives for everyday document storage, as well as a separate range with hardware encryption.

  • Kingston specifies USB-A and USB 3.2 Gen 1 for the DataTraveler Exodia.
  • The Exodia does not have hardware encryption. Kingston lists hardware encryption and password protection for the IronKey Locker+ 50 G2, so bear in mind that you’ll need to manage access. Kingston’s limited manufacturer’s warranty does not cover stored data.

SanDisk

The Ultra Dual Drive Luxe is designed for use with USB-A and USB-C. The Extreme PRO Dual Drive is a separate range for which SanDisk advertises maximum read and write speeds.

  • SanDisk says the Ultra Dual Drive Luxe has a metal casing and two connectors.
  • The advertised maximum speeds for the Extreme PRO don’t show how quickly it will back up a spreadsheet on your devices.

Samsung

The BAR Plus is a USB-A option for devices with a compatible port.

  • Samsung Netherlands lists a maximum sequential read speed of 400 MB/s for the 128 GB BAR Plus MUF-128BE3/APC under the test conditions described.
  • That read speed doesn’t predict backup write speed. This model does not have a USB-C connector.

Verbatim

The 128GB version of the Dual QuickStick combines USB-A and USB-C. It’s aimed at users for whom advertised write and read speeds are relevant.

  • Verbatim lists maximum speeds of 510 MB/s for reading and 460 MB/s for writing for this model.
  • According to Verbatim, the included Nero Backup software only works with Windows. The advertised speeds don’t show how quickly your files will be copied on a specific computer.

USB flash drives at Joybuy

These USB flash drive options cover backups using USB-A devices, devices with USB-A and USB-C, and a range of storage capacity requirements.

Kingston DataTraveler Exodia 128 GB USB flash drive

Kingston DataTraveler Exodia 128 GB USB 3.2 Gen 1 Type-A

A good fit for a backup that stays within 128 GB and is created and restored on devices with a USB-A port.

The product name specifies USB 3.2 Gen 1 Type-A and backwards compatibility with USB 2.0.

Joybuy
SanDisk Ultra Flair 64 GB USB 3.0 flash drive

SanDisk Ultra Flair 64 GB USB 3.0

An option to consider if your complete backup fits within 64 GB and your devices have a USB-A port.

The product name specifies 64 GB and USB 3.0. The product description mentions software-based 128-bit AES file encryption; check that the software suits your needs.

Joybuy
SanDisk Ultra Dual Drive Go 512 GB USB-C and USB-A

SanDisk Ultra Dual Drive Go 512 GB USB-C and USB-A

An option if your backup fits within 512 GB and you want to use the same drive with devices that have different compatible USB ports.

The product description lists USB-C and a traditional USB connector, plus a maximum read speed of 150 MB/s. This isn’t a measured backup speed.

Joybuy
Kingston DataTraveler SE9 G3 64 GB USB 3.2 Gen 1

Kingston DataTraveler SE9 G3 64 GB USB 3.2 Gen 1

A good fit for a backup that stays within 64 GB and is used with a USB-A host device.

The product description lists maximum speeds of 220 MB/s for reading and 100 MB/s for writing for this model. These are advertised maximums, not measured backup speeds.

Joybuy
Kingston DataTraveler SE9 G3 512 GB USB 3.2 Gen 1

Kingston DataTraveler SE9 G3 512 GB USB 3.2 Gen 1

An option to consider if your complete set of files fits within 512 GB and you’re copying to a USB-A host device.

The product description lists maximum speeds of 220 MB/s for reading and 100 MB/s for writing for this model. These are advertised maximums, not measured backup speeds.

Joybuy

Frequently asked questions

Should you copy local source files as well as your spreadsheet?

Yes, if the workbook depends on them. Microsoft Support explains links to other workbooks and external data sources. Check which files your workbook uses, copy them too and test the restored set.

How can you check that your backup is usable?

Periodically restore a copy to a secure test location and open the relevant files. Also check that linked workbooks or external data sources still work. The Digital Trust Center recommends testing your restoration process regularly.

Is one USB flash drive the only backup you need?

Don’t rely on a single drive for important files, as a USB flash drive can become damaged too. VeiligInternetten lists external storage such as a USB flash drive as a backup option; the Digital Trust Center recommends testing periodically that a backup can be restored.

What does the warranty cover if the drive becomes faulty?

For a consumer purchase in the Netherlands, a product must be fit for purpose. ACM ConsuWijzer explains that if a product develops a fault during normal use, the seller must offer an appropriate solution. That’s different from recovering stored files: Kingston excludes stored data from its limited manufacturer’s warranty.

Does the GDPR require every backup to use a hardware-encrypted USB flash drive?

No. The GDPR doesn’t require one specific type of product for every backup. For organisations processing personal data, the Dutch Data Protection Authority says appropriate security depends on the risks involved in that processing. The Authority cites losing a USB flash drive containing unencrypted personal data as an example of a data breach. So consider what information you store and which measures are appropriate.