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:

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.



Terms of Service


1. Use of the Service

These Terms of Service ("Terms") govern your use of the 2json add-on for Google Sheets ("Service"). By accessing or using the Service, you agree to be bound by these Terms and Conditions of Service, all applicable laws and regulations, and agree that you are responsible for compliance with any applicable local laws. If you do not agree with any of these terms, you are prohibited from using or accessing this add-on. The materials contained in this add-on are protected by applicable copyright and trademark law.


2. Disclaimer

The 2json  add-on is provided "as is" and makes no warranties, expressed or implied, and hereby disclaims and negates all other warranties, including without limitation, implied warranties or conditions of merchantability, fitness for a particular purpose, or non-infringement of intellectual property or other violation of rights. 


3. Limitations

In no event shall the 2json developer(s) be liable for any damages (including, without limitation, damages for loss of data or profit, or due to business interruption,) arising out of the use or inability to use the 2json add-on, even if 2json developer(s) or 2json authorized representative(s) has been notified orally or in writing of the possibility of such damage. Because some jurisdictions do not allow limitations on implied warranties, or limitations of liability for consequential or incidental damages, these limitations may not apply to you.


4. Changes to the Terms

We reserve the right to update or modify these Terms at any time without prior notice. Any changes to the Terms will be effective immediately upon posting on this page. Your continued use of the Service after any such changes constitutes your acceptance of the revised Terms.


Privacy Policy

We are committed to protecting your privacy and ensuring the security of your data. This Privacy Policy outlines how we collect, use, and safeguard your information when you use our software.


1. Information We Collect

When you use the 2json add-on for Google Sheets, we do not collect any personal information or data from you. The add-on operates entirely within your Google Sheets environment and does not require any additional registration or account creation. We do not have access to your Google account credentials, nor do we store any data transmitted through the add-on.


2. Data Processing

All processing of your data occurs locally within your Google Sheets environment. The 2json add-on does not transmit or store your data on external servers. Your data remains securely within your Google Sheets document throughout the conversion process.


3. Data Storage and Transmission

We do not store or transmit your data anywhere outside of your Google Sheets document. Your data is processed solely within your Google Sheets environment, ensuring the utmost privacy and confidentiality.


4. Third-Party Services

The 2json add-on does not integrate with any third-party services or platforms. We do not share your data with any external parties, and we do not utilize any third-party analytics or tracking tools.


5. Security Measures

We employ industry-standard security measures to protect your data while using the 2json add-on. This includes using best practices for secure software development and regular updates to ensure the security of the add-on itself.


6. Children's Privacy

The 2json add-on is not directed towards children under the age of 13, and we do not knowingly collect any personal information from individuals under the age of 13. If you believe that we may have inadvertently collected personal information from a child under 13, please contact us immediately, and we will take appropriate steps to delete such information.


7. Changes to this Privacy Policy

We reserve the right to update or modify this Privacy Policy at any time. Any changes to the policy will be reflected on this page, and we encourage you to review this Privacy Policy periodically for any updates.


9. Consent

By using the 2json add-on for Google Sheets, you consent to the terms outlined in this Privacy Policy and agree to the processing of your data as described herein.

Data Usage Disclosure

2json add-on 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.