Lets you to convert sheet rows to a custom JSON structure with various JSON types and options for download.
Listing updated:October 22, 2024
Works with:
5K+
Overview
The add-on allows you to convert Google Sheets rows into both custom and standard JSON structures. It provides various JSON types and options for downloading your data.

Features:
- Sheet Selection:
  - Choose the Google Sheet worksheet you want to transform into JSON effortlessly. The addon seamlessly integrates into your Sheets™ workspace, allowing you to pick your desired sheet with just a few clicks.
- Select Range (Data or Custom Range):
  - Customize the range of data you want to export as JSON. Whether you need the entire sheet or a specific subset, Sheet™ to JSON offers the flexibility to choose the range that suits your needs.
- Type - Values of Sheet or Display Values of Sheet:
  - Tailor your JSON output by selecting whether you want to capture the raw values of the sheet or the displayed values. This option ensures that the exported JSON aligns perfectly with your intended data representation.

JSON Output Options:
- Object of Rows: Structure your JSON output as an object with each row represented as a key-value pair.
- Object of Columns: Organize your JSON output as an object with each column represented as a key-value pair.
- Array of Rows: Generate a JSON array with each row as a separate element.
- Array of Columns: Create a JSON array with each column as a separate element.
- Simple Key Pair: Condense your JSON output into a simple key-value pair format.
- 2D Array: Export your data as a two-dimensional array in JSON format.
- Define a Custom JSON Structure: Exercise complete control by defining a custom JSON structure directly from your Google Sheets™ workbook cells.

Sheet™ to JSON also provides a convenient preview option, allowing you to inspect the JSON output directly within the Google Sheets™ interface. Once satisfied, you can choose to either view the JSON within Sheets™ or export it as a separate file stored in the same location as your original Google Sheet worksheet.

Popular use cases:
Google Sheets ™ JSON converter
Convert Google Sheets ™ to JSON
JSON export from Google Sheets ™
Export data from Sheets ™ to JSON
Google Sheets ™ to JSON API
JSON data structure from Sheets ™
Sheet to JSON integration
Custom JSON structures for Google Sheets ™
Download Google Sheets ™ as JSON
Google Sheets ™ data to JSON format
How to convert Sheets ™ rows to JSON
Export selected range as JSON from Sheets ™
Google Sheets ™ add-on for JSON
JSON output options in Google Sheets ™
Sheet data to JSON converter
Create JSON from Google Sheets ™ rows
JSON preview in Google Sheets ™
Google Sheets ™ JSON customization
Free JSON generator for Google Sheets ™
Limited rows JSON export from Sheets ™
Simple key-value JSON from Sheets ™
Custom JSON format for Google Sheets ™ data
Google Sheets ™ to API JSON format
JSON data transformation in Sheets ™
Google Sheets ™ productivity tools
JSON structure customization in Google Sheets ™
Export Google Sheets ™ data to web applications
Convert spreadSheets ™ to JSON format
Generate JSON from Google Sheets ™ with ease

Free Version Limitations:
- Extract Up to 25 rows: The free version allows you to generate top 25 rows from your sheet.

Video help: https://youtu.be/qukAmU-JIz0

* Google services impose daily quotas and hard limitations on some features - https://developers.google.com/apps-script/guides/services/quotas
Sheet™ to JSON use and transfer of information received from Google APIs to any other app will adhere to Google API Services User Data Policy, including the Limited Use requirements.
Additional information
PricingFree of charge with paid features
Developer
Privacy policy
Terms of service
Sheets™ to JSON will ask for the permissions shown below. Learn more
Sheets™ to JSON will need access to your Google account
This will allow Sheets™ to JSON to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Gaurab Thapa
November 15, 2024
Complicated to use
Is this review helpful?
Yes
No
Profile Picture
Anony Dee
November 11, 2023
This is an excellent add-on. It has a 25 row demo which is sufficient to prove its functions. The price is just 6 USD per year (dont think its monthly). Thanks to developer for this amazing product. I love it
Is this review helpful?
Yes
No
Profile Picture
Brian Reidy
October 30, 2023
If you have a tiny file you can not use this without paying. <25 rows or less at that point you might as well just make the json yourself.
Is this review helpful?
Yes
No
Profile Picture
giubertpractice none
October 4, 2023
Unless you have a tiny file you can not use this without paying.
Is this review helpful?
Yes
No
Profile Picture
Dmitry Politov
June 12, 2024
25 rows limit
Is this review helpful?
Yes
No
Profile Picture
Stephen M
June 3, 2023
Kick butt app. Covers a range of scenarios, very flexible and intuitive. Helped me a lot!
Is this review helpful?
Yes
No
1-6 of 6
Search
Clear search
Close search
Google apps
Main menu