Sheets to JSON icon

Sheets to JSON

by ntarasiuk

v1.0.2 Updated Mar 12, 2026 187KiB
CWS
10K
Users
★ 3.67
60 reviews
#3026
of 113.4K
developer
#256 of 9.9K
Recently updated

Description

Sheet to JSON adds a lightweight JSON export button right into your Google Sheets toolbar. Click it, configure your options, and download perfectly formatted JSON in seconds. Why Sheet to JSON? - Works where you already are — no need to copy data into an external converter - Your data never leaves your browser. Everything is processed locally - Supports custom headers, nested objects via dot notation, type conversion, whitespace trimming, and empty row filtering - Exports the active sheet tab with the correct file name automatically Perfect for: Developers pulling mock data, teams maintaining config files in spreadsheets, analysts converting reports for APIs, or anyone who needs spreadsheet data as JSON without the hassle.
Sheets to JSON screenshot 1Sheets to JSON screenshot 2

Reviews (20 cached)

★☆☆☆☆2025-08-26
Peter van der Zouwen

Doesn't work

★☆☆☆☆2025-03-06
Bedilbek Khamidov

It worked flawlessly for such a long time I just forgot that this extension could be faulty. However, you disappointed me, after your latest changes and your fancy additions, now sheet selection doesn't work, it's exporting json every time for the first sheet

★☆☆☆☆2025-01-30
Chris Hefley

Doesn't appear to work. Installs in Chrome, but clicking it on a google sheet tab does nothing. Tried all the usual troubleshooting steps. Uninstalling.

★☆☆☆☆2024-09-13
Korutz

Doesn't work, nothing happens when clicking on its icon.

★☆☆☆☆2024-09-03
Ilya V

Doesn't work

★☆☆☆☆2024-06-20
Shawn Deprey

Just simply doesn't work at all. I get the following error: TypeError: Cannot read properties of undefined (reading 'split') at csvToJson (getJSON.js:32:16) at getJSON.js:113:28 csvToJson @ getJSON.js:32 (anonymous) @ getJSON.js:113 Promise.then (async) getJSON @ getJSON.js:112 Show 3 more frames Show lessUnderstand this error

★☆☆☆☆2024-06-18
E. O.

doesnt work, 3k rows. After click nothing happens

★☆☆☆☆2024-05-06
Paulius N

It does not work with 10000 raws.

★☆☆☆☆2024-02-17
Felipe César

It just doesn't work to me. I click and nothing happens

★☆☆☆☆2024-02-11
Alzter

"JSON" button does nothing. Tried exporting a document's second sheet with about 200 rows - no JSON file downloaded.

★☆☆☆☆2023-12-12
Joran Freire

Good idea but not work. I tried in sheet with 16 columns and 3900 rows.

★☆☆☆☆2023-11-14
Александр Радуль

Does not work.

★☆☆☆☆2023-10-23
Paul Hazard (appa561)

Same issue as another user - clicking extension icon does nothing... have first row as column headings

★☆☆☆☆2023-08-30
Michal Jareš

Doesn't work for me at all. The button shows but clicking it does nothing. Tried to click it when nothing selected or with some cells selected. I would love to give it a good review but it needs to work at all.

★★☆☆☆2025-03-08
Steven Price

Like others, recent update interfered with my use case. JSON file used to be created from whatever sheet tab is currently active. Now, it just uses the first tab, regardless of which tab is active. Please fix!

★★☆☆☆2025-03-06
Denis Ushankov

after last update always downloads first sheet instead of active. ruined.

★★★☆☆2026-03-09
Seva Medvedovskyi

It has a big issue - when I do not have access to a document your extension hides request access panel. Please fix asap

★★★☆☆2025-02-01
Egor Vinogradov

It did successfully export one of my spreadsheet but threw an error in the console when exporting the other one: getJSON.js:32 Uncaught (in promise) TypeError: Cannot read properties of undefined (reading 'split') at csvToJson (getJSON.js:32:16) at getJSON.js:113:28 For context: in my CSV I had string, numeric & json-as-string values. Maybe the error has to do something with quote marks or commas inside the cells.

★★★☆☆2024-09-16
Joseph Whale

It "works" but it will convert everything into strings which... isn't particularly useful

★★★☆☆2024-08-03
Andrea Giannoni

Exports everything as a string, so not quite useful

Details

Version 1.0.2
Updated Mar 12, 2026
Size 187KiB
First Seen Mar 27, 2026