Export a Google Sheet to JSON. Process it with AI workflows. Then import it back as a new tab in any Google Sheet with full formatting retained.
Screenshot here
Runs entirely inside Google Sheets. Your data never touches a third-party server.
Source-visible under the Code Transparency license. Review every line at GitHub.
We welcome fixes, features, and security reviews. Contribute.
Export structured JSON for Claude, ChatGPT, Gemini, MCP servers, and automation tools that handle JSON better than CSV.
Preserve values, formulas, formatting, validations, dimensions, and named ranges when exporting/importing tabs.
Use a simple panel in Google Sheets for export/import, JSON staging, and activity history.
Export to JSON and import back with formatting, formulas, validations, dimensions, and named ranges reapplied.
Exports the active tab as-is for reliable, repeatable outputs with no hidden per-range filtering rules.
Import/export from local files or Google Drive directly from the sidebar.
Install gsheet2json from Google Workspace Marketplace: https://g2j.in.
In Google Sheets, go to Extensions > gsheet2json > Open.
Use the side panel to export the active tab to JSON, or import JSON into any Google Sheet to create a new tab with fully formatted sheet data.
We built gsheet2json because spreadsheet data should be easy to move into AI and automation workflows. Export/import JSON with full tab fidelity, then feed the output into LLM prompts, MCP tools, agents, scripts, and pipelines.
View All ReleasesGet updates on new features and releases. We won't spam you.
We respect your privacy. Unsubscribe anytime.
Install from Google Workspace Marketplace, then export/import sheet tabs as JSON from a lightweight sidebar in Google Sheets.
Yes. gsheet2json is free to use, and the source code is available to inspect under the Code Transparency license.
No. gsheet2json runs in Google Sheets with no separate server or API backend to manage.
Values, formulas, formatting, data validations, row/column dimensions, and named ranges are preserved and reapplied.
We always save files and tabs with unique names so we never overwrite existing content. You can rename them right after they're created.
Local file download/upload and Google Drive import/export are supported in-app.
Install from Marketplace, then open from Extensions > gsheet2json > Open. See Quick Start above.
Need help? We're here for you.
We're always looking for partners. Contact us at invest@gsheet2json.com to find out more.
