Shared work files manager
You store spreadsheets on a computer used by several people and need to decide who can open the backup, particularly if the files contain personal data.
First, choose a backup method that saves the right spreadsheet folders and earlier versions. Then choose an HDD or SSD based on how much space you need, the connection and how often you move the drive. An HDD may suit backups that usually stay in one place, while an SSD can be convenient if you carry the drive around often. On a shared workstation, decide separately who can access the backup and test whether you can restore a file.
You store spreadsheets on a computer used by several people and need to decide who can open the backup, particularly if the files contain personal data.
You want to be able to restore an earlier version after an accidental change or deletion, rather than simply copying files to a drive.
You connect the drive to different computers, so you want to make sure the connection, cable and backup software you choose all work together.
A good fit if: the drive usually stays at one workstation and you need space for successive backups.
Bear in mind: in July 2022, Consumentenbond described an HDD as more susceptible to shocks than an SSD.
A good fit if: you often move the drive between workstations or also transfer larger files.
Bear in mind: claimed top speeds are not a measurement of your spreadsheet backup, and an SSD is no substitute for a backup and recovery process that you have set up.
| What to consider | What to look for | Who is this important for? |
|---|---|---|
| Access to the backup | Decide who can access the drive and its files; check that security is enabled. | I don’t want everyone who uses the shared computer to be able to view my spreadsheets. Around 31% of consumers give restricted access their highest priority. |
| Restoring earlier versions | Check which folders and versions the software saves, and test whether you can restore a file. | If a spreadsheet is changed accidentally, I want to be able to retrieve a usable earlier version. Around 31% of consumers put version recovery first. |
| Connection and routine | Make sure the USB port and cable suit the workstation, and check that the backup method works with the operating system. | I want to be able to connect the drive at my workstation and back up my files as part of a manageable routine. Around 25% of consumers prioritise connection and regular use. |
| Storage space and retention period | Work out the total size of the files to be backed up and decide how many earlier copies you want to keep. | I want enough space for my files and the retention period I need, rather than considering the spreadsheet files alone. Around 13% of consumers make capacity their first priority. |
On Windows, File History can restore earlier versions of files included in the backup. Apple describes Time Machine as a way to back up files automatically using a compatible external storage device. For both systems, check your chosen destination, settings and connection. The National Cyber Security Centre recommends carrying out a restore to check that a backup can be used.
A copy of the current state may not help if a spreadsheet was changed incorrectly some time ago.
Decide which folders and versions your backup method saves, then test the restore process with a file you can open.
If the right earlier version is missing, restoring your work may take extra time and effort.
Anyone with access to the connected drive may be able to view spreadsheets that aren’t meant for them. Organisations processing personal data need to put appropriate security measures in place.
Decide who needs access and check that any password or encryption features are actually enabled.
A manufacturer’s speed specification doesn’t tell you how long your spreadsheet backup will take on the workstation you use.
First check the connection, how often you move the drive and how much data you copy. Then compare the different options.
Storage media and the location of a backup can fail too.
For important work files, consider keeping multiple copies on different media or in different locations, in line with your own backup policy.
A second copy or another storage location may require extra storage space.
The Expansion range includes portable HDDs for external file storage. Seagate lists the STKM2000400 variant, among others, with 2 TB of storage.
The Portable SSD T7 is a compact SSD option; the T7 Shield is a separate range with a more robustly designed casing.
The My Passport range may be worth considering if you’re looking into password protection for a portable drive.
Kingston offers portable SSD ranges, including models with both USB-A and USB-C, as well as a separate IronKey range.
These Joybuy products include portable external HDDs and SSDs for spreadsheet backups. Compare them based on connection, storage space, portability and the security or backup features you need.
No image available
A portable SSD option if you’re looking for an external place to store spreadsheet copies and want to take the drive between workstations.
Storage capacity: 1 TB.
No image available
A portable HDD option if you want to store files externally and use USB-C with your workstation.
Storage capacity: 5 TB. Connection: USB-C.
No image available
This portable HDD is designed as a Mac backup destination; check that its settings suit your Mac and backup routine.
Storage capacity: 2 TB. The title states that it is Time Machine-ready. The product description mentions a USB-A cable with a USB-C adapter and password protection via WD Discovery; enable this security feature yourself.
No image available
A portable HDD option to compare if you need space for files and several saved versions.
Storage capacity: 6 TB. The product description lists USB 3.0, 256-bit AES hardware encryption and password protection; enable the security feature using the supplied software.
No image available
A portable HDD option for spreadsheet copies if 2 TB suits your files and chosen retention period.
Storage capacity: 2 TB. The product description lists USB 3.0, 256-bit AES hardware encryption and password protection via WD Discovery; enable the security feature yourself.
No. Set up a backup of the right folders and check that your chosen method saves earlier versions. Microsoft says File History can restore earlier versions of files included in the backup; then test whether you can restore and open a file.
First check the computers and the backup method you plan to use. Apple explains which external destinations Time Machine can use, but a general compatibility statement doesn’t prove that the current format and settings are suitable for both backup tasks.
Microsoft says the external drive needs to be connected. Reconnect it and check that the next scheduled backup takes place, or start one manually by following Microsoft’s instructions.
According to ACM ConsuWijzer, as a consumer you have a statutory guarantee in addition to any manufacturer’s or seller’s guarantee if, under normal use, the product doesn’t meet reasonable expectations; the seller is your point of contact. This guidance doesn’t automatically establish which terms apply to a business purchase or to recovering lost files.
If an organisation processes personal data, it must protect that data appropriately. Whether this applies to your spreadsheets depends on their contents and how they’re used: information about an identifiable person is personal data, while the Dutch Data Protection Authority says the GDPR doesn’t apply to processing carried out solely for personal or household purposes. The Dutch Data Protection Authority lists access controls, backups and encryption as possible measures, but doesn’t require every buyer to encrypt every drive.