Who is this solution for?

People who regularly update spreadsheets

If a spreadsheet is accidentally deleted or overwritten, a tested local version backup can help you restore an earlier copy. Microsoft’s information about File History explains how to restore saved file versions.

People with confidential spreadsheets

For sensitive personal or work-related records, think not only about restoring them, but also about who could access the data if the drive is lost. Germany’s Federal Office for Information Security outlines ways to encrypt files and storage devices.

People with more than one computer

If you want to create or open backups on different devices without using the cloud, the connections, file system and, where applicable, the unlocking method need to work with those devices. Test the whole process, right through to opening a restored spreadsheet.

What should you look for when buying?

First check whether your local method saves older spreadsheet versions and lets you restore them. Then consider device compatibility and whether there’s enough space for the versions you want to keep. For confidential data, you should also plan how it will be encrypted and accessed later.

What you need What to check before buying Who it matters most to
Restore older spreadsheet versions Choose a local method that keeps versions, then test restoring an older file. If I need an earlier copy after overwriting a file, being able to restore it matters more than a high peak speed. Around 36% of consumers prioritise having versions they can restore.
Protect confidential spreadsheets Check how files or the drive are encrypted, and how you’ll unlock them on the device used for recovery. If the SSD contains sensitive personal or work-related records, I want to limit access if the drive is lost while still being able to find the key. Around 29% of consumers prioritise protecting confidential data.
Use with more than one device Test the connections, file system and any unlocking requirements on every computer you plan to use. If I need to open the backup on different computers, the entire restore process must work on each one. Around 21% of consumers name device compatibility as their top priority.
Space for data and versions Take into account the amount of data you have, how many older copies you want to keep and the usable capacity. If my spreadsheets are growing or I want to keep several older copies, I need enough usable storage space. Around 14% of consumers prioritise storage capacity.

Common backup mistakes

  • Relying on a single SSD as a complete backup plan

    An external drive can fail or be damaged along with your computer. A saved backup isn’t automatically recoverable.

    Keep another copy separately and test that you can open a restored spreadsheet.

    An extra copy may require another storage device, as well as time and effort to store it separately and test recovery.

  • Only replacing the latest spreadsheet file

    If a file is overwritten by mistake, the older version you need may no longer be available.

    If you make frequent changes, set up a local version backup and check that you can return to an earlier copy.

  • Confusing encryption with data backup

    Encryption prevents unauthorised access, but it won’t restore deleted or damaged files. If you can’t decrypt the backup, you may not be able to access it either.

    Plan for encryption and recoverable, separately stored backup copies as two distinct tasks.

Key brands to consider

Kingston

The XS1000 is a compact SSD range for local file backups. Kingston lists USB-A and USB-C connection options.

  • Kingston lists 1 and 2 TB capacities for the XS1000, with sequential read speeds of up to 1,050 MB/s.
  • These manufacturer specifications don’t prove that files are easier to restore or that spreadsheets will back up faster in practice. Check your backup and encryption methods separately.

Samsung

The T7 is a compact USB 3.2 Gen 2 SSD. Samsung says the T7 Shield is designed for use in situations where a protective casing matters.

  • Samsung lists maximum read and write speeds of up to 1,050 and 1,000 MB/s respectively for the T7.
  • Samsung says maximum speeds depend on the host and cable. The T7 Shield’s IP65 rating is based on controlled tests; Samsung excludes liquid and dust damage from its warranty. A protective casing is no substitute for a backup copy.

Crucial

The X9 is a USB-C option for local file backups. Crucial lists using it with Windows File History as one example.

  • Crucial states that the X9 delivers sequential performance of up to 1,050 MB/s under the manufacturer’s specified test conditions.
  • Crucial notes that performance may vary by device and usable capacity may be lower than the stated capacity. If you’ll use the drive with several devices, check the format and host features.

Joybuy products for local backups

The products below are external SSDs that could be used as local storage for spreadsheet backups. Older versions can only be restored if you set up a suitable backup method.

KEXIN external SSD with 256 GB, USB-C and speeds of up to 500 MB/s

KEXIN external SSD 256 GB

Suitable as local storage; access to older versions depends on the backup method you set up.

256 GB; USB-C; up to 500 MB/s according to the product name.

Joybuy
KEXIN external SSD with 1 TB, USB-C and speeds of up to 500 MB/s

KEXIN external SSD 1 TB

Suitable as local storage; access to older versions depends on the backup method you set up.

1 TB; USB-C; up to 500 MB/s according to the product name.

Joybuy
KEXIN external SSD with 512 GB, USB-C and speeds of up to 500 MB/s

KEXIN external SSD 512 GB

Suitable as local storage; access to older versions depends on the backup method you set up.

512 GB; USB-C; up to 500 MB/s according to the product name.

Joybuy
Samsung Portable SSD T7 with 1 TB, USB Type-C and USB 3.2 Gen 2

Samsung Portable SSD T7 1 TB, Grey

Suitable as local storage; you’ll also need a version backup to keep older copies of your spreadsheets.

1 TB; USB Type-C; USB 3.2 Gen 2 (3.1 Gen 2).

Joybuy
Samsung Portable SSD T7 with 2 TB, USB Type-C and USB 3.2 Gen 2 in Titanium Grey

Samsung Portable SSD T7 2 TB, Titanium Grey

Suitable as local storage if you’re planning space for data and several backup versions; you’ll need a suitable backup method to restore them.

2 TB; USB Type-C; USB 3.2 Gen 2.

Joybuy

Frequently asked questions

Is it enough to copy the spreadsheet to the SSD now and then?

Only if you can also restore the earlier version you need. For spreadsheets you update frequently, a local method that keeps several saved versions can help. Test restoring a file before relying on it.

How do I set up a backup without the cloud in Windows?

Microsoft explains how to use File History with an external drive as the backup destination. Check that the folder containing your spreadsheets is included, then try restoring an older version.

What should I check regularly after making a backup?

Check that new spreadsheets appear in the backup and that you can open a restored file. Keep another copy in a separate location in case the original location is damaged; Germany’s Federal Office for Information Security highlights recovery and keeping copies in separate locations as important considerations.

What ongoing costs and support should I plan for?

Keeping another copy separately may require an additional storage device. Check the warranty terms for the specific product; a manufacturer’s warranty is no substitute for a second backup.

Does the law require an SSD with a particular type of hardware encryption for spreadsheets containing personal data?

The official guidance cited here does not set out a blanket requirement for a particular type of SSD hardware encryption. If you process personal data for business purposes, the European Data Protection Board says you need suitable technical and organisational measures that are appropriate to the context and risk. Assess encryption and recoverability accordingly, and distinguish these from any software encryption you may use.