Sheet to JSON simplifies transforming Google Sheets™ into JSON files, with multiple JSON types and custom JSON options.
开发者:
应用详情更新日期:2024年6月13日
适用于:
3766+
概览
Sheet™ to JSON Add-On for Google Workspace Sheets™: Transforming Data with Ease
Introducing Sheet™ to JSON, a powerful Google Workspace add-on designed to streamline the conversion of your Google Sheets™ data into JSON files effortlessly. No longer will you need to navigate the cumbersome process of downloading individual Sheets™ as CSVs and piecing them together later. Sheet to JSON simplifies this task, offering a range of options to customise your JSON output and providing the flexibility to define a custom JSON structure directly from your Google Sheets™ workbook cells.
The user-friendly interface of Sheet™ to JSON ensures a seamless experience. The addon presents users with a set of options to tailor the JSON output according to their specific requirements:
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.
The Sheet™ to JSON add-on is designed to enhance your workflow, ensuring that the transformation from spreadsheet to JSON is both efficient and tailored to your needs. Additionally, for users who want to explore the capabilities of the add-on before committing to a premium plan, the free version is available with a few limitations, processing only up to 25 rows of sheet data.
In conclusion, Sheet™ to JSON is your go-to solution for seamlessly converting Google Sheets™ data into JSON files, offering a range of options and customization features to suit your unique needs. Simplify your data transformation process today with Sheet™ to JSON – where efficiency meets customisation.

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 表格中创建电子表格,以及查看、修改和删除您在 Google 表格中的所有电子表格
在 Google 应用的提示和边栏中显示和运行第三方网页内容
查看您的 Google 账号的主电子邮件地址
查看您的个人信息,包括您已公开的任何个人信息
评价
语言:
排序依据:
Google 不会核实评价或评分。 详细了解评价
没有评论
搜索
清除搜索内容
关闭搜索框
Google 应用
主菜单