Volunteer responsible for backups
You want to make copies at regular intervals and check that spreadsheets can be restored from the backup. The National Cyber Security Centre advises opening files from a backup as a way to test recovery.
Start with a USB flash drive that works with the archive’s computers and has enough space for the spreadsheets and versions you want to keep. Don’t rely on it as your only copy: keep backups in separate locations and test them by opening files from the backup. If the spreadsheets contain personal data, tailor access controls to the risks and to who needs access.
You want to make copies at regular intervals and check that spreadsheets can be restored from the backup. The National Cyber Security Centre advises opening files from a backup as a way to test recovery.
If spreadsheets contain information about identifiable people, you need to assess what level of protection is appropriate for the risks and who needs access. The Dutch Data Protection Authority emphasises that personal data must be properly protected.
You may be using computers with USB-A and USB-C ports. Check which ports are available on both the computer used to make the copy and the one you’ll use to restore files.
| What to consider | What to look for when buying | Who is this important for? |
|---|---|---|
| Recoverability | Check that the flash drive works with the computer you’ll use for recovery, and plan a test where you open files from the backup. | I want to be able to restore some spreadsheets after a problem, not just see that they’ve been copied; around 36% of consumers put recoverability first. |
| Protection if lost | Assess whether the files contain personal data, who needs access and what level of protection is appropriate for the risks. | If the archive files contain confidential information, I want to decide in advance who can access them; around 29% of consumers give top priority to protection against loss or unauthorised access. |
| Connectivity | Check the port on both the computer used to make the copy and the one used for recovery; see whether you need USB-A, USB-C or both. | I switch between computers and don’t want to find that a port is missing when I need to restore files; around 21% of consumers focus mainly on compatibility with the computers they use. |
| Storage space and copying time | Choose the capacity based on your current folder and the versions you want to keep. If copying time matters, compare the specified write speed of the exact model. | If I want to keep several versions or copy files frequently, I want to know in advance how much space my archive needs; around 14% of consumers prioritise storage space and copying time. |
A USB flash drive is no substitute for a separate backup. The Digital Trust Center advises against relying on a single storage location, while the National Cyber Security Centre describes opening files as a way to test a backup. The capacity and space you need will depend on your archive folder and how many versions you keep.
If your only copy is lost or can no longer be read, you won’t be able to restore the archive from that drive. The Digital Trust Center advises keeping copies in separate locations.
Keep the copies separate and open a few spreadsheets from the backup as part of a recovery test. Include this test in your backup plan.
The Dutch Data Protection Authority cites the loss of a USB flash drive containing unencrypted personal data as an example of a data breach. Security measures should be appropriate for the risks associated with the data.
Check what data is stored on the drive, who needs access and what security features the exact model offers. Don’t assume that features of a secure product range are included in a standard flash drive.
Different models can vary in connectivity and capacity. Transcend notes that the speed of a JetFlash 790 may depend on the computer, software, usage and capacity, among other factors.
Compare the full model name, ports and capacity. If copying time is a priority, check the specified write speed of the exact model you’re considering.
DataTraveler Exodia is a USB-A range for storing documents. Kingston says its separate IronKey Locker+ 50 G2 range features hardware encryption.
According to SanDisk’s product information, the Ultra Dual Drive Go is designed for moving files between computers with USB-A and USB-C ports.
The JetFlash 790 is a USB-A option with a retractable connector.
The datAshur PRO² is an option to consider if a risk assessment points to the need for a flash drive with a PIN and encryption.
These product options are intended for spreadsheet backups using USB-A or USB-C connections. Capacity, connectivity and security features vary by model, so check which version works with the archive computers and provides the access controls you need.
No image available
A USB-A option for an archive computer with a compatible port.
128 GB; USB Type-A; USB 3.2 Gen 1 and USB 2.0.
Won’t connect directly to a computer with USB-C ports only.
No image available
A USB-A model for storage on a computer with a compatible port.
64 GB; USB 3.0. The product description mentions password protection and 128-bit AES encryption using SanDisk software.
The security described is software-based; consider whether this approach suits the archive’s access controls.
No image available
The dual connector may suit an archive that transfers files between computers with USB-A and USB-C ports.
512 GB; USB-A and USB Type-C; USB 3.1.
The dual connector doesn’t encrypt files automatically. Also check which port the computer you’ll use for recovery has.
No image available
A USB-C option for a computer with a compatible Type-C port.
512 GB; USB Type-C; USB 3.2 Gen 1 (3.1 Gen 1); grey.
Won’t connect directly to a computer with USB-A ports only.
No image available
The product description lists USB-A and USB-C, which may suit use with computers that have either type of connection.
256 GB; USB 3.2 Gen 1; USB-A and USB-C. The product title lists read speeds of up to 550 MB/s and write speeds of up to 500 MB/s.
The product description mentions fingerprint authentication and AES-256 encryption; check how access will be set up for the archive administrators.
No. Don’t make the archive dependent on a single storage location. The Digital Trust Center advises keeping copies in separate locations; you should also test that files can be opened from a backup.
As part of a recovery test, open a few files from the backup and check that you can retrieve the information you need. The National Cyber Security Centre describes this as a way to test a backup.
The Dutch Data Protection Authority’s guidance doesn’t require every archive to use one particular type of flash drive. If an organisation processes personal data, it must tailor its security to the risks; losing a drive containing unencrypted personal data could be a data breach. So assess the archive’s contents, the risks and who needs access before choosing a model.
Allow for a separate storage location and time to carry out recovery tests. The Digital Trust Center advises against relying on a single location, and the National Cyber Security Centre describes opening backup files as a way to test a backup.