Chris Ingerson
•  33,903
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:
A User of Export Sheet Data
May 28, 2020
Amazing Add-on
Is this review helpful?
Yes
No
A User of Export Sheet Data
May 26, 2020
This is working well in most cases. I'm having an issue where I'm toggling on "Nested Elements" because I'm using the feature on one of my sheets, but enabling it messes with another sheet that is supposed to export as an array object. Can we get a prefix to either: have "Nested Elements" ignore a sheet or tag a specific sheet as a "Export Sheet Arrays"?
Is this review helpful?
Yes
No
Josh B. James
May 13, 2020
Trying to export XML, and I am frustratingly close to having what I need. The first column always creates a CE which is messing me up.
Is this review helpful?
Yes
No
A User of Export Sheet Data
April 23, 2020
anyone have sample google sheets?
Is this review helpful?
Yes
No
A User of Export Sheet Data
April 22, 2020
Nice work, thanks
Is this review helpful?
Yes
No
A user of Export Sheet Data
April 26, 2020
Thanks! Glad you are enjoying ESD!
A User of Export Sheet Data
March 5, 2020
I am having the hardest time Understanding how to setup my JSON using this. I've been doing in manually and thought I finally found a solution but this isn't giving me the desired result. How would I set up some JSON (the rows and columns) that looks like this example?: { "steve": { "name": "Steve", "age": "29", "gender": "male", "moves": { "move 1": "chest", "move 2": "quest", "move 3": "obsesseed" } }, "pete": { "name": "Peter", "age": "32", "gender": "male" }, "sop": { "name": "Sophie", "age": "27", "gender": "female" } } UPDATE: It looks like there is simply a bug with Nested Elements. Anytime I try to use nested elements it only exports the last row unless I put the contents into an array.
Is this review helpful?
Yes
No
A user of Export Sheet Data
April 7, 2020
Same here. Please fix this bug. I don't want to add the extra index number.
A User of Export Sheet Data
March 5, 2020
This add-on makes my life so much easier, now if I want some simple data for a web app I can just throw it all into Google Sheets. Didn't expect much actual 'functionality' from it (e.g. being able to have arrays within cells) when I downloaded it but it does absolutely everything I need it to
Is this review helpful?
Yes
No
A User of Export Sheet Data
February 13, 2020
when are you planning to implement nested tags for XLM ? so far only can export 2-level deep structure. Awesome plugin! thank you
Is this review helpful?
Yes
No
A user of Export Sheet Data
February 26, 2020
Glad to hear you are enjoying ESD! There are a few smaller features I'd like to implement before adding XML Nested Elements. I'd also like to do some minor refactoring with how Nested Elements work in JSON, so this would probably be more of a Nested Elements 2.0 release than just adding XML support. Unfortunately I don't have a timeline on this currently.
A User of Export Sheet Data
January 29, 2020
This is the first time I use a google addon, it seems to be exactly what I needed and very well done. However I am still very reluctant to give full access of all my google drive to a third party company. Since this is open source anyway is there a way to just own it personally and not have to give the rights to view and delete my entire drive?
Is this review helpful?
Yes
No
A User of Export Sheet Data
January 10, 2020
Best converter I seen.
Is this review helpful?
Yes
No
1-10 of 47
Additional information
Chris Ingerson
Privacy Policy
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu