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.
Start by choosing a backup process that lets you restore a recent spreadsheet. A USB flash drive can be one place to store a copy, but it isn’t a complete backup strategy on its own. If the files contain personal data or other confidential information, decide what access controls and encryption are appropriate. Then check the connection and system requirements. Safe Internetting and the National Cyber Security Centre also stress the importance of testing restores and keeping multiple backup versions.
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.
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.
You want to be able to restore files on different devices, so you check the available USB ports and system compatibility.
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.
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.
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. |
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.
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.
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.
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.
These examples from Kingston include both basic USB-A flash drives and models with security features. Specifications vary by model.
The Ultra Dual Drive Luxe is designed for use with USB-A and USB-C devices.
The Keypad Secure USB-C Drive is an option if you want to enter the access code on the flash drive itself.
The BAR Plus MUF-128BE4/APC is a USB-A model whose specifications you can compare with those of other basic flash drives.
The JetFlash 790 is a USB-A model with a retractable connector.
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.
No image available
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.
No image available
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.
No image available
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.
No image available
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.
No image available
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.
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.
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.
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.
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.
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.