Google Sheets

Google Sheets is a spreadsheet program included as part of a free, web-based software office suite offered by Google within its Google Drive service. The service also includes Google Docs and Google Slides, a word processor, and a presentation program respectively. But many of the users have been using it when it’s connected to the internet. Many of them wonder if they may be able to use it in offline mode just like Microsoft office. Well, this guide is a solution for using Google Sheets offline.

Google Sheets

Must See: Best Android Auto Tips and Tricks [Notifications, OK Google]

Google Sheets

Google Sheets is available as a web application, mobile app for Android, iOS, Windows, and as a desktop application on Google’s ChromeOS. Luckily, the app is compatible with Microsoft Excel file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by a user with a revision history presenting changes.

An editor’s position is highlighted with an editor-specific color and cursor and a permissions system regulates what users can do. Updates have introduced features using machine learning, including “Explore”, offering answers based on natural language questions in a spreadsheet.

Back in June 2014, Google rolled out a dedicated website homepage for Sheets that contain only files created with Sheets. During the same year, Google launched a dedicated mobile app for Sheets on the Android and iOS mobile Operating Systems. In 2015, the mobile website for Sheets was updated with a “simpler, more uniform” interface, and while users can read spreadsheets through the mobile websites, users trying to edit will be redirected towards the mobile app to eliminate editing on the mobile web.

Steps to use Google Docs, Sheets, and Slides offline

Before you turn on offline access

  1. Make sure that the device is connected to the internet.
  2. It is recommended to use the Google Chrome browser.
  3. Refrain from using incognito mode.
  4. Install and turn on Google Docs Offline Chrome extension.
  5. Make sure you have enough available space on your device to save your files.

Steps to turn on offline access from PC

  1. Open Google Drive.
  2. At the top right, click Settings.
  3. Turn on the Offline setting (Turn off to stop offline access).
  4. Open Google Docs, Sheets, or Slides from the Chrome browser.
  5. Now, to make specific files available offline
  6. To manually select files to save offline, follow the steps above to turn on offline access.
  7. Then, open the Google Docs, Sheets, or Slides home screen.
  8. On the file, you want to use offline, click More.
  9. Click Available offline. A checkmark will appear in the bottom left corner to show that the file is available offline.

Steps to turn on offline access from Android devices

  1. On your Android phone or tablet, open the Google DocsSheets, or Slides app.
  2. Open setting from the menu.
  3. Select “Make recent files available offline” option.
  4. Now to make specific files available offline, open the Google Docs, Sheets, or Slides app.
  5. Next to the file, tap More.
  6. To save a file offline, tap “Make available offline”.
  7. Now if you need to find the files you saved for offline access, open the Google Docs, Sheets, or Slides app.
  8. Tap menu, followed by the offline option.
  9. Select your file.

Steps to turn on offline access from iPhone or iPad

  1. Make recent files available offline, open the Google DocsSheets, or Slides app.
  2. Open setting from the menu.
  3. Select “Make recent files available offline” option.
  4. Similarly, to make specific files available offline, open the Google Docs, Sheets, or Slides app.
  5. Next to the file, tap More.
  6. Tap menu, followed by the offline option.
  7. Select your file.
Recommended read: Xiaomi Mi 10 Lite Doraemon Limited Edition launched