Chris Ingerson
•  25,235
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
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
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
Scott Farr
December 16, 2019
Great app !! How can this be used within a Sheets macro for automation?
Is this review helpful?
Yes
No
A user of Export Sheet Data
December 23, 2019
Glad to hear you are enjoying ESD! I have not tested automation yet, but I have added a method called "reexportFile()" that should export data using settings from the most recent export operation. You can look into creating your own automation using the reexportFile() method if you'd like a solution ASAP. Otherwise, support for automation is on the roadmap for ESD.
A User of Export Sheet Data
July 31, 2019
I have not once been able to use the add-on. It just hangs when you select to export.
Is this review helpful?
Yes
No
A user of Export Sheet Data
September 22, 2019
Sorry for the delayed response! What settings are you using? Would you be able to link an example sheet showing the problem?
A User of Export Sheet Data
June 11, 2019
Fantastic add-on that's rock solid! Chris, for my use case I'd like to export each sheets' tab individually with a specific filename for each tab. Would it be possible to define the filename format e.g. "%sheet_name%-%tab_name%" to get "myConfig-tab1"?
Is this review helpful?
Yes
No
A user of Export Sheet Data
June 24, 2019
Sorry for the delayed response, and glad ESD is working well for you so far! I can look into exporting each tab individually, as that does seem like a nice feature. Name formatting would probably come a little after that, so the default behavior would probably be how Sheets formats CSV files (ie "SheetName - TabName"). I'll put an issue up on GitHub about this a little later today.
A User of Export Sheet Data
May 17, 2019
great add-on. is "scheduler" possible yet? that will be very helpful, either via script, or other methods?
Is this review helpful?
Yes
No
A user of Export Sheet Data
May 25, 2019
Automated exports are still on the roadmap, but I don't have a clear delivery date on that particular feature. There are still a number of considerations for how to implement that system, including UI and export settings. To give you a sense of what to expect, there are two main features I'd like to implement before automation: Nested Element support for XML, and Export Folder Selection (so users can export their data somewhere other than the same folder as the spreadsheet). My work schedule has been pretty busy recently, so I haven't been able to get as much work done on ESD as I would like. Apologies for the delay in such anticipated features!
A User of Export Sheet Data
May 14, 2019
Array of objects? I was not able to find proper guidance in documentation.
Is this review helpful?
Yes
No
1-10 of 42
Additional information
Chris Ingerson
Privacy Policy
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu