App Icon
Chris Ingerson
•  86,571
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
Matthias Block
April 5, 2021
Hi! Works fine on MS Edge, but throws this exception on debug console on current version of chrome when clicking "vizualize". Default options, just selected current sheet. Uncaught at showCompilingMessage (ExportSheetData:2208) at exportJson (ExportSheetData:883)
Is this review helpful?
Yes
No
Profile Pciture
Chris Ingerson
April 11, 2021
Hmm, if it’s working fine on MS Edge my guess is this is related to the multiple accounts issue caused on Google’s end. If you have more than one account signed in, try logging out of all but one and running ESD.
Profile Pciture
Matthias Block
April 5, 2021
Sorry, Chrome version is: Version 89.0.4389.114 (Official Build) (64-bit)
Profile Picture
Sulaiman Gool
March 12, 2021
Thanks, Brilliant Works Perfectly and effortlessly
Is this review helpful?
Yes
No
Profile Picture
Tristin Harris
February 17, 2021
I think it's very cool 😎 and very very flexible
Is this review helpful?
Yes
No
Profile Picture
Trọng Nguyễn
January 14, 2021
The nested format is not very flexible but it's alright
Is this review helpful?
Yes
No
Profile Picture
Miles
January 8, 2021
Wow yeah this did exactly what I wanted it to do. Thanks!
Is this review helpful?
Yes
No
Profile Picture
Nebojsa Nedic
December 26, 2020
File that has 26K rows, it exported only few hundreds in JSON. Other than that, and the fact that you have to be logged in with only one account, it works fine :/... Hopefully you can fix this issue. All the best.
Is this review helpful?
Yes
No
Profile Pciture
Chris Ingerson
January 5, 2021
Thanks for using ESD! The missing JSON issue sounds like a key/field ID issue. If you have multiple rows starting with the same value, only the last row will be used due to JSON not supporting multiple fields with the same ID. If you are using nested elements, be sure to check out the documentation for more in depth info on what could be happening there! The account issue is, unfortunately, on Google's side and I cannot do much to work around it. You can have multiple accounts signed in, you'll just need to be mindful that Google will occasionally attempt to use the incorrect account to run ESD, which causes problems. If this happens, you just need to sign out of all but one account, after which you can sign back into your other accounts and use ESD just fine. I'm still looking into potential solutions for this on ESD's end, but is definitely a pretty frustrating usability issue for now.
Profile Picture
Clifton B
December 12, 2020
Super helpful, and it's become necessary for my work, but it rests to the default settings every time I open a new file, so it takes me some time to figure out how to get it back to how my team needs things formatted. If there were a way to save and recover settings, that would be ideal. Remembering each user's settings across all files would also be helpful. Also, the number of steps it takes from hitting Export to finally downloading the resulting file seems excessive, but that's a minor gripe. I use this tool to download files, so having it save them to my Drive folder first is a little messy, but the unused files aren't really bothering anyone.
Is this review helpful?
Yes
No
Profile Pciture
Chris Ingerson
December 20, 2020
Glad to hear ESD is proving useful to you! These are all good suggestions for quality of life improvements. Saving/loading settings has been a notable pain point for a while, complicated by the limited access Apps Script has to various files. I think I have an idea on how to support loading settings from templates or JSON blobs, but I need to develop the interface for it. I've just added a download button the export modal, reducing the number of clicks to download a file from 3 to 2 so that workflow feels a lot better. Those two things should be in the next version (v65). As for always creating a file on Drive, I'm toying with doing direct downloads from the visualize modal (without creating a file first) but that may not make it into the next release unless I'm reasonably satisfied with how it works.
Profile Picture
Samson Assefa
December 8, 2020
Samson Assefa Gebrehiwot
Is this review helpful?
Yes
No
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
1-10 of 66
Additional information
Chris Ingerson
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu