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:
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/
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:
Activating Offline Mode
Once you have the Google Chrome browser with the Google Docs Offline extension added, here’s how to activate offline mode:
Open Google Drive and click on the gear icon in the upper right corner, then select Settings from the menu that appears
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:
Using the Chrome browser, locate the spreadsheet you want to make available offline in Google Drive
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.
Your file will now be downloaded and available for offline use
Repeat for as many files as you want to make available offline
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
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.