Seamlessly convert your Google Sheets data into JSON format with just a few clicks.
Select your data with flexibility:
Choose between using the actual values or display values of the selected cells in the generated JSON.
Choose the location of keys, the appropriate cell values, review, download, and copy the generated JSON in an interactive window.
Intuitive and easy-to-use interface makes generating JSON from your data a breeze.
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.
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.
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.
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.