Shared spreadsheet administrator
Want to restore an older version after a file has been deleted or overwritten? Choose a backup method with version history, and test the recovery process before relying on it.
First, choose a backup method that lets you restore earlier spreadsheet versions, and test that recovery works: an external drive won’t do this automatically. A portable HDD is a good fit if storage space and use at a fixed workstation are your priorities; an SSD makes more sense if you regularly carry the drive between computers or locations. The Digital Trust Center also advises against relying on a single storage location.
Want to restore an older version after a file has been deleted or overwritten? Choose a backup method with version history, and test the recovery process before relying on it.
If you store spreadsheets where unauthorised access is a risk, consider who can take the drive away or unlock it. For personal data, security measures must be appropriate to the risks involved in processing it; the Dutch Data Protection Authority recommends carrying out a risk assessment.
Do you take the backup drive with you or connect it to different computers? Check the available ports, cables and backup software on each computer.
A good fit if: you’ll mainly connect the drive at a fixed workstation and storage space matters.
Bear in mind: overwriting a file won’t automatically save earlier versions. Check the backup software and plan to keep a copy in another location too.
A good fit if: you regularly take the drive between computers or locations.
Bear in mind: the stated maximum speeds aren’t a measure of your spreadsheet backups. An SSD is no substitute for version history, a recovery test or a second copy.
| What to consider | What to look for | Who is this important for? |
|---|---|---|
| Restoring old versions | Check whether the backup software keeps the version history you need, and plan a recovery test. | If a shared spreadsheet is accidentally overwritten, I want to be able to restore an earlier version. Around 40% of consumers say version recovery is their main reason for buying. |
| Restricting access | Check what security settings are available and who can take the drive away or unlock it. | If you store files where unauthorised access is a risk, you’ll want to control access to the copy. Around 30% of consumers prioritise restricted access. |
| Capacity and a second copy | Work out how much space you need based on your files and retention period; plan to keep a copy in another location too. | If you want to keep several versions and avoid relying on a single location, you’ll need space for your backup plan and a separate copy. Around 20% of consumers prioritise this. |
| Connecting to multiple computers | Check the USB ports, cables and backup software on each computer. | If you work in different locations, you’ll want to be able to connect and use the drive with the computers you work on. Around 10% of consumers name compatibility with different workstations as their main priority. |
If a file is accidentally overwritten, you may no longer have the earlier version that you could still use.
Choose a backup method with suitable version history, and try restoring a file in advance.
If you lose access to that location, the backup stored there may also become inaccessible. The Digital Trust Center advises against relying on a single storage location.
As well as a local drive, include a separately stored copy in your backup plan and decide who can access it.
A stated maximum speed doesn’t tell you how quickly backups will run on your studio’s computers and spreadsheets.
First check the ports, cables, software and recovery process. Then consider whether portability is important for the way you work.
According to Ondernemersplein, statutory consumer cancellation periods and consumer guarantees don’t apply in the same way to business-to-business purchases.
Before placing your order, check who is legally making the purchase and confirm the applicable warranty and returns terms.
The portable SSD T7 is an option if you want to take a backup between workstations. T7 Shield is a separate product range, not the same model.
Canvio Basics is a range of portable HDDs for local copies.
Expansion Portable is a range of portable HDDs for a USB-powered backup setup.
The XS1000 is a compact SSD range for use between computers.
The X9 is a range of portable SSDs for which Crucial lists support for backup software.
These portable SSDs and HDDs are options for keeping a local spreadsheet copy. Check the connection on each computer, and set up version history and recovery separately.
No image available
A 1 TB portable SSD for a local copy you want to take between workstations.
The product description lists read speeds of up to 800 MB/s and drop protection from heights of up to 2 metres; these aren’t measurements specific to your studio.
No image available
A 2 TB portable HDD for a local copy; the description says it works with Time Machine.
The product description lists pre-formatting for Mac, password protection, hardware encryption, a USB-A cable and a USB-C adapter. Check that these suit your studio’s computers and software.
No image available
A 2 TB portable HDD for a local copy, with USB-C connectivity as stated in the product name.
The product description mentions plug-and-play use. Check the connection and backup software on the computers you want to use the drive with.
No image available
A 2 TB portable HDD for local copies; the product description mentions scheduled, configurable backups.
The description lists password protection, 256-bit AES hardware encryption, USB bus power and a USB-A-to-Micro-B cable. Set up security and a backup schedule to suit your studio’s needs.
Not necessarily: changes and deletions may also be synchronised. Use a separate backup feature that lets you actually restore the earlier versions you need.
Set the frequency according to how much work you could afford to lose if something went wrong. The Digital Trust Center gives daily or weekly backups as examples and recommends periodically restoring a backup to check that it works. These are recommendations, not fixed legal deadlines.
No. Check the file system and backup software. Toshiba says Canvio Basics drives are formatted as NTFS for Windows and need to be reformatted for macOS. Back up any existing data before reformatting a drive.
That depends on who is legally making the purchase. According to Ondernemersplein, statutory consumer guarantees don’t apply to business-to-business sales, so make sure the business warranty terms are clear. The statutory 14-day cancellation period for the specified consumer distance purchases doesn’t apply to a business purchase made by a business owner.
There isn’t one fixed encryption specification for every drive. If your studio processes personal data, the GDPR requires appropriate security based on a risk assessment, according to the Dutch Data Protection Authority. Encryption and restricted access may be suitable measures; the right choice depends on the risks involved in processing the data.