Convert a Google Sheet to JSON

How to convert a Google Sheet to JSON

The only requirement is that the sheet is readable by anyone with the link. Nothing else — no Google account, no credentials, no extension.

1. 1 In Google Sheets, click Share, then set General access to Anyone with the link (Viewer is enough). If you skip this, the tool cannot read the sheet — check whether yours is public.
2. 2 Copy the sheet URL from your browser's address bar. To use one specific tab, open that tab first so its gid ends up in the URL.
3. 3 Paste it above and hit convert. The first row is read as the field names; every row below becomes a JSON object.
4. 4 Copy the JSON, or download it as a .json file.

What the output looks like

A sheet with the columns name, role and active converts to an array of objects — one per row, keyed by the header row:

[
  {
    "name": "Ada Lovelace",
    "role": "Engineer",
    "active": "true"
  },
  {
    "name": "Grace Hopper",
    "role": "Admiral",
    "active": "true"
  }
]

Why not just use the Google Sheets API?

You can, and inside an existing Google Cloud project it may well be the right call. But for simply reading a sheet the setup cost is steep and almost entirely incidental: you need a Cloud project, then OAuth credentials or a service account, before the API returns a single row.

What comes back is not the shape you want either. Google's API is cell-oriented — you ask for a range like A1:D50 and get a grid of values. Turning that grid into records keyed by your header row is work you do yourself, every time.

This tool skips both. It reads the sheet's published CSV, treats the first row as field names, and hands you records. That is why it needs no key: it never touches Google's authenticated API at all.

A snapshot is not an API

What you get above is a snapshot: it reflects the sheet as it is right now. Edit a cell and the file you downloaded is out of date, and you run the conversion again. A PasteSheet endpoint is the same data at a URL that stays current — it re-reads the sheet on your schedule and serves whatever is in it now, so your app or AI agent never reads a stale export.

That endpoint is also a read-only MCP server, so Claude, Cursor or ChatGPT can query the sheet directly — filtered, sorted and paginated — instead of you pasting an export into the chat. See the REST API guide or the MCP guide.

What a live endpoint costs

Nothing, to start. The Free plan gives you 3 endpoints and 2,000 requests a month, with MCP included and no credit card. The tool above stays free and unlimited either way.

Frequently asked questions

Sources

• Authorize requests — Google Sheets API — Google
• Usage limits — Google Sheets API — Google
• Publish a file from Google Docs, Sheets, Slides or Forms — Google Docs Editors Help

Related tools