Sheets to JSON icon

Sheets to JSON

Extension Actions

CRX ID
enmkalgdnmcaljdfkojckdbhkjmffmoa
Status
  • Extension status: Featured
  • Live on Store
Description from extension meta

Easily download your Google Sheets data as JSON files. Perfect for integrating with other applications or storing your data in a…

Image from store
Sheets to JSON
Description from store

Easily download your Google Sheets data as JSON files.
Perfect for integrating with other applications or storing your data in a more portable format.

🎉🎉🎉 New Update! 🎉🎉🎉
Now you can customize your JSON export

Features
• Flexible CSV Parsing Options:
The conversion function supports a wide range of options:
• noheader: Treat the CSV as having no header row.
• headers: Supply custom headers when the CSV doesn’t include one.
• trim: Remove leading and trailing whitespace from each value.
• checkType: Automatically convert string values into appropriate types (numbers, booleans, etc.).
• ignoreEmpty: Skip empty rows during parsing.
• delimiter: Use a custom delimiter (default is a comma).
• nest: Generate nested JSON objects when CSV headers use dot‑notation (e.g. person.name).
• Nested JSON Structure:
If enabled, CSV headers with dot‑notation (like person.name) will be converted into nested JSON objects. This is especially useful for organizing complex data.

How to use:
Just click the "JSON" button in the toolbar in sheet you want to download.
The JSON file will be saved to your computer.

Troubleshooting:
Make sure your first row is a header row with header names or it may not work.
* This extension isn't meant to convert a complicated sheet, just a simple sheet with headers and row data.

If you like it, please rate it 5 stars! :)

Latest reviews

Peter van der Zouwen
Doesn't work
Pierre Dumas
Great! Saves me a lot of time. I always use it like that: 1) click "download json", 2) open json in notepad++, 3) select all, 4) Ctrl-C, 5) paste in vscode Suggestion: add button "copy json". 1) click "copy json" 2) paste in vscode
Ken Nakai
Does a great job. Just has bugs here and there. @dev If you attempt to access a sheet that you don't have access to yet (you get the "Access Denied" screen), you're modifying the page such that you can't see the UI to request access any more. Just a big JSON button along the left side of the page.
Spencer Trumbore
This addon did exactly what it claimed it would and I'm thrilled. Thank you.
Ahmad Subhan
Helpful tool, thank you. It converts sheet to json perfectly.
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!
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
Denis Ushankov
after last update always downloads first sheet instead of active. ruined.
Griffin Brooks (Broskibble)
Does exactly what I need, and exactly what it says
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.
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.
Stan Géant
Does what it promises.
Nour Homsi
It does exactly what it says. I would suggest more improvments to the extension like: - adding the ability to export data based on columns in addition to rows - multilevels json tree
Kerim
what a life saver, nice extension but the file name should be the table name i think
Gaoqiang Zheng
Perfect. Save me a lot of time to import data from a sheet to my program. Thank you. I also check the source code of this plugin. Clean and safe.
Himanshu Agarwal
Perfect if all your data is in string format. For numbers you can write a little extra code and parse it so i dont see any issues with the way the extension works. Its perfect.
cuddlewuffle
not sure why everyone is saying it doesn't work? this is perfect for my purposes, works perfectly for me, thank you so much !!!
Joseph Whale
It "works" but it will convert everything into strings which... isn't particularly useful
Korutz
Doesn't work, nothing happens when clicking on its icon.
Ilya V
Doesn't work
Karol Pál
I felt like this extension deserves a higher ranking. It does one thing and it does it well. Useful.
Andrea Giannoni
Exports everything as a string, so not quite useful
meowyih1
Very simple, very easy to use, exactly what I need.
Oleksii Popovskyi
This extension is simple and it works. Downloads all data from sheet as JSON file. But it isn't possible to configure it. There is add-on to convert sheets 2json with more options.
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
E. O.
doesnt work, 3k rows. After click nothing happens
Joseph Adariku
Beautiful been stressing myself throughout how to find a solution thanks for this mate pls make it so we can convert a large number of sheet duplicates not just one but all
Aleksandar Prlinčević
It worked great and saved me a lot of time
Paulius N
It does not work with 10000 raws.
Nguyễn Thị Trang
not working. pls fix it
Puffed Rice Crackers
Works flawlessly! Thank you!
Cezkarma Gaming
Works perfectly for me :) using Opera GX
구너구너
I would appreciate it if the name of the sheet could also be included in the name of the saved file.
Florian Schmitt
Same problem as Jade White described
Felipe César
It just doesn't work to me. I click and nothing happens
MTG Dubina
Could you export smth like this { "Priority": ["High","Med","Low"] } with this plugin?
Alzter
"JSON" button does nothing. Tried exporting a document's second sheet with about 200 rows - no JSON file downloaded.
Will Shaw
I'm using Sheets to generate/manage game data. Having the option to save to JSON has made the process much more flexible for me. Thanks for the plugin, it works great!
Jamey Play
useful 👍👍👍
Joran Freire
Good idea but not work. I tried in sheet with 16 columns and 3900 rows.
В`ячеслав Дмитровський
Works fine! Thanks for this extension!
Vlad Anisov
Great tool, very useful for any development purposes.
Александр Радуль
Does not work.
Paul Hazard (appa561)
Same issue as another user - clicking extension icon does nothing... have first row as column headings
Paul Hazard (appa561)
Same issue as another user - clicking extension icon does nothing... have first row as column headings
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.
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.
Nate Tarasiuk
This makes downloading from Google sheets super easy!
Nate Tarasiuk
This makes downloading from Google sheets super easy!