App Icon
Chris Ingerson
•  39,881
Overview
Open source add-on for Google Sheets that allows users to export sheets as XML or JSON.
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
Language:
Sort by:
Profile Picture
A User of Export Sheet Data
July 6, 2020
Very useful tool! The only problem I am finding is that when you add a \ and you export the JSON, the \ is duplicated \\. Not sure how to get rid of it of if there is any chance
Is this review helpful?
Yes
No
Profile Pciture
A user of Export Sheet Data
July 11, 2020
Glad you find ESD helpful! Unfortunately backslashes ( \ ) are reserved characters in JSON and must be escaped by placing a second backslash ( \\ ) or malformed JSON will be created.
Profile Picture
A User of Export Sheet Data
June 17, 2020
good
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
June 8, 2020
An amazingly useful tool for prototyping data sets and building up json files for apps.
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
May 28, 2020
Amazing Add-on
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
May 26, 2020
This is working well in most cases. I'm having an issue where I'm toggling on "Nested Elements" because I'm using the feature on one of my sheets, but enabling it messes with another sheet that is supposed to export as an array object. Can we get a prefix to either: have "Nested Elements" ignore a sheet or tag a specific sheet as a "Export Sheet Arrays"?
Is this review helpful?
Yes
No
Profile Picture
Josh B. James
May 13, 2020
Trying to export XML, and I am frustratingly close to having what I need. The first column always creates a CE which is messing me up.
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
April 23, 2020
anyone have sample google sheets?
Is this review helpful?
Yes
No
Profile Picture
A User of Export Sheet Data
April 22, 2020
Nice work, thanks
Is this review helpful?
Yes
No
Profile Pciture
A user of Export Sheet Data
April 26, 2020
Thanks! Glad you are enjoying ESD!
Profile Picture
A User of Export Sheet Data
March 5, 2020
I am having the hardest time Understanding how to setup my JSON using this. I've been doing in manually and thought I finally found a solution but this isn't giving me the desired result. How would I set up some JSON (the rows and columns) that looks like this example?: { "steve": { "name": "Steve", "age": "29", "gender": "male", "moves": { "move 1": "chest", "move 2": "quest", "move 3": "obsesseed" } }, "pete": { "name": "Peter", "age": "32", "gender": "male" }, "sop": { "name": "Sophie", "age": "27", "gender": "female" } } UPDATE: It looks like there is simply a bug with Nested Elements. Anytime I try to use nested elements it only exports the last row unless I put the contents into an array.
Is this review helpful?
Yes
No
Profile Pciture
A user of Export Sheet Data
April 7, 2020
Same here. Please fix this bug. I don't want to add the extra index number.
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
1-10 of 50
Additional information
Chris Ingerson
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu