App Icon
Open source add-on for Google Sheets that allows users to export sheets as XML or JSON.
Works with:
93,735
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
Additional information
Privacy policy
Terms of service
Export Sheet Data will ask for the permissions shown below. Learn more
Export Sheet Data will need access to your Google account
This will allow Export Sheet Data to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Export Sheet Data
March 1, 2016
I really wish there is an option that if a cell has format like this "{.....}", consider this cell as an JSON object and will not quote the string in this cell. Wondering if it is possible to add this feature? Thx! = )
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
August 8, 2017
Works as promised. Saves me a bunch of time on potential error proofing of XML code. Any way to allow " in element names? I need to add a parmalink="true" to one of my XML child elements.
Is this review helpful?
Yes
No
Profile Picture
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!
Is this review helpful?
Yes
No
Profile Picture
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
Is this review helpful?
Yes
No
Profile Picture
Daniel Rodríguez Ycaza
April 20, 2016
Hi! great add-on! I'm stuck on trying to create a sub-child output for XML, any ideas? I have columns A to L which are part of a child, that comes out perfect, now, I need columns F to J to be a sub-child, how do you do that? Thanks!
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
January 29, 2018
Hey Chris, Great work! I love the add-on. However after the last update (v40 I believe). I couldn't export out the same result as before. It seems that when export either the integer or decimal value instead of showing original values -- it's not being put into a string. I have this sheet for reference. https://docs.google.com/spreadsheets/d/1le9azO5adYY4ADSaNJCHbQahRzlad1VlER5L-QFQnaw/edit?usp=sharing Before the last update I was a able to get the output to this with 'Export cell array' and 'Export sheet array' { "contacts": [ { "name": "John Smith", "address": "Thomas L Berkley Way", "city": "Oakland", "state": "CA", "zip": "94612", "coordinates": [ 37.8092391, -122.26871189999997 ] } ] } But now... I get this result (Notice how in the coordinates, it's has the "" as opposed to just being rendered as a decimal) { "contacts": [ { "name": "John Smith", "address": "Thomas L Berkley Way", "city": "Oakland", "state": "CA", "zip": "94612", "coordinates": [ "37.8092391", "-122.26871189999997" ] } ] } Is there anyway to get the values to render as a seminal when within the [ ] ? Thanks so much in advance Chris!
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
August 10, 2016
Pretty awesome. I would however like it very much if it was possible to either make the "," a variable. So it is possible to make JSON arrays from fields that are not comma separated. But I would prefer a different solution to my problem. Which is to assign a column to be treated this way ("Export cell arrays") instead of the whole sheet. This would also allow for cells in these columns, that do not have a comma, to still be exported as an array, but with a single value.
Is this review helpful?
Yes
No
Profile Picture
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
Profile Picture
A User of Export Sheet Data
April 24, 2016
Excellent tool! I was previously exporting data as an XLS and then manually converting it into a format that I could then import into a database; this saves me a lot of manual effort. Any plans to add an option to choose which rows / columns to export? I am working with a shared sheet that includes some informational columns that are not needed in the final export, as well as some (annoying) rows that were included to separate the data. I can ignore these entries programmatically after conversion, but it would be super cool if I could just exclude them from the export to begin with. :)
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
September 28, 2016
Love it so far. I also would like to be able to ignore certain data. As a simple solution I think you could add an option similar to: Export cells in columns with prefix as array: Let us check an option to use a prefix, then specify a prefix that allowed ignoring columns or rows. Thanks for all the hard work. If you've got a paypal I'd happily donate a little money to it.
Is this review helpful?
Yes
No
1-10 of 66
Search
Clear search
Close search
Google apps
Main menu