Who should use a USB drive to back up files without the cloud?

Anyone with important spreadsheet versions

If you regularly update spreadsheets, you should be able to find and open an older copy when needed. A practical backup routine, separate storage and a recovery test all matter. The BSI recommends planning for recovery and keeping the storage device separate from your computer.

Anyone responsible for confidential spreadsheets

If your spreadsheets contain personal information or you often carry your USB drive with you, you’ll need to consider protection against unauthorised access if it’s lost, as well as recovery. The BfDI generally recommends encrypting data stored on USB drives.

Anyone using more than one computer

If you want to open a copy on devices with USB-A and USB-C ports, or on macOS and Windows, check the connector and file system together. Apple Support notes that formatting a drive erases any files already stored on it.

What should you consider when choosing one?

First, decide how you’ll store the copy separately and restore it when needed. Then choose a connector, encryption and capacity to suit your spreadsheets and devices.

What matters What to check before buying Who should consider this?
Recoverable backups Check there’s enough room for the spreadsheet versions you plan to keep; try opening a copy on the device you’ll use to restore it. If I need to access earlier spreadsheet versions after a device failure, a tested backup routine and separate storage matter to me. Around 36% of consumers prioritise recovery.
Keeping data private if the drive is lost Check whether the specific model is encrypted or whether a suitable software solution is available; plan where to store the key or passcode. If confidential spreadsheets could be lost while I’m out and about, I want to make unauthorised access harder and still be able to regain access myself. Around 29% of consumers prioritise confidentiality.
Access across multiple devices Check that the USB-A or USB-C connector and file system work with the devices you plan to use; open a test file on every system you need. If I need to open the copy on computers with different ports or operating systems, I want to test access in advance. Around 21% of consumers prioritise device compatibility.
Room for previous versions Work out the size of the backup folder you plan to keep and how many versions it will contain; compare this with the capacity actually available. If I want to keep previous spreadsheet versions, the drive needs to have enough room for the entire folder. Around 14% of consumers mainly look for space to store different versions.

Common mistakes when backing up to USB

  • Relying on a single USB drive as your complete backup

    Storage devices can fail. You also need to know that you’ll be able to open and restore a backup later.

    Don’t replace your working file with a copy of it. Store the drive separately and check that you can open a backed-up spreadsheet.

  • Confusing encryption with backing up your data

    Encryption can help prevent unauthorised access, but it won’t restore lost or damaged files.

    Plan for data protection and recovery separately. Also check that you can unlock the drive on a suitable replacement device.

  • Checking only the connector, not the file system

    A connector that fits your device doesn’t necessarily mean you’ll be able to open the files on all the devices you plan to use. Formatting a drive erases any files already stored on it.

    Open a test copy on every device you need, and make additional copies of any files you need before formatting.

USB drive brands at a glance

Kingston

The DataTraveler Exodia M range is a USB-A option for straightforward local copies. IronKey Vault Privacy 50 is a separate range for encrypted storage.

  • Kingston lists USB-A, capacities from 64 to 256 GB and a five-year warranty for Exodia M.
  • For the IronKey Vault Privacy 50 series, Kingston lists hardware-based XTS-AES 256-bit encryption and USB-A or USB-C options.
  • The VP50 series encryption specification does not apply to Exodia M. Check the connector and warranty terms for the specific model you choose.

Verbatim

According to Verbatim, the Dual USB Drive 128 GB (49968) has USB-A and USB-C connectors. The Keypad Secure 128 GB (49429) is a separate USB-A option with a passcode keypad.

  • Verbatim lists both connectors for the Dual model and hardware-based encryption for the Keypad Secure model.
  • These features belong to different models: the Dual model is not specified as encrypted, while the Keypad model mentioned here uses USB-A.

Transcend

JetFlash 790 is a USB-A range with a retractable connector for local file copies.

  • Transcend lists capacities from 16 to 512 GB.
  • Transcend notes that the actual capacity may be lower than the stated capacity. Check there’s enough available space for the spreadsheet versions you plan to keep.

Samsung

The BAR Plus 256 GB (MUF-256BE3/APC) is a USB-A option, provided the connector suits your backup and recovery set-up.

  • Samsung lists read speeds of up to 400 MB/s for this model.
  • The manufacturer’s read-speed specification is not a guarantee of performance when writing lots of small spreadsheet files.

Joybuy products for local spreadsheet copies

The Joybuy products below are for straightforward local USB copies and include USB-A and USB-C options. Check the connector, file system and recovery process on your own device.

Kexin 5-pack USB 2.0 flash drives, 8 GB option

Kexin 5-pack USB 2.0 flash drives, 8 GB option

For keeping a local copy of spreadsheet files; the retractable design is described as suitable for carrying around.

The title specifies a 5-pack of retractable USB 2.0 drives; this option is listed as 8 GB.

View at Joybuy
Kexin 5-pack USB 2.0 flash drives, 16 GB option

Kexin 5-pack USB 2.0 flash drives, 16 GB option

For keeping a local copy of spreadsheet files; the retractable design is described as suitable for carrying around.

The title specifies a 5-pack of retractable USB 2.0 drives; this option is listed as 16 GB.

View at Joybuy
Kexin 5-pack USB 2.0 flash drives, 32 GB option

Kexin 5-pack USB 2.0 flash drives, 32 GB option

For keeping a local copy of spreadsheet files; the retractable design is described as suitable for carrying around.

The title specifies a 5-pack of retractable USB 2.0 drives; this option is listed as 32 GB.

View at Joybuy
Kexin 5-pack USB 2.0 flash drives, 64 GB option

Kexin 5-pack USB 2.0 flash drives, 64 GB option

For keeping a local copy of spreadsheet files; the retractable design is described as suitable for carrying around.

The title specifies a 5-pack of retractable USB 2.0 drives; this option is listed as 64 GB.

View at Joybuy
Kexin 2-in-1 USB-A and USB-C flash drive, 32 GB, 2-pack

Kexin 2-in-1 USB-A and USB-C flash drive, 32 GB, 2-pack

For transferring files locally between devices when you need USB-A and USB-C.

The title specifies USB 2.0, 32 GB, a 2-pack and a 360° swivel design. Check that the file system works with the devices you plan to use.

View at Joybuy

Frequently asked questions about USB drive backups

Is copying a spreadsheet to a USB drive once enough?

No, not if you continue to update the working file. Back up the versions you need again and try opening a copy from the USB drive. If your device is damaged, the drive should be stored separately. The BSI recommends planning for recovery, too.

Do I need to format the drive for Mac and Windows?

Only if the current file system isn’t compatible with the devices you plan to use. Check it before making any changes; Apple Support notes that formatting a drive erases any files already stored on it. Make additional copies of the files you need first.

Is a CSV file always a complete backup of my workbook?

No. Microsoft Support notes that saving a workbook as a text or CSV file can cause formatting, data or features to be lost. Keep a copy in the original workbook format you need and test it.

What should I consider about support and storage before buying?

Allow enough space for the spreadsheet versions you want to keep and, if necessary, another local storage device kept separately. Check the warranty terms and unlocking process for the specific model; a warranty is no substitute for a recoverable copy of your files.

Is a particular encrypted USB model required for spreadsheets containing personal data in Germany?

Article 32 of the GDPR requires controllers and processors to implement appropriate technical and organisational measures that are proportionate to the risks; it does not impose a blanket requirement to use a particular USB drive model. The BfDI generally recommends encrypting data stored on USB drives. The right measure depends on the level of protection needed and the context in which the data is processed.