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
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)
A User of Export Sheet Data
March 27, 2019
10/10 will use again
A User of Export Sheet Data
November 13, 2018
Any plans to support JSON boolean or null values?
ex. ("sale":true) or ("name":null)
Basically just allow export without quotes around the data value? Thanks.
1-10 of 38
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