Json Studio is a free open-source Google Sheets™ add-on built for developers. Prettify any JSON values in the selected range.
Listing updated:August 23, 2025
Works with:
25
Overview
This Google Sheets™ add-on allows users to format JSON values directly within their spreadsheets. It provides a user-friendly interface for working with JSON values, making it easier to manage and manipulate structured data.

If you are looking for a simple way to prettify or minify JSON values in your Google Sheets™ cell, this add-on is for you! 😉

Here are some common use cases for web developers and API consumers:

1) API Response Formatting: When working with APIs, the response data is often in JSON format. Json Studio allows you to format and manipulate this data directly within Google Sheets™, making it easier to analyze and visualize.

2) Collaborative Data Editing: Json Studio enables multiple users to collaborate on JSON data within a Google Sheets™ environment. This is particularly useful for teams working on API integrations or data analysis projects.

3) Educational Purposes: Json Studio can be used as a teaching tool to help students understand JSON structure and data manipulation. It provides a hands-on approach to learning about APIs and data formats.

---

Support this project at  GitHub: https://github.com/ilanlal/ss-json-editor
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
Json Studio will ask for the permissions shown below. Learn more
Json Studio will need access to your Google account
This will allow Json Studio to :
View and manage spreadsheets that this application has been installed in
View your country, language, and timezone
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
No comments
Search
Clear search
Close search
Google apps
Main menu