App Icon
Chris Ingerson
•  58,248
Overview
Open source add-on for Google Sheets that allows users to export sheets as XML or JSON.
Export Sheet Data lets you export any Google Sheet document as a single XML or JSON file. No more downloading individual sheets as CSVs then compiling them later! The created XML or JSON can be viewed directly, or exported and stored as a new file in the same location as the original file.

The add on is open source and can be found on GitHub at:

github.com/Synthoid/ExportSheetData
Reviews
Language:
Sort by:
Profile Picture
Logan Jory
November 26, 2020
Echoing the below review: I tried it on a test sheet but nothing happens. Sidebar opens. Settings are set-able, Buttons are press-able. But nothing happens on any button press.
Is this review helpful?
Yes
No
Profile Pciture
Chris Ingerson
November 27, 2020
Sorry to hear that you are having issues! I've just pushed a new version with several added safety checks to catch any unexpected errors and help suggest potential fixes. The most common cause for your particular issue is having multiple accounts signed in at once. This is related to a bug in how Google handles add-on execution so there is little I can do to actually solve the issue. It can easily be fixed by signing out of all but one account, but that is an extra amount of frustration that users don't want to deal with. I'm still looking into good ways to handle this on my end, but for now signing out of all but one account should solve your problems!
Profile Picture
Prashant Sethi
November 19, 2020
Not working
Is this review helpful?
Yes
No
Profile Picture
Paul Otto
November 11, 2020
I tried it on a test sheet but nothing happens. Sidebar opens. Settings are set-able, Buttons are press-able. But nothing happens on any button press. Nothing more to report.
Is this review helpful?
Yes
No
Profile Pciture
Chris Ingerson
November 11, 2020
Hmm, a review noting nothing happens immediately after a review saying it works perfect. Fun times! You should at the very least see a compiling modal so it's interesting that nothing seems to happen. Do you have multiple accounts signed in? If so, does logging out of all but your primary account seem to fix the issue?
Profile Picture
Jaume Subirats
November 11, 2020
Works perfect! It's a very usefull and powerfull tool.
Is this review helpful?
Yes
No
Profile Picture
Alfonso Cruz Nombela
October 29, 2020
This works fantastic, thanks! It would be great to add a scheduler so it exports every defined period of time...
Is this review helpful?
Yes
No
Profile Pciture
Chris Ingerson
October 31, 2020
Glad you are enjoying ESD! Automation is on the roadmap but there are a few other features I’d like to finish up beforehand.
Profile Picture
Davendra Jayasingam
October 16, 2020
Fantastic tool! Saved me a lot of time. Works well and easy to pick up.
Is this review helpful?
Yes
No
Profile Picture
Lee Long Hui
September 24, 2020
It's showing a blank menu on Chrome. However, it does work on Firefox.
Is this review helpful?
Yes
No
Profile Pciture
Lee Long Hui
September 30, 2020
Yup, it works after I've signed out all but one account. Thanks for your help. But do note that it was working perfectly fine with multiple accounts signed in before this.
Profile Pciture
Chris Ingerson
September 29, 2020
Do you have multiple accounts signed in? If so, try logging out of all but one. Being logged into multiple accounts can cause a bug on Google’s side that breaks certain functionality.
Profile Picture
Cornerpuz Limited
September 9, 2020
Its not working anymore.
Is this review helpful?
Yes
No
Profile Pciture
Lee Long Hui
September 24, 2020
It's showing a blank menu on Chrome. However, it does work on Firefox.
Profile Pciture
Chris Ingerson
September 13, 2020
Would you be able to share an example sheet or describe your issue in more detail? Is the sidebar not appearing? Does exporting not finish? What are your settings? Any/all of that will help me debug the issue.
Profile Picture
A User of Export Sheet Data
July 6, 2020
Very useful tool! The only problem I am finding is that when you add a \ and you export the JSON, the \ is duplicated \\. Not sure how to get rid of it of if there is any chance
Is this review helpful?
Yes
No
Profile Pciture
A user of Export Sheet Data
July 11, 2020
Glad you find ESD helpful! Unfortunately backslashes ( \ ) are reserved characters in JSON and must be escaped by placing a second backslash ( \\ ) or malformed JSON will be created.
Profile Picture
A User of Export Sheet Data
June 17, 2020
good
Is this review helpful?
Yes
No
1-10 of 58
Additional information
Chris Ingerson
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu