How To Use Google Sheets Offline

In this tutorial, you will learn how to use Google Sheets offline.

How To Use Google Sheets Offline

Google Sheets is great for collaborating in real time over the internet and saving files in the cloud, but you can also use Google Sheets when you’re offline.

Any edits you make to spreadsheets while offline will be synced to the cloud when an internet connection is available again.

Read on to learn how to take advantage of the power of Google Sheets when you don’t have an internet connection.

Before Activating Offline Mode

Before you can use Google Sheets offline, there are some setup steps you need to follow:

Step 1

You must use the Chrome browser for offline mode. You can download it here if you do not have it: https://www.google.com/chrome/

Step 2

You need to use the Google Docs Offline Chrome extension.

To add the extension, navigate to the following link in the Chrome browser and click the blue Add to Chrome button:

https://chrome.google.com/webstore/detail/google-docs-offline/ghbmnnjooekpmoecnnnilnnbdlolhkhi

Activating Offline Mode

Once you have the Google Chrome browser with the Google Docs Offline extension added, here’s how to activate offline mode:

Step 1

Open Google Drive and click on the gear icon in the upper right corner, then select Settings from the menu that appears

Step 2

In the Settings window that opens, click on the checkbox next to the word Offline, then click DONE to save the setting

Saving Spreadsheets for Offline Use

If you have enough storage space on your harddrive, the extension will automatically save some of your recently viewed files for offline use but it’s not guaranteed that any given file will be saved.

To select specific files to save for offline use, follow these steps:

Step 1

Using the Chrome browser, locate the spreadsheet you want to make available offline in Google Drive

Step 2

Right click on the file and click on the Available Offline option from the menu.

You can tell if it’s already on by checking if the toggle switch on the menu item is already blue, as shown in the following screenshot.

Step 3

Your file will now be downloaded and available for offline use

Step 4

Repeat for as many files as you want to make available offline

Step 5

You can tell which files are available offline by checking for the blue checkmark icon beside the filename in Google Drive. Any files with this icon are available offline

Summary

In this tutorial, I covered how to use Google Sheets offline. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.