CRX id
enmkalgdnmcaljdfkojckdbhkjmffmoa
enmkalgdnmcaljdfkojckdbhkjmffmoa
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
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
- (2025-08-26) Peter van der Zouwen: Doesn't work
- (2025-08-03) 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
- (2025-07-11) 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.
- (2025-06-01) Spencer Trumbore: This addon did exactly what it claimed it would and I'm thrilled. Thank you.
- (2025-05-02) Ahmad Subhan: Helpful tool, thank you. It converts sheet to json perfectly.
- (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) 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-03-06) Denis Ushankov: after last update always downloads first sheet instead of active. ruined.
- (2025-02-27) Griffin Brooks (Broskibble): Does exactly what I need, and exactly what it says
- (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.
- (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.
- (2025-01-18) Stan Géant: Does what it promises.
- (2024-12-15) 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
- (2024-12-06) Kerim: what a life saver, nice extension but the file name should be the table name i think
- (2024-11-06) 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.
- (2024-10-11) 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.
- (2024-10-04) 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 !!!
- (2024-09-16) Joseph Whale: It "works" but it will convert everything into strings which... isn't particularly useful
- (2024-09-13) Korutz: Doesn't work, nothing happens when clicking on its icon.
- (2024-08-16) Karol Pál: I felt like this extension deserves a higher ranking. It does one thing and it does it well. Useful.
- (2024-08-03) Andrea Giannoni: Exports everything as a string, so not quite useful
- (2024-07-18) meowyih1: Very simple, very easy to use, exactly what I need.
- (2024-06-24) 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.
- (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-06-06) 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
- (2024-05-08) Aleksandar Prlinčević: It worked great and saved me a lot of time
- (2024-05-06) Paulius N: It does not work with 10000 raws.
- (2024-04-23) Nguyễn Thị Trang: not working. pls fix it
- (2024-04-11) Puffed Rice Crackers: Works flawlessly! Thank you!
- (2024-03-18) Cezkarma Gaming: Works perfectly for me :) using Opera GX
- (2024-03-08) 구너구너: I would appreciate it if the name of the sheet could also be included in the name of the saved file.
- (2024-03-05) Florian Schmitt: Same problem as Jade White described
- (2024-02-17) Felipe César: It just doesn't work to me. I click and nothing happens
- (2024-02-12) MTG Dubina: Could you export smth like this { "Priority": ["High","Med","Low"] } with this plugin?
- (2024-02-11) Alzter: "JSON" button does nothing. Tried exporting a document's second sheet with about 200 rows - no JSON file downloaded.
- (2024-02-06) 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!
- (2024-01-31) Jamey Play: useful 👍👍👍
- (2023-12-12) Joran Freire: Good idea but not work. I tried in sheet with 16 columns and 3900 rows.
- (2023-12-08) В`ячеслав Дмитровський: Works fine! Thanks for this extension!
- (2023-11-25) Vlad Anisov: Great tool, very useful for any development purposes.
- (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-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.
- (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.
- (2023-06-29) Nate Tarasiuk: This makes downloading from Google sheets super easy!
- (2023-06-29) Nate Tarasiuk: This makes downloading from Google sheets super easy!