Who should consider this choice?

Spreadsheet backup administrator

You make regular copies and want to be able to restore an earlier version. Safe Internetting and the National Cyber Security Centre highlight the importance of backups and testing whether files can be restored.

Handler of confidential data

You store spreadsheets that may contain personal data and need to decide who can access a backup on a shared workstation. The Dutch Data Protection Authority stresses that organisations must protect personal data appropriately.

User of multiple computers

You want to be able to restore files on different devices, so you check the available USB ports and system compatibility.

What should you look for?

Basic USB-A flash drive

Suitable when: the workstation has USB-A and you can arrange the chosen security measures separately.

Bear in mind: the basic models mentioned are not specified as having built-in encryption.

USB-A and USB-C flash drive

Suitable when: you want to use the copy on devices with both types of connection.

Bear in mind: two connection types don’t provide access controls or restore testing. Also check that the model and file system work on both devices.

Hardware-encrypted flash drive

Suitable when: your risk assessment or organisation’s policy requires confidential copies to be protected, and the workstation supports the model.

Bear in mind: check the port, system requirements, and how access codes and recovery are managed. Encryption can’t restore a missing or failed backup.

What to consider What to look for Who should consider this?
Restorability Decide how many versions to keep and test whether files open and can be restored. I want to be able to restore a recent spreadsheet after a problem; around 36% of consumers put restorability first.
Confidentiality Assess whether encryption is needed and who will manage access codes and recovery. If my spreadsheet contains confidential information, I want to restrict unauthorised access; around 29% of consumers put confidentiality first.
Connection Check the USB ports and the flash drive’s system requirements. I want to be able to use the copy on both the workstation and the device I’ll use to restore it; around 21% of consumers put the connection first.
Storage and copying time Check the size of your files and compare write specifications relevant to the exact model. If I keep multiple versions or have little time to copy files, I want to know how much storage and writing time I’ll need; around 14% of consumers put capacity or copying time first.

Common pitfalls

  • Assuming one flash drive is a complete backup strategy

    A single copy could be lost or prove unusable when you need it.

    Plan a separate copy and test whether you can restore and open a file. For business data, the National Cyber Security Centre recommends keeping multiple versions on different media, with a copy at another location.

  • Assuming a USB rating guarantees copying speed

    The USB 3.2 Gen 1 rating describes the interface’s signalling speed. A stated maximum read speed isn’t the same as the time it will take to write your spreadsheets.

    If copying time matters, compare write specifications or relevant test results for the exact model.

  • Buying a secure flash drive without a plan for unlocking and recovery

    Models vary in their connections and access methods. Kingston also states that the IronKey Locker+ 50 G2 requires two consecutive unused drive letters.

    Check the workstation configuration before buying, and agree who will manage access codes and recovery.

  • Leaving the flash drive connected to the shared computer

    A backup kept at the same workstation depends on that location and may remain accessible to others.

    Safely eject the flash drive and store it in line with your agreed access and backup policy.

Brands to compare

Kingston

These examples from Kingston include both basic USB-A flash drives and models with security features. Specifications vary by model.

  • Kingston says the DataTraveler Exodia M has a sliding cap and a five-year warranty.
  • The stated Exodia M specifications don’t confirm built-in encryption. Kingston says the IronKey Locker+ 50 G2 offers hardware encryption and password features, but requires two consecutive unused drive letters.

SanDisk

The Ultra Dual Drive Luxe is designed for use with USB-A and USB-C devices.

  • SanDisk specifies both connection types for this model.
  • The connections alone don’t tell you anything about security or the actual write speed on your workstation.

Verbatim

The Keypad Secure USB-C Drive is an option if you want to enter the access code on the flash drive itself.

  • Verbatim says the 128GB model has hardware encryption and a built-in keypad.
  • This model requires USB-C. Also check how your organisation manages access codes and recovery.

Samsung

The BAR Plus MUF-128BE4/APC is a USB-A model whose specifications you can compare with those of other basic flash drives.

  • For the 128GB model, Samsung lists sequential read speeds of up to 400 MB/s under the stated test conditions.
  • The read speed isn’t a measured write speed for spreadsheet backups and doesn’t confirm encryption.

Transcend

The JetFlash 790 is a USB-A model with a retractable connector.

  • Transcend lists, among other options, a 128GB model with a five-year limited warranty.
  • Transcend says speeds may vary depending on hardware, software, usage and capacity. The model mentioned isn’t specified as an encrypted flash drive.

USB flash drives on Joybuy

This selection includes USB-A flash drives and models with multiple connection types for storing and transferring spreadsheet copies. Separately, check that your chosen backup process, security measures and recovery method are suitable for your workstation.

Kingston DataTraveler Exodia USB flash drive, 64 GB

Kingston DataTraveler Exodia 64 GB

A USB-A option if your workstation has this connection.

64 GB of storage; USB-A and USB 3.2 Gen 1 are listed in the product information.

View on Joybuy
Kingston DataTraveler Exodia USB flash drive, 128 GB, Type-A

Kingston DataTraveler Exodia 128 GB

A USB-A option for storing or transferring files on a device with this port.

128 GB; USB 3.2 Gen 1 Type-A is listed in the product name.

View on Joybuy
32 GB USB flash drive with USB 3.0, Lightning, USB-C and Micro-USB

USB flash drive with four connection types, 32 GB

An option for transferring files between devices with the listed connection types.

32 GB; the product name lists USB 3.0, Lightning, USB-C and Micro-USB.

View on Joybuy
SanDisk Ultra USB flash drive, 512 GB, USB 3.0

SanDisk Ultra USB flash drive 512 GB

A USB-A option if your workstation has this connection and you need more storage for your files.

512 GB; USB 3.0 is listed in the product name.

View on Joybuy
SanDisk Ultra Dual Drive Go USB flash drive, 512 GB, USB-A and USB-C

SanDisk Ultra Dual Drive Go 512 GB

An option for transferring files between devices with USB-A and USB-C.

512 GB; the product name lists USB 3.1 and USB-C, while the product information lists USB-A and USB-C.

View on Joybuy

Frequently asked questions

Is one USB flash drive enough for a backup?

Not if that leaves you relying on a single backup copy. For business data, the National Cyber Security Centre recommends keeping multiple versions on different media, with a copy at another location. Also test whether you can restore and open your files.

Does the GDPR always require an encrypted USB flash drive?

The Dutch Data Protection Authority doesn’t prescribe one type of USB flash drive for every spreadsheet. Organisations must choose appropriate security measures based on the risks. For sensitive documents that can’t be stored on the work server, the Authority recommends using an encrypted USB flash drive.

Can I set up BitLocker To Go on every shared Windows computer?

No, not on every edition of Windows. Microsoft says BitLocker Drive Encryption, including BitLocker To Go for removable drives, is available on Windows Pro, Enterprise and Education, but not Windows Home. Also check your permissions and the workstation’s IT policy.

How can I check whether my backup is usable?

Open a file from the backup and test whether you can actually restore an earlier version. The National Cyber Security Centre recommends testing backups. The capacity you need depends, among other things, on your files and how many versions you want to keep.

What should I do before disconnecting the flash drive?

First, check that copying has finished, then safely eject the flash drive. Microsoft recommends safely removing hardware in Windows before disconnecting a USB flash drive to help prevent data loss.