How to Use Google Sheets Offline
Learn how to use Google Sheets offline without internet. Covers setup in Chrome, editing offline, syncing changes, and troubleshooting common issues.
Sheets Bootcamp
February 27, 2026 ¡ Updated November 9, 2026
Google Sheets offline lets you view and edit spreadsheets without an internet connection. You need Chrome and a one-time setup, but after that, your recent files are available wherever you are, even on a plane or in a location with no Wi-Fi.
This guide walks through the setup process, explains how offline editing works, and covers how changes sync back when you reconnect.
In This Guide
- Requirements for Offline Access
- How to Enable Offline Mode: Step-by-Step
- How to Edit Sheets Offline
- Make Specific Files Available Offline
- How Syncing Works
- Offline on Mobile Devices
- Limitations of Offline Mode
- Common Issues and Fixes
- Tips and Best Practices
- Related Google Sheets Tutorials
- FAQ
Requirements for Offline Access
Before you can use Google Sheets offline, you need:
- Google Chrome browser (or a Chromebook). Offline access does not work in Firefox, Safari, Edge, or other browsers.
- Google Docs Offline extension installed in Chrome.
- Enough local storage for cached files. Each spreadsheet uses a small amount of disk space.
- An internet connection for initial setup. You need to be online to enable offline mode and download files. After that, you can go offline.
Offline access works only in Chrome. If you primarily use a different browser, youâll need to switch to Chrome for offline spreadsheet work, or consider exporting to Excel or CSV as an alternative.
How to Enable Offline Mode: Step-by-Step
Install the Google Docs Offline extension
Open Chrome and go to the Chrome Web Store. Search for Google Docs Offline and click Add to Chrome. This extension enables offline caching for Sheets, Docs, and Slides.
If youâre on a Chromebook, this extension may already be installed.
Enable offline access in Google Drive
- Go to drive.google.com in Chrome.
- Click the gear icon in the top right.
- Select Settings.
- In the General tab, check the box next to Offline: âCreate, open, and edit your recent Google Docs, Sheets, and Slides files on this device while offline.â
- Click Done.
Google Drive begins downloading your recent files in the background. This may take a few minutes.
Verify offline access
After enabling offline mode, wait a few minutes for files to cache. Then disconnect from the internet (turn off Wi-Fi or enable airplane mode) and open Chrome. Navigate to sheets.google.com. Your recent spreadsheets should appear and be openable.
A gray lightning bolt icon appears next to files that are available offline.
Enable offline mode while youâre on a stable Wi-Fi connection. The initial download of recent files uses bandwidth, and a slow connection can make the process unreliable.
How to Edit Sheets Offline
Once offline mode is enabled:
- Open Chrome (even without internet).
- Go to sheets.google.com or drive.google.com.
- Open any file marked with the offline indicator.
- Edit normally. You can type in cells, add formulas, format cells, and create new sheets.
Changes save automatically to your local device. When you reconnect to the internet, they sync to Googleâs servers.
Make Specific Files Available Offline
By default, Google Drive caches your most recently opened files. To ensure a specific file is available offline:
- Go to drive.google.com while online.
- Right-click the file.
- Select Make available offline.
A checkmark appears confirming the file will be cached. You can also do this from inside an open spreadsheet: go to File > Make available offline.
This is useful for files you know youâll need during travel or in areas with unreliable internet.
How Syncing Works
When you reconnect to the internet after editing offline:
- Google Sheets detects the connection automatically.
- All offline changes upload to Googleâs servers.
- A brief sync indicator appears in the file.
- The fileâs version history updates with your offline edits.
You do not need to click save or manually trigger the sync. It happens automatically.
If someone else edited the same file while you were offline, Google Sheets merges the changes. If both of you edited the same cell, the most recent edit wins. Check File > Version history > See version history if you want to review what changed.
Offline edits appear in the version history as a batch. All changes made during the offline session are grouped into one version entry rather than tracked individually.
Offline on Mobile Devices
The Google Sheets mobile app (iOS and Android) also supports offline access:
- Open the Google Sheets app.
- Find the file you want to cache.
- Tap the three-dot menu next to the file.
- Select Make available offline.
The file downloads to your device. You can open and edit it without internet. Changes sync when you reconnect, same as on desktop.
Unlike the desktop version, the mobile app does not require a Chrome extension. Offline access is built into the app.
Limitations of Offline Mode
Offline mode covers most editing tasks, but some features require an internet connection:
| Works offline | Requires internet |
|---|---|
| Typing and editing cells | IMPORTRANGE (pulls from other files) |
| Formulas (SUM, IF, VLOOKUP, etc.) | IMPORTDATA, IMPORTHTML, IMPORTXML |
| Formatting (colors, fonts, borders) | GOOGLEFINANCE (live stock data) |
| Charts (view and basic edits) | Apps Script triggers and custom functions |
| Sorting and filtering | Real-time collaboration with others |
| Adding and deleting sheets | Publishing to web |
| Find and replace | Add-ons |
Functions that pull data from external sources do not work offline because thereâs no network connection to fetch the data. Those cells show a loading or error state until you reconnect.
Common Issues and Fixes
Files donât appear offline
Make sure the Google Docs Offline extension is installed and enabled. Go to chrome://extensions and verify itâs turned on. Also check that offline access is enabled in Drive settings (gear icon > Settings > Offline).
âOffline is not availableâ message
This usually means youâre not signed into Chrome with your Google account, or youâre using an incognito/private window. Offline access requires a signed-in Chrome profile in a normal browsing window.
Changes didnât sync after reconnecting
Open Chrome and go to drive.google.com. If the sync indicator is not showing, try closing and reopening Chrome. Check your internet connection. If changes are still not syncing, go to chrome://drive-internals and check for sync errors.
Storage space warnings
Offline files use local storage. If your device is low on disk space, Google Drive may not cache files properly. Free up disk space or remove offline access for files you no longer need (right-click > Remove offline access).
Tips and Best Practices
- Set up offline access before you need it. Enable offline mode while youâre on a strong connection. Donât wait until youâre about to board a flight.
- Pin important files for offline access. Right-click > Make available offline for any file you rely on regularly. Donât depend on the ârecent filesâ cache alone.
- Check offline status before traveling. Open sheets.google.com while still online and verify your key files show the offline indicator.
- Avoid large collaborative edits offline. If multiple people are editing the same sheet, offline changes increase the chance of conflicts. Coordinate with collaborators before going offline for extended periods.
- Use offline mode with Google Sheets shortcuts. Keyboard shortcuts work the same offline. Use Ctrl+Z for undo, Ctrl+C/V for copy-paste, and Ctrl+Shift+V for paste values only.
Related Google Sheets Tutorials
- How to Share Google Sheets â Set permissions and sharing before going offline so collaborators have access
- How to Import CSV and Excel Files â Export to CSV or Excel as a backup before working offline
- Google Sheets vs Excel â Compare online and offline capabilities of both platforms
- Keyboard Shortcuts for Google Sheets â Shortcuts that work the same whether online or offline
FAQ
Can you use Google Sheets without internet?
Yes. Install the Google Docs Offline Chrome extension, enable offline access in Google Drive settings, and your recent Sheets files are available for viewing and editing without internet. Changes sync when you reconnect.
Do I need Chrome to use Google Sheets offline?
Yes. Offline access for Google Sheets requires the Chrome browser (or a Chromebook). The Google Docs Offline extension only works in Chrome. Other browsers like Firefox or Safari do not support this feature.
How do I enable offline mode for Google Sheets?
Go to drive.google.com in Chrome. Click the gear icon, select Settings, and check the Offline box. Install the Google Docs Offline extension if prompted. Google Drive caches your recent files for offline access.
Do changes sync automatically when I go back online?
Yes. When you reconnect to the internet, Google Sheets automatically syncs any changes you made offline. You do not need to manually save or upload. A sync icon appears briefly to confirm the upload.
Can I make specific files available offline?
Yes. In Google Drive, right-click any Sheets file and select Make available offline. This downloads that file specifically, even if it is not in your recent files. You can also do this from the File menu inside an open spreadsheet.
What happens if two people edit the same file offline?
When both users reconnect, Google Sheets merges the changes. If edits conflict (both users changed the same cell), Sheets keeps the most recent change and may show a notification. Check the version history (File > Version history) to review what changed.