Open source add-on for Google Sheets that allows users to export sheets as XML or JSON.
By:
Works with:
190K+
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
PricingNot available
Developer
Trader status unspecified
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 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:
Google doesn't verify reviews or ratings. Learn more about reviews
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 Holder
May 24, 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
Michael Greenhut
September 11, 2023
Doesn't work anymore. Both the Visualize and Export buttons do nothing when I click on them in the sidebar (trying to export to JSON).
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
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
Clifton B
December 12, 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
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
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
Profile Picture
Jaume Subirats
November 11, 2020
Works perfect! It's a very usefull and powerfull tool.
Is this review helpful?
Yes
No
1-10 of 70
Search
Clear search
Close search
Google apps
Main menu