GSHEET File Documentation

Summary

A .gsheet file is not a spreadsheet. It is a Google Drive Spreadsheet shortcut: a tiny UTF-8 JSON file, a few hundred bytes, that points to a spreadsheet stored online in Google Sheets. The cells and formulas live in Google’s cloud, not in the file. Double-clicking it opens that spreadsheet in your browser, and only if you are signed in to a Google account with access. You cannot open or convert it offline; its cloud MIME type is application/vnd.google-apps.spreadsheet.

Technical details

FeatureValue
Full nameGoogle Drive Spreadsheet (shortcut to a Google Sheets spreadsheet)
File extension.gsheet
What it isA tiny JSON pointer / shortcut — not the spreadsheet itself
Cloud MIME typeapplication/vnd.google-apps.spreadsheet
Format typePlain UTF-8 JSON text
Typical sizeA few hundred bytes
Contains dataNo — only a link; the cells live in Google’s cloud
DeveloperGoogle
Created byGoogle Drive for desktop (formerly Backup and Sync), since ~2017
Key JSON fieldsurl, doc_id / resource_id, email
Opens withDefault browser → Google Sheets (signed in)
Works offlineNo — needs internet and the owning Google account
Export the real dataOpen in Google Sheets → File → Download (XLSX, CSV, ODS, PDF)
Related extensions.gdoc, .gslides, .gdraw, .gform, .xlsx, .csv
Open standardNo
SpecificationGoogle Drive Help

What is a GSHEET file?

A .gsheet file is a Google Drive Spreadsheet shortcut. It is not a spreadsheet and it does not contain a spreadsheet: it is a small pointer file, written by Google Drive’s desktop sync client, that links to a Google Sheets document living in Google’s cloud. Google introduced these placeholder files with the desktop sync clients around 2017 (Backup and Sync, now Google Drive for desktop). The same mechanism produces .gdoc for Docs, .gslides for Slides, .gdraw for Drawings and .gform for Forms.

The reason the file exists at all is that native Google Sheets documents have no ordinary local file. When Drive syncs a folder to your computer, most files download as real bytes, but a cloud-native spreadsheet has no downloadable local form. So Drive writes a tiny stand-in instead: a JSON file whose only job is to reopen the cloud document in a browser. Understanding that single fact answers almost every question people have about .gsheet files.

The JSON pointer, field by field

A .gsheet is plain UTF-8 text, usually only a few hundred bytes, and it is fully human-readable. Open it in Notepad or any editor and you see a single JSON object rather than any grid of cells. Its structure is roughly this:

{
  "url": "https://docs.google.com/spreadsheets/d/<doc-id>/edit",
  "doc_id": "<doc-id>",
  "email": "you@example.com"
}

Three pieces carry the meaning. url is the docs.google.com/spreadsheets address that a browser opens. doc_id (sometimes resource_id) is the spreadsheet’s unique Google Drive identifier, the same opaque string embedded in the URL. email records the Google account the synced file belongs to, which is why the file opens the document only when you are signed in to that account. There are no cells, no formulas, no charts and no sheet tabs anywhere in the file, because none of that is stored locally.

What happens when you double-click one

Double-clicking a .gsheet does not launch a spreadsheet program. Google Drive for desktop registers the extension so that opening the file hands the url to your default browser, which loads the live spreadsheet in Google Sheets. If you are not signed in to the account named in email, or that account has no access, Google prompts you to sign in or shows a permission error. Nothing is rendered from the file itself; the file is only the address.

This has consequences that surprise people. Email a .gsheet to a colleague and they get the shortcut, not the data; it opens nothing for them unless they already have access to that spreadsheet in Drive. Copy .gsheet files to a USB stick or a second computer and they stop working, because you copied pointers, not documents. Go offline and there is nothing to open at all. A .gsheet behaves exactly like a web shortcut, because that is what it is.

Getting the real spreadsheet data out

Because there is no spreadsheet inside the file, there is nothing to convert locally, and any “.gsheet to XLSX converter” tool is selling something that cannot work — the data is not in the file. To get a real, portable copy you go to the source. Open the spreadsheet through the shortcut (or straight from Google Drive), then in Google Sheets use File → Download and pick a format: Microsoft Excel .xlsx, .csv (current tab only), OpenDocument .ods, .pdf, TSV or HTML. That export is generated in the cloud from the actual cells and is the file you keep, email or use offline.

The same applies to sharing. Because the .gsheet is only a link tied to an account, sending it does not grant access. To share the spreadsheet, share it inside Google Drive (Share, then add the person’s email or create a link), or download an .xlsx/.csv and send that instead.

FAQ

Because it is a shortcut, not the spreadsheet. The cells and formulas live online in Google Sheets; the file stores only a JSON link (url, doc_id, email) to them. Opening it in a signed-in browser shows the real spreadsheet.

Can I open a GSHEET without internet?

No. The spreadsheet is stored in Google’s cloud and the .gsheet only points to it. Without internet access and the right Google account there is nothing to open. Download an .xlsx or .csv copy beforehand for offline use.

References