How to use Google Sheets Offline
Google Drive is more than storage. It is a productivity suite that can open, edit and save in native Microsoft Office formats. In this tutorial we’ll show you how to configure your computer to be able to create Excel documents in Google Drive without any network connectivity. There is some initial setup that has to be done to enable this functionality. Follow these steps.
- Open Chrome and go to drive.google.com
- Click the gear at the top right and Settings
- Check the box beside ‘Offline’ and click DONE
- You’ll see the banner at the bottom for ‘Setting up offline…’. When this is complete you’ll see an icon left of the gear. It’s an underlined check in a circle. This indicates you are ready for offline use.
Now you can access drive.google.com without internet access and create new Google Sheets. They will be stored locally until you have internet access again, at which time they will synchronize with the network. When you are online you can right click on the Google Sheet and click Download. It will download an XLS file that can be opened with Excel.
Related Articles
Sheets: Download Google Sheet as Excel File
Another great feature Google Sheets offers is the ability to download a Google Sheet as an Excel, or .xlsx file. Why would we do this? We all know that some of our customers don’t accept Google Sheet files and require Excel files so let's walk ...
Move Excel file from Gmail into Google Sheets
How to move an Excel file (.XLS, .XLSX, .CSV) into Google Sheets from an email: Another great feature of Google Workspace, is the ability to integrate their applications. You can also move Excel spreadsheets directly from your inbox, into Google ...
Sheets: Import from NetSuite to Google Drive
How to export spreadsheets from Netsuite and save into Google Drive: In NetSuite, you can export any spreadsheet or PDF file and automatically save it into Google Drive, making it safe to store and easy to import into Google Docs or Google Sheets. To ...
Sheets: How to Import an Excel File
How to import an Excel file (.XLS, .XLSX, .CSV) into Google Sheets the correct way, using a downloaded file: There are a few different ways to open Google Sheets. In your internet browser, you can type in sheets.google.com or you can access it within ...
Sheets: Understanding Auto-Save and Version History
Understanding Auto-Save and Version History: One of the key features of Google applications is that they consistently auto-save, while you’re doing your work! This means, no more losing spreadsheet data that you’ve worked on for hours once your ...