Sheets™ to JSON
Lets you to convert sheet rows to a custom JSON structure with various JSON types and options for download.
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.
Free Version Limitations:
Extract Up to 25 rows: The free version allows you to generate top 25 rows from your sheet.
* Google services impose daily quotas and hard limitations on some features - https://developers.google.com/apps-script/guides/services/quotas
Sheets™ 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.