Sheet to JSON / Google Workspace Add-on

Convert Google Sheets to JSON

Export spreadsheet rows as a JSON file, including nested objects, arrays, numbers, and booleans. Preview the result inside Google Sheets, then download it. No code required.

$7 one-time payment · Updates included

Keep the data in a sheet. Use it in your app.

Turn a product catalog, a contact list, or test data into structured JSON without rebuilding each object by hand.

Sheets to JSON is a Google Workspace add-on for file exports. It converts the active sheet into an array of objects or an array of arrays. It does not host a live JSON API or keep your app in sync with the spreadsheet.

From spreadsheet rows to nested JSON

Try a small product catalog before exporting your own data.

Each row becomes an object. A dot in a header creates a nested object; numbered brackets create an array.

Input: two products in Google Sheets
namepricecategory.nametags[0]tags[1]inStock
Notebook12Stationerypaperdesktrue
Pen3Stationeryinkdeskfalse

Choose Array of Objects and enable Infer data types for this output:

[
  {
    "name": "Notebook",
    "price": 12,
    "category": {
      "name": "Stationery"
    },
    "tags": [
      "paper",
      "desk"
    ],
    "inStock": true
  },
  {
    "name": "Pen",
    "price": 3,
    "category": {
      "name": "Stationery"
    },
    "tags": [
      "ink",
      "desk"
    ],
    "inStock": false
  }
]

Download the sample spreadsheet (.csv) and import it into Google Sheets to follow along.

Follow the Google Sheets to JSON export guide for setup, output formats, and troubleshooting.

Choose the JSON structure your app needs

Control the shape of your export with column headers and two output formats.

  • Two Output Formats

    Array of Objects or Array of Arrays. Choose what fits your needs.

  • Nested JSON

    Use dot notation in headers to create nested objects automatically.

  • Type Inference

    Automatically detects numbers, booleans, and dates.

  • Live Preview

    See your JSON output in real-time before downloading.

  • One-Click Download

    Export as .json instantly. No copy-pasting needed.

  • Array Support

    Use bracket notation in headers to create arrays.

How to export Google Sheets to JSON

  1. Install the add-on

    Add Sheets to JSON from Google Workspace Marketplace.

  2. Open the sidebar

    Put field names in the first row and one record on each row below. Open the add-on from Extensions → Sheets to JSON.

  3. Preview and download

    Choose Array of Objects or Array of Arrays, check the type inference setting, and review the preview before downloading your .json file.

Common questions

Can I convert Excel files?

Yes. Upload your Excel file to Google Sheets first, then use the add-on to convert.

Is my data secure?

JSON conversion runs locally in the Google Sheets environment. Spreadsheet content is not collected or stored by Sheets to JSON. Your email address is used to verify your license; see the privacy policy for details.

Can I export nested objects and arrays?

Yes. In Array of Objects mode, use headers such as address.city for nested objects, tags[0] for arrays, and items[0].name for arrays of objects. The export guide includes examples.

Does this turn my Google Sheet into a JSON API?

No. The add-on downloads a JSON file from the active sheet. Export again after editing your data. For a live connection, use the Google Sheets API or a separate hosted endpoint.

Can I export more than one tab?

Each export uses the active sheet. Switch tabs and export them separately.

Are updates included?

Yes. One-time payment of $7 includes all future updates and improvements.

Ready to transform your data?

Start converting spreadsheets to JSON today.