Search
Clear search
Close search
Main menu
Google apps
Open source add-on for Google Sheets that allows users to export sheets as XML or JSON.
By:
Listing updated:September 23, 2024
Works with:
188K+
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
PricingFree of charge
Developer
Non-trader
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
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 only the specific Google Drive files you use with this app
View and manage spreadsheets that this application has been installed in
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:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Dmitry Baranov
July 1, 2024
I have been using this extension for over 10 years. But it seems like it has some issues now. This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access
Is this review helpful?
Yes
No
Profile Picture
Ben Templeton
February 26, 2024
Super handy, allows pretty much all the configuration I'd like (ocassionally a little buggy, coming offline sometimes) but mostly works a treat
Is this review helpful?
Yes
No
Profile Picture
Alex Stormwood
May 25, 2023
This is the one. No payments required, the thing just works with whatever data you throw at it. Minus a star because you can't customise (or at least, docs don't show how to) the row vs columns used to build the JSON object, but a custom TRANSPOSE formula to populate another sheet based on the master sheet meets that need anyway. Fantastic for managing i18n JSON-formatted language data this way. Works in Google Chrome on MacBook Pro 2019 as of 25th May 2023.
Is this review helpful?
Yes
No
Profile Picture
Elias Willnat
May 19, 2023
This tool is amazing, I use it a lot and works perfectly fine! I can only recommand it!!
Is this review helpful?
Yes
No
Profile Picture
Merrick Johnston
September 21, 2022
the one very annoying thing about this, the software assumes it knows best and automatically converts dates to time/date rather than using the string you provide. As far as I can tell there is no work around other than manual edit. otherwise, very good.
Is this review helpful?
Yes
No
Profile Picture
Clifton B
December 13, 2020
Super helpful, and it's become necessary for my work, but it rests to the default settings every time I open a new file, so it takes me some time to figure out how to get it back to how my team needs things formatted. If there were a way to save and recover settings, that would be ideal. Remembering each user's settings across all files would also be helpful. Also, the number of steps it takes from hitting Export to finally downloading the resulting file seems excessive, but that's a minor gripe. I use this tool to download files, so having it save them to my Drive folder first is a little messy, but the unused files aren't really bothering anyone.
Is this review helpful?
Yes
No
Profile Picture
Kyrylo Kartukov
December 29, 2021
Great plugin, unfortunatelly it does not work in Chrome at all, unable to load/view current EDS settings(only Loading... text displayed, load settings button does nothing). Export button from the sidebar also does not work (even with default settings). The issue happens on Chrome (both on Windows and Mac) and Edge. However, in Safari everything works well. How can this be fixed?
Is this review helpful?
Yes
No
Profile Picture
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
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
Matthias Block
April 5, 2021
Hi! Works fine on MS Edge, but throws this exception on debug console on current version of chrome when clicking "vizualize". Default options, just selected current sheet. Uncaught at showCompilingMessage (ExportSheetData:2208) at exportJson (ExportSheetData:883)
Is this review helpful?
Yes
No
1-10 of 70