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.
| name | price | category.name | tags[0] | tags[1] | inStock |
|---|---|---|---|---|---|
| Notebook | 12 | Stationery | paper | desk | true |
| Pen | 3 | Stationery | ink | desk | false |
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
Install the add-on
Add Sheets to JSON from Google Workspace Marketplace.
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.
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.