Welcome to 2json, the quick and simple solution for generating JSON from your data in Google Sheets™! With 2json, you can effortlessly convert your spreadsheet data into JSON format, making it easy to integrate with other applications and systems. Whether you're a developer, QA engineer, data analyst, or spreadsheet enthusiast, 2json streamlines the process, saving you time and effort.

Main Features 
Effortless Conversion
Seamlessly convert your Google Sheets™ data into JSON format with just a few clicks.

Flexible Selection:
Select your data with flexibility:

Choose entire rows or columns.
Select continuous or non-contiguous ranges.

Customizable Output
Choose between using the actual values or display values of the selected cells in the generated JSON.

Interactive Window
Choose the location of keys, the appropriate cell values, review, download, and copy the generated JSON in an interactive window.

User-Friendly Interface
Intuitive and easy-to-use interface makes generating JSON from your data a breeze.

Versatile Applications
Use the generated JSON in various applications, including web development, data interchange, and more.

With its simplicity and versatility, 2json empowers you to efficiently convert your Google Sheets™ data into JSON for seamless integration into your projects.

Smart Handling of "null" Values
"null" values within your data are automatically converted into JSON null during the conversion process. This ensures that your JSON output accurately reflects the presence of null values in the original dataset.

Automatic Removal of Rows/Columns with Empty Cells
Empty rows/columns are intelligently detected and removed before JSON generation. This helps maintain the integrity of your data structure and prevents unnecessary inclusion of empty cells in the JSON output.

Flexible Range Selection
Select ranges in any order, and rest assured that they will be sorted correctly by the add-on. Whether you choose continuous or non-contiguous ranges, the add-on intelligently organizes and processes your selected data for seamless JSON generation.

Dynamic Key Extraction
Keys are extracted from the not empty top row or left column of your selected data to use as keys in the generated JSON. This dynamic key extraction feature simplifies the JSON generation process and ensures that your JSON output aligns with the structure of your Google Sheets™ data.

Data Safety and Privacy
Your data security is our priority. 2json add-on does not store or transmit your data anywhere. All processing occurs locally within your Google Sheets™ environment, ensuring the utmost privacy and confidentiality for your information.

These core features of the 2json add-on streamline the JSON generation process and empower users to efficiently convert their Google Sheets™ data into structured JSON format.

Google Sheets™ is a trademark of Google LLC