Lets you to convert sheet rows to a custom JSON structure with various JSON types and options for download.
рдмрдирд╛рдиреЗ рд╡рд╛рд▓реА рдХрдВрдкрдиреА:
рд▓рд┐рд╕реНрдЯрд┐рдВрдЧ рдХреЛ рдкрд┐рдЫрд▓реА рдмрд╛рд░ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛:22 рдЕрдХреНрдЯреВрдмрд░ 2024
рдЗрдирдХреЗ рд╕рд╛рде рдХрд╛рдо рдХрд░рддрд╛ рд╣реИ:
10┬ард╣рдЬрд╝рд╛рд░+
рдЕрд╡рд▓реЛрдХрди
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.
рдЕрддрд┐рд░рд┐рдХреНрдд рдЬрд╛рдирдХрд╛рд░реА
рдХреАрдорддрдЗрд╕ рдСрдлрд╝рд░ рдореЗрдВ рдХреБрдЫ рд╕реБрд╡рд┐рдзрд╛рдПрдВ рдмрд┐рдирд╛ рдХрд┐рд╕реА рд╢реБрд▓реНрдХ рдХреЗ рдЙрдкрд▓рдмреНрдз рд╣реИрдВ, рдЬрдмрдХрд┐ рдХреБрдЫ рд╕реБрд╡рд┐рдзрд╛рдУрдВ рдХреЗ рд▓рд┐рдП рдкреИрд╕реЗ рдЪреБрдХрд╛рдиреЗ рд╣реЛрдВрдЧреЗ
рдбреЗрд╡рд▓рдкрд░
рд╕реЗрд╡рд╛ рдХреА рд╢рд░реНрддреЗрдВ
SheetsтДв to JSON рдиреАрдЪреЗ рджреА рдЧрдИ рдЕрдиреБрдорддрд┐рдпреЛрдВ рдХреЗ рдРрдХреНрд╕реЗрд╕ рдХрд╛ рдЕрдиреБрд░реЛрдз рдХрд░реЗрдЧрд╛. реЫреНрдпрд╛рджрд╛ рдЬрд╛рдиреЗрдВ
SheetsтДв to JSON рдХреЛ рдЖрдкрдХреЗ Google рдЦрд╛рддреЗ рдХреЗ рдРрдХреНрд╕реЗрд╕ рдХреА рдЬрд╝рд░реВрд░рдд рд╣реЛрдЧреА
рдЗрд╕рд╕реЗ SheetsтДв to JSON рдХреЗ рджрд╛рдпрд░реЗ рдореЗрдВ рдпреЗ рдЕрдиреБрдорддрд┐рдпрд╛рдВ рднреА рд╢рд╛рдорд┐рд▓ рд╣реЛ рдЬрд╛рдПрдВрдЧреА :
рдЖрдкрдХреА рд╕рднреА Google Sheets рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯ рджреЗрдЦрдирд╛, рдЙрдирдореЗрдВ рдмрджрд▓рд╛рд╡ рдХрд░рдирд╛, рдирдИ рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯ рдмрдирд╛рдирд╛, рдФрд░ рдЙрдиреНрд╣реЗрдВ рдорд┐рдЯрд╛рдирд╛
Google рдРрдкреНрд▓рд┐рдХреЗрд╢рди рдореЗрдВ рдкреНрд░реЙрдореНрдкреНрдЯ рдФрд░ рд╕рд╛рдЗрдбрдмрд╛рд░ рдореЗрдВ рддреАрд╕рд░реЗ рдкрдХреНрд╖ рдХрд╛ рд╡реЗрдм рдХреЙрдиреНрдЯреЗрдВрдЯ рджрд┐рдЦрд╛рдПрдВ рдФрд░ рдЪрд▓рд╛рдПрдВ
рдЖрдкрдХреЗ Google рдЦрд╛рддреЗ рдХрд╛ рдореБрдЦреНрдп рдИрдореЗрд▓ рдкрддрд╛ рджреЗрдЦрдирд╛
рд╕реЛрд╢рд▓ рдореАрдбрд┐рдпрд╛ рдкрд░ рджреА рдЧрдИ рдХрд┐рд╕реА рднреА рдЬрд╛рдирдХрд╛рд░реА рдХреЗ рд╕рд╛рде, рдЕрдкрдиреА рдирд┐рдЬреА рдЬрд╛рдирдХрд╛рд░реА рджреЗрдЦреЗрдВ
рд╕рдореАрдХреНрд╖рд╛рдПрдВ
рднрд╛рд╖рд╛:
рдЗрд╕ рдХреНрд░рдо рдореЗрдВ рд▓рдЧрд╛рдПрдВ:
Google, рд╕рдореАрдХреНрд╖рд╛рдУрдВ рдпрд╛ рд░реЗрдЯрд┐рдВрдЧ рдХреА рдкреБрд╖реНрдЯрд┐ рдирд╣реАрдВ рдХрд░рддрд╛. рд╕рдореАрдХреНрд╖рд╛рдУрдВ рдХреЗ рдмрд╛рд░реЗ рдореЗрдВ реЫреНрдпрд╛рджрд╛ рдЬрд╛рдиреЗрдВ
рдХреЛрдИ рдЯрд┐рдкреНрдкрдгрд┐рдпрд╛рдВ рдирд╣реАрдВ
рдЦреЛрдЬреЗрдВ
рдЦреЛрдЬ рд╣рдЯрд╛рдПрдВ
рдЦреЛрдЬ рдмрдВрдж рдХрд░реЗрдВ
Google рдРрдк
рдореБрдЦреНрдп рдореЗрдиреНрдпреВ