How to work offline on Google Sheets (desktop and mobile)
Turn on offline mode, make a specific sheet available offline, and see which features stop working without a connection.
What "offline" actually means in Google Sheets
Google Sheets can open, edit and recalculate a spreadsheet with no network connection at all. Your edits queue locally and push to Google's servers the moment you reconnect. This is not a degraded read-only mode - you can add rows, rewrite formulas and reorganise tabs while completely disconnected.
There are two things people mean by this, and they need different steps:
- Turning on offline access once, for your account and device. This covers your recently opened files automatically.
- Making one specific sheet available offline, so a file you will need on a flight is definitely cached even if you have not opened it lately.
You usually want both. Here is the whole setup.
Step 1: Install the Google Docs Offline extension
Offline editing only works in Chrome or Microsoft Edge. Safari and Firefox cannot do it, and no extension will change that - the feature depends on Chromium storage APIs that Google's offline layer is built on.
Install the official Google Docs Offline extension from the Chrome Web Store. If you are on a managed work device, your admin may have installed it already. Check chrome://extensions and confirm it is present and enabled.
One thing that catches people out: this does not work in an incognito or guest window. Offline access needs a persistent browser profile to cache into, and incognito by design throws that away.
Step 2: Turn on offline access in Google Drive
With the extension in place:
- Open Google Drive.
- Click the gear icon in the top right, then Settings.
- Find the Offline section.
- Tick "Create, open and edit your recent Google Docs, Sheets and Slides files on this device."
Drive will start syncing your recent files in the background. Give it a few minutes on a decent connection before you rely on it - the first sync is the slowest, because it is caching file contents rather than just names.
This setting is per device and per browser profile. Turning it on your laptop does nothing for your desktop, and a second Chrome profile needs its own toggle.
Step 3: Make a specific sheet available offline
The recent-files sync is convenient but not something you should trust for a file that matters. If you know you will need a particular spreadsheet, pin it explicitly.
From Google Drive: right-click the file and toggle Available offline.
From inside the sheet: open it, then choose File → Make available offline.
Once pinned, the file stays cached until you turn the toggle off, regardless of how long it has been since you opened it. Pinned files show a small offline badge (a checkmark inside a circle) in Drive - that badge is your confirmation the content is actually on disk, not just the filename.
Step 4: Enable offline files in the mobile app
The Android and iOS Google Sheets apps handle this separately from the browser.
- Open the Google Sheets app.
- Tap the three-dot menu next to the file you want.
- Turn on Available offline.
Mobile behaves differently in one important way: the app does not automatically cache your recent files the way desktop Drive does. On mobile you must pin each file individually. If you are heading somewhere without signal, go through and toggle every sheet you might need.
Step 5: Confirm the file is synced before you disconnect
The failure mode here is silent, so verify rather than assume. Before you lose connectivity:
- Check the file shows the offline badge in Drive.
- Open the sheet once while still online. Opening it forces the content to cache, which pinning alone can occasionally lag behind on.
- Watch for the "Working offline" indicator once you disconnect. If it appears, you are genuinely in offline mode. If you get an error page instead, the file was never cached.
What stops working offline
Most of Sheets works normally. These do not:
Functions that fetch data over the network. IMPORTRANGE, IMPORTDATA, IMPORTHTML, IMPORTXML, GOOGLEFINANCE, IMAGE and GOOGLETRANSLATE all need a connection. Offline they hold their last cached value or show an error. This matters more than it sounds: if your sheet pulls its source data through IMPORTRANGE, going offline freezes that data at whatever it was when you last synced.
Add-ons and Apps Script triggers. Anything from the Extensions menu is unavailable, and time-based Apps Script triggers do not fire on your device.
Sharing, commenting and version history. You cannot change permissions, leave comments or browse revision history until you reconnect.
Anything involving other people. No live collaboration cursors, no real-time updates. You are editing your local copy, and it merges later.
Conflicts and how Sheets resolves them
If you and a colleague both edit while disconnected, both sets of changes get queued. On reconnect, Google merges them. Edits to different cells combine cleanly with no intervention.
Edits to the same cell produce a conflict, and Sheets tells you rather than quietly picking a winner. That is better behaviour than a lot of purpose-built sync systems manage. The full version history is also preserved, so File → Version history → See version history lets you restore either state.
The genuine risk is not conflicts, it is losing the local cache before it syncs. Clearing browsing data, signing out of Chrome, or wiping the browser profile discards unsynced offline edits permanently. If you have done significant offline work, reconnect and confirm the sync before you touch anything that clears browser storage.
When you need programmatic access instead
Offline mode solves a person editing a spreadsheet without a connection. It does not help when an application needs that data - an app cannot read Chrome's offline cache, and the Google Sheets API requires a network round trip on every call.
If what you actually want is your sheet's data available to your own code, the pattern that works is to read it through an HTTP API and cache the response on your side. GKit SheetsAPI turns any Google Sheet into a REST endpoint you can call with plain fetch():
GET /api/spreadsheets/{userKey}/{sheetName}
Your app caches that JSON in local storage, IndexedDB or a service worker, and serves the cached copy when the network is unavailable. That gives your users an offline experience while your data stays editable in a spreadsheet your team already knows. We wrote about why this combination works well in Google Sheets as an offline-first data store.
It is free while in beta, and there is more detail in the SheetsAPI docs.
Quick reference
| Goal | Where to go |
|---|---|
| Turn on offline access | Drive → gear icon → Settings → Offline |
| Pin one file (desktop) | Right-click file → Available offline |
| Pin one file (in the sheet) | File → Make available offline |
| Pin one file (mobile) | Three-dot menu → Available offline |
| Check a file is cached | Offline badge in Drive, plus open it once online |
| Required browser | Chrome or Edge, not incognito |
| Required extension | Google Docs Offline |
Frequently asked questions
Can you use Google Sheets without internet?
Yes. Once you enable offline access in Google Drive settings and install the Google Docs Offline extension, you can open and edit recent Google Sheets files with no connection. Edits are stored locally and sync automatically the next time you go online.
Why is the 'Available offline' option greyed out?
The option is unavailable in Safari and Firefox, in Chrome incognito or guest windows, and when the Google Docs Offline extension is missing or disabled. Offline editing requires Chrome or Edge with that extension installed and the account signed in normally.
Do formulas still work offline in Google Sheets?
Most do. Functions that need a network call do not: IMPORTRANGE, IMPORTDATA, IMPORTHTML, IMPORTXML, GOOGLEFINANCE, IMAGE and GOOGLETRANSLATE keep their last cached value or return an error until you reconnect.
What happens if two people edit the same cell offline?
Google queues both sets of changes and reconciles them on reconnect. When the same cell was changed by two people, Sheets surfaces the conflict rather than silently discarding one version, and the file's version history keeps both states so you can restore either.
How much data does offline Google Sheets store on my device?
Only your recently opened files plus any file you explicitly mark as available offline. The cache lives in your browser profile, so clearing browsing data or signing out removes it and any unsynced edits along with it.