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.
Chris Ingerson
2,883 users
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
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.
Emma Wright
May 1, 2018
Hello Chris,
Thanks very much for this add on, it's extremely useful!
One thing I'm having trouble with however is exporting cells that have new lines in them. The json files export a "\n" in place of the carriage return, but it seems to break the json file and errors when I import it into After Effects. The way I've managed to make it work manually is to find and replace in notepad all instances of "\n" with "\\n" (and then reverse this process in AE).
Is there a way to export the json data using your add on with escaped instances of "\n" so it exports "\\n" instead? Or perhaps I'm missing something?
Many thanks
A user of Export Sheet Data
October 31, 2018
Ha! I had this same issue just now. I got around it by not including carriage returns in the sheet and instead noting them as ' / ', anything like that will do. I then just had my AE expression break the strings at ' / ' instead of '\n'
Tom Yam
April 16, 2018
Saves me tons of time.
Thanks for this great and ever evolving tool!
1-10 of 36
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