1. Open Google Sheets and click on the Menu icon after logging into Google. 2. Select Settings.
  2. Click Turn on. If this is already turned on, you may have enabled the feature while making Google Docs available offline. 4. Click Get the app. 5. Click Add to Chrome. 6. Click Add extension. 7. Click the Google Sheets tab. 8. Click Enable Offline. Your docs will begin to download for offline use. Don’t disconnect immediately, as it takes some time.
  3. If you lose your internet connection, open Google Sheets and click on one of your documents. We recommend you bookmark the page for convenience. You’re now using Google Sheets offline. 

How to Save a Google Sheet for Offline Use in iOS and Android

Offline sync is also available for Google Sheets on iOS and Android, but it requires you to turn the feature on for each spreadsheet. The steps are the same for both Android and iOS.

  1. Tap the three dots icon in either the document view or list view.  
  2. Toggle Available offline to on. Now you can use a Google Sheet offline in iOS or Android.

Google Sheets Tips

Previous TipNext Tip

How to Use Google Sheets Conditional FormattingOpen Google Sheets in ExcelCreate Filters in Google SheetsHere’s Every Google Sheets Keyboard ShortcutWrap Text in Google SheetsConvert Excel Spreadsheets to Google SheetsMake a Chart or Graph in Google Sheets