Recommended for G SuiteWorks with Google DriveWorks with GmailWorks with CalendarWorks with DocsWorks with SheetsWorks with SlidesWorks with Forms
Help & Support
Send Feedback
Export Sheet Data
Open source add-on for Google Sheets that allows users to export individual tabs or entire spreadsheets as XML or JSON.
Works with
Install
Overview
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
English (United States)
All languages
Recent
Helpful
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
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?
A User of Export Sheet Data
January 10, 2020
Best converter I seen.
Scott Farr
December 16, 2019
Great app !! How can this be used within a Sheets macro for automation?
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.
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"?
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?
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.
A User of Export Sheet Data
April 25, 2019
Absolutely LOVE this extension! Has solved SO many problems at work. Quick question though. I used to be able to add key formatting to objects i.e. ESD used to export "home-nav-cart" : {
"id (developers only)" : "home-nav-cart",
"badge-id" : "0c",
"description" : "",
"us" : "Cart",
"jp" : "カート",
"de" : "Einkaufswagen",
"mx" : "Carrito",
"uk" : "Cart",
},
but now I can't get the "home-nav-cart" key for the object: :
{
"id (developers only)" : "home-nav-cart",
"badge-id" : "0c",
"description" : "",
"us" : "Cart",
"jp" : "カート",
"de" : "Einkaufswagen",
"mx" : "Carrito",
"uk" : "Cart",
},
From what I've read it's something to do with the Nested Elements checkbox, but I couldn't export the example Planets file to see what that notation was exporting. Still love the extension though! Many many thanks!
A User of Export Sheet Data
April 17, 2019
Very helpful add-on !
So...I'm trying to figure out what my Google Sheet should look like and if I want my JSON export to look like this example:
[
["2010", 30, "red", 40 , "blue"],
["2011", 50, "red", 60, "blue"],
["2012", 70, "red", 80, "blue"]
]
A user of Export Sheet Data
April 19, 2019
Glad to hear you're enjoying ESD!
Is that what you want your whole JSON blob to look like, or just one sheet? If its the former, you could get away with enabling "Export value arrays" and "Export contents as array" then having a single column sheet for each array in your example.
If you want this to just be the data for one sheet in the total export, you'll have to look into nested elements. (I haven't tried nested arrays before, so I'm not sure off the top of my head if it will work as expected. If not, I'll add an issue on GitHub for it)
1-10 of 40
Additional information
Recommended for G Suite
Most Popular
Top Rated
Works with Google Drive
Works with Gmail
Works with Calendar
Works with Docs
Works with Sheets
Works with Slides
Works with Forms
Communication
Utilities
Productivity
Creative Tools
Web Development
Office Applications
Task Management
Education
Academic Resources
Teacher & Admin Tools
Search
Clear search
Close search
Google apps
Main menu