How to Back Up & Secure Your Business Data in Excel

Last updated: 27 June 2026

The single most dangerous thing a small business does with its Excel data is keep only one copy on one computer. A crashed hard drive, a stolen laptop, an accidental "Save" over the wrong file, or a ransomware attack can erase years of invoices, payroll records and GST data permanently. This guide sets up a free, automatic backup system using Excel's built-in tools, Google Drive or OneDrive, and a simple monthly export routine — in under 30 minutes.

Key takeaways

• AutoRecover (built into Excel) saves a recovery copy every 5 minutes — enable it immediately if you have not already.
• A cloud folder (Google Drive or OneDrive) automatically syncs every save to the cloud — this is your offsite backup, for free.
• Version history (OneDrive / Google Drive) keeps every version for 30–180 days — you can restore a file to any earlier state.
• A monthly export to a separate dated folder (local or cloud) is your "point-in-time" archive, separate from the working file.
• Password-encrypting your backup files protects sensitive payroll and customer data if the device is lost or stolen.
• Excel's own "Always create backup" option (File → Options → Save) creates a .xlk file alongside the main file — a second copy on the same drive, useful against accidental overwrites but not against hard drive failure.

Fact box. Hard drive failure is the most common cause of small business data loss — estimated to affect 1 in 50 drives per year. The second most common cause is accidental file overwrite (saving the wrong version). A three-layer backup (AutoRecover + cloud sync + monthly export) protects against both, costs nothing, and takes 20 minutes to set up.

What are the three layers of a reliable backup?

A business-grade backup uses three layers. Each covers a different failure mode:

Using only one layer is insufficient. A cloud-synced file that is accidentally overwritten restores the overwritten version — unless you also have version history or a monthly export.

Layer 1: How do I set up AutoRecover?

AutoRecover saves a temporary copy of your open workbook every few minutes. If Excel crashes, it offers to restore from the most recent AutoRecover save when you reopen.

Steps:

1. Go to File → Options → Save.
2. Check "Save AutoRecover information every __ minutes". Set to 5 minutes.
3. Check "Keep the last autosaved version if I close without saving".
4. Note the AutoRecover file location — this is where recovery files are stored. Leave it as-is.
5. Click OK.

From now on, if your computer crashes while you are editing an invoice, Excel restores a copy from the last 5-minute save when you reopen.

Important: AutoRecover is not a backup. It is a crash recovery tool. The AutoRecover files are deleted when you close Excel normally. Do not rely on it as your only safety net.

Layer 2: How do I set up cloud sync as automatic backup?

Cloud sync means every time you press Ctrl+S, your file is automatically copied to a cloud server. If your laptop dies, you open the same file from any other device.

Option A: Google Drive (free, 15GB)

1. Download and install Google Drive for Desktop (formerly Backup and Sync) from drive.google.com.
2. During setup, choose a folder on your computer to sync (e.g. D:\Business\FY2026-27\).
3. Move your Excel working files into this folder (or create new files there).
4. Google Drive syncs every save to the cloud within seconds.

After setup, you see a small cloud icon in the system tray. A green tick on a file means it is synced. An orange symbol means it is syncing.

Version history: In Google Drive (browser), right-click a file → Manage Versions. Google Drive keeps 30 days of version history for free. You can restore any version within that window.

Option B: OneDrive (free, 5GB; more with Microsoft 365)

OneDrive is built into Windows 10 and 11. To set it up:

1. Open File Explorer → click OneDrive in the left panel (or search for "OneDrive" in the Start menu).
2. Sign in with your Microsoft account.
3. Choose folders to sync — move your business folder to the OneDrive folder.

OneDrive's advantage: AutoSave (for Microsoft 365 users). When your workbook is saved in OneDrive, the AutoSave toggle in Excel turns on — Excel saves continuously, not every 5 minutes. Every change is saved and versioned automatically.

Version history: In OneDrive (browser), right-click a file → Version History. OneDrive keeps 30 days of version history on the free plan, up to 180 days with Microsoft 365.

Fact box. Both Google Drive and OneDrive provide version history — the ability to restore a file to any earlier state within the history window. This means if you accidentally overwrite a month's payroll data with a Ctrl+S, you can restore the file to 5 minutes before the mistake. Without version history, that data is gone permanently.

Layer 3: How do I set up monthly point-in-time exports?

Cloud sync keeps your working file current — but if you corrupt the file and sync it, the cloud copy is also corrupt. A monthly export is a frozen copy of the file at end-of-month, kept separately.

Process (takes 2 minutes at month end):

1. At the end of each month, press F12 (or File → Save As).
2. Navigate to a separate archive folder: D:\Business\Archive\FY2026-27\.
3. Save the file with a dated name: FY2026-27-Business_May2026.xlsx.
4. Do not touch this file again — it is the frozen record.

Automate the naming with a macro:

Sub Archive_Monthly()
    Dim fileName As String
    fileName = "FY2026-27-Business_" & Format(Now, "MMMMyyyy") & ".xlsx"
    ActiveWorkbook.SaveCopyAs "D:\Business\Archive\FY2026-27\" & fileName
    MsgBox "Archived as " & fileName
End Sub

Assign this macro to a button. At month end, one click creates the archive. The working file stays open and is not affected (SaveCopyAs does not change the current file or its name).

How do I protect backup files from unauthorised access?

Your backup files contain payroll data, customer GSTINs, banking amounts — all sensitive. Apply file-level encryption before storing or sharing.

Steps:

1. Open the backup file.
2. File → Info → Protect Workbook → Encrypt with Password.
3. Enter a strong password (12+ characters, mixed case, numbers, symbols).
4. Save. The file now requires the password to open.
5. Store the password in a password manager (Bitwarden, KeePass — both free). Do not store the password in the same folder as the file.

For files stored in Google Drive or OneDrive: the cloud provider can technically access file contents in emergency/legal scenarios. Encrypting the file before uploading means only you (with the password) can read it — even if someone gains access to your cloud account.

What else should I back up besides the Excel workbook?

Your backup strategy should cover:

Treat your D:\Business\ folder as the single source of truth. Keep everything in it. Let cloud sync protect all of it.

What is the "Always create backup" option in Excel?

File → Options → Save → "Keep the last autosaved version if I close without saving" is separate from another feature: "Always create backup" which is in File → Save As → Tools → General Options.

When enabled, Excel creates a .xlk file alongside your workbook every time you save. This .xlk is the previous version of the file — one save behind. If you save a corrupted file, the .xlk has the pre-corruption version.

Limitation: Both the main file and .xlk are on the same drive. A hard drive failure destroys both. This option complements cloud sync but does not replace it.

How often should I test my backup?

Test your backup restore once every quarter:

1. Pick any archived monthly file.
2. Copy it to a test location (your Desktop).
3. Open it — confirm it opens correctly and the data is readable.
4. Check that the last 30 days of version history is available in Google Drive or OneDrive.

If any layer fails the test, fix it before you need it in an emergency.

How Ankeshan helps: Ankeshan stores each month's finalised invoices, payroll runs and GST summaries as a timestamped archive inside a protected folder structure in your existing cloud drive — no separate backup workflow needed. It is launching soon; join the waitlist.

Frequently asked questions

Is Google Drive safe for storing GST and payroll data? Google Drive uses AES-256 encryption for data at rest and TLS for data in transit. For additional security, encrypt your Excel files with a password before uploading — then even Google cannot read the contents without the password. For most Indian SMBs, Google Drive provides better protection than a local hard drive alone.

What happens if I accidentally delete a file in my synced cloud folder? Google Drive keeps deleted files in Trash for 30 days. OneDrive keeps them in the Recycle Bin for 30 days (Microsoft 365: 93 days). Go to drive.google.com or onedrive.live.com, find the file in Trash / Recycle Bin, and restore it.

My laptop was stolen — how do I access my business data? If your files were in a synced cloud folder, log into Google Drive or OneDrive from any computer and access all your files. If the laptop had files only locally (not synced), they are not recoverable from the cloud. This is exactly the scenario that cloud sync prevents.

How long should I keep my archive files? Keep GST-related records for 6 years (CGST Act requirement). Keep payroll and TDS records for 7 years (Income Tax Act requirement). Your monthly archives should be retained for at least 7 years. Cloud storage and external hard drive storage are both cheap enough that retention is not a cost issue.

Can I back up to a USB drive instead of the cloud? Yes, and it is a useful third copy. After your monthly export, copy the file to a USB drive stored off-site (at home if the office is the primary location, or in a fireproof safe). A USB backup protects against scenarios where you lose internet access during an emergency — but it requires a manual habit, unlike automatic cloud sync.

Sources

• Microsoft Support — AutoRecover, AutoSave, version history in OneDrive (support.microsoft.com)
• Google Support — Google Drive version history and storage (support.google.com)
• CBIC — CGST Act 2017, Section 36 (record retention 6 years) (cbic-gst.gov.in)
• Income Tax Department — Record retention requirements for employers

General information only, not professional advice. Verify retention periods for your specific business with a Chartered Accountant or legal adviser. Reviewed by a Chartered Accountant; last updated 27 June 2026.

Related: Excel for Business — pillar guide » · Protect and Share a Workbook » · Automate Repetitive Tasks in Excel » · Excel Macros for Accounting »