Export Sheet Data - Google Workspace Marketplace

Chris Ingerson

• 71,093

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:

Tristin Harris

February 17, 2021

I think it's very cool 😎 and very very flexible

Is this review helpful?

Yes

Trọng Nguyễn

January 14, 2021

The nested format is not very flexible but it's alright

Is this review helpful?

Yes

Miles

January 8, 2021

Wow yeah this did exactly what I wanted it to do. Thanks!

Is this review helpful?

Yes

Nebojsa Nedic

December 26, 2020

File that has 26K rows, it exported only few hundreds in JSON. Other than that, and the fact that you have to be logged in with only one account, it works fine :/... Hopefully you can fix this issue. All the best.

Is this review helpful?

Yes

Chris Ingerson

January 5, 2021

Thanks for using ESD! The missing JSON issue sounds like a key/field ID issue. If you have multiple rows starting with the same value, only the last row will be used due to JSON not supporting multiple fields with the same ID. If you are using nested elements, be sure to check out the documentation for more in depth info on what could be happening there! The account issue is, unfortunately, on Google's side and I cannot do much to work around it. You can have multiple accounts signed in, you'll just need to be mindful that Google will occasionally attempt to use the incorrect account to run ESD, which causes problems. If this happens, you just need to sign out of all but one account, after which you can sign back into your other accounts and use ESD just fine. I'm still looking into potential solutions for this on ESD's end, but is definitely a pretty frustrating usability issue for now.

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

Chris Ingerson

December 20, 2020

Glad to hear ESD is proving useful to you! These are all good suggestions for quality of life improvements. Saving/loading settings has been a notable pain point for a while, complicated by the limited access Apps Script has to various files. I think I have an idea on how to support loading settings from templates or JSON blobs, but I need to develop the interface for it. I've just added a download button the export modal, reducing the number of clicks to download a file from 3 to 2 so that workflow feels a lot better. Those two things should be in the next version (v65). As for always creating a file on Drive, I'm toying with doing direct downloads from the visualize modal (without creating a file first) but that may not make it into the next release unless I'm reasonably satisfied with how it works.

Samson Assefa

December 8, 2020

Samson Assefa Gebrehiwot

Is this review helpful?

Yes

Logan Jory

November 26, 2020

Echoing the below review: I tried it on a test sheet but nothing happens. Sidebar opens. Settings are set-able, Buttons are press-able. But nothing happens on any button press.

Is this review helpful?

Yes

Chris Ingerson

November 27, 2020

Sorry to hear that you are having issues! I've just pushed a new version with several added safety checks to catch any unexpected errors and help suggest potential fixes. The most common cause for your particular issue is having multiple accounts signed in at once. This is related to a bug in how Google handles add-on execution so there is little I can do to actually solve the issue. It can easily be fixed by signing out of all but one account, but that is an extra amount of frustration that users don't want to deal with. I'm still looking into good ways to handle this on my end, but for now signing out of all but one account should solve your problems!

Prashant Sethi

November 19, 2020

Not working

Is this review helpful?

Yes

Paul Otto

November 11, 2020

I tried it on a test sheet but nothing happens. Sidebar opens. Settings are set-able, Buttons are press-able. But nothing happens on any button press. Nothing more to report.

Is this review helpful?

Yes

Chris Ingerson

November 11, 2020

Hmm, a review noting nothing happens immediately after a review saying it works perfect. Fun times! You should at the very least see a compiling modal so it's interesting that nothing seems to happen. Do you have multiple accounts signed in? If so, does logging out of all but your primary account seem to fix the issue?

Jaume Subirats

November 11, 2020

Works perfect! It's a very usefull and powerfull tool.

Is this review helpful?

Yes

1-10 of 64

Additional information

Chris Ingerson

Website

Support

Clear search

Close search

Google apps

Main menu