Who is this guide for?

Anyone managing sensitive spreadsheets

You may store customer or staff data, for example, and need to consider the risk if the flash drive is lost as well as how you’ll recover your files. Not every spreadsheet contains this kind of data. For organisations that process personal data, the Dutch Data Protection Authority highlights the importance of appropriate security.

Anyone making regular local copies

You want to be able to restore a recent version after an error or hardware failure, without using cloud storage. The NCSC recommends keeping multiple versions of important business data.

Anyone using multiple devices

You make the copy on one device and want to open it on another. So check the connection type and make sure the files can be read on the device you’ll use for recovery.

What should you look for?

Start with the device you’ll use to restore your files and the versions you want to keep. Then decide whether confidentiality, connectivity or storage space matters most to you.

What to consider What to look for when buying Who should pay particular attention?
Recovery without the cloud Decide which files and versions to keep, and regularly try opening a file from the copy. I want to be able to restore recent versions if a file or flash drive fails. Around 33% of consumers put reliable recovery without the cloud first.
Protection if the drive is lost Consider whether the files contain confidential information and how authorised users will unlock the flash drive. If I store customer or staff data on a flash drive, I want to take the risk of losing it into account. Around 27% of consumers prioritise protection in case of loss.
Connection and readability Check whether you need USB-A or USB-C, and test that the recovery device can open the files and encryption you’ve chosen. I want to make the copy on one device and open it on another. Around 20% of consumers therefore start with connection type and readability.
Space for older versions Add up the files and versions you want to keep, then compare the total with the available capacity. I want enough room for multiple spreadsheets and older versions. Around 20% of consumers prioritise having space for different versions.

Common mistakes when choosing

  • Thinking one flash drive is a complete backup plan

    If both your working file and your only backup are lost, you won’t be able to use that copy to recover your data. The NCSC recommends keeping at least three versions of important business data: the original and two backups.

    Keep copies on separate media and regularly check that you can restore a file.

  • Assuming a standard flash drive automatically protects confidential data

    The Dutch Data Protection Authority identifies the loss of a USB flash drive containing unencrypted personal data as a potential data breach.

    Consider what information you’re storing and, if necessary, choose an encryption method that also works on the device you’ll use to restore your files.

  • Comparing only the connector and advertised read speed

    A compatible connection doesn’t prove that the recovery device can read an encrypted file. And a stated read speed doesn’t automatically tell you anything about write speed.

    Test the recovery process in advance, and compare speeds only for the exact model and task you need.

Brands to consider

Kingston

The IronKey Keypad 200 series is worth considering if you want built-in encryption and a flash drive you can unlock without host software.

  • Kingston says the series has an integrated keypad and XTS-AES-256 hardware encryption.
  • Choose the right USB-A or USB-C version. These features don’t automatically apply to other Kingston flash drives.

Samsung

The BAR Plus MUF-64BE4/APC is a USB-A option for everyday local file backups.

  • Samsung lists a sequential read speed of up to 300 MB/s for the 64GB version.
  • This isn’t a guaranteed write speed or a measure of how reliably you can recover files. Don’t assume it has built-in encryption unless this is confirmed for the version you choose.

Verbatim

The Store 'n' Go Secure Pro range is an option if you’re looking for a flash drive with built-in password protection.

  • Verbatim lists AES-256 hardware encryption for the 16GB USB-A version reviewed.
  • Verbatim says the data is erased after ten unsuccessful access attempts. Manage your password carefully and keep a separate recovery copy.

Transcend

The JetFlash 790 is a USB-A range with a retractable connector, designed for everyday file backups.

  • Transcend lists a 64GB version, among others, with part number TS64GJF790K.
  • Don’t assume this version has built-in encryption. Check the exact specifications if you need this feature.

SanDisk

The Ultra Dual Drive Go is a good option if you need both USB-A and USB-C.

  • SanDisk describes versions with both connection types.
  • Having two connectors doesn’t guarantee that the encrypted file format you choose will be readable on both devices. Check the exact version too.

USB flash drives at Joybuy

These USB flash drives are suitable for local spreadsheet backups, with versions for USB-A, USB-C or both connection types, and options for standard storage or software-based file protection.

SanDisk Ultra Dual Drive Go USB 3.1/USB-C 512GB

SanDisk Ultra Dual Drive Go 512GB

Ideal if you want to transfer files between devices with different USB connections.

512 GB; USB-C and a traditional USB connection.

A compatible connection doesn’t guarantee that encrypted files will be readable on both devices.

Joybuy
Kingston DataTraveler SE9 G3 64GB USB 3.2 Gen 1

Kingston DataTraveler SE9 G3 64GB

An option for everyday local spreadsheet backups on a device with USB-A.

64 GB; USB-A; USB 3.2 Gen 1; metal design.

Maximum stated speeds are 220 MB/s read and 100 MB/s write.

Joybuy
Samsung MUF-256BE USB flash drive 256 GB USB Type-A 3.2 Gen 1

Samsung MUF-256BE 256 GB USB Type-A

Suitable for local spreadsheet backups on a PC or laptop with USB-A.

256 GB; USB Type-A; USB 3.2 Gen 1 (3.1 Gen 1).

Joybuy
Samsung MUF-512DA USB flash drive 512 GB USB Type-C 3.2 Gen 1

Samsung MUF-512DA 512 GB USB Type-C

An option for a local backup on a device with USB-C.

512 GB; USB Type-C; USB 3.2 Gen 1 (3.1 Gen 1).

Maximum stated read speed is 400 MB/s.

Joybuy
SanDisk Ultra 64GB USB 3.0 Flash Drive

SanDisk Ultra 64GB USB 3.0 Flash Drive

Suitable for local document backups on a computer with USB-A if you’re looking for software-based file protection.

64 GB; USB-A; USB 3.0; SanDisk SecureAccess with 128-bit AES file encryption.

For use on a Mac, the product description says you need to download SanDisk SecureAccess software.

Joybuy

Frequently asked questions

Should one USB flash drive be the only copy of a spreadsheet backup?

No. Keep your working file and separate backups. For important business data, the NCSC recommends keeping at least three versions: the original and two backups. If you don’t use the cloud, you can keep these copies on separate storage media.

Is encryption essential for every spreadsheet on a USB flash drive?

It isn’t a blanket product requirement for every spreadsheet. For organisations that process personal data, the Dutch Data Protection Authority stresses the need for appropriate security, based on the processing involved and the risks. A lost flash drive containing unencrypted personal data could be a data breach.

Can I set up BitLocker To Go on Windows Home?

No. Microsoft says BitLocker Drive Encryption isn’t available in Windows Home. Check in advance which encryption methods are available on your work device and whether your recovery device can read the flash drive.

Can an older Mac always open a USB flash drive encrypted on a Mac?

No. Apple warns that the encryption method described converts the drive to APFS. Older Macs without APFS support won’t be able to read the data. Test the device you’ll use to restore your files in advance.

Must the loss of a flash drive containing personal data always be reported to the Dutch Data Protection Authority?

No. It depends on the risk to the people affected. The Dutch Data Protection Authority says a data breach must be reported unless it’s unlikely to pose a risk to their rights and freedoms. If a report is required, it must be made within 72 hours of becoming aware of the breach.