Export Sheet Data is an add-on for Google Sheets that allows sheets to be exported as JSON or XML.

Goals

Convenient: Export Sheet Data is meant to be simple to use but very powerful. No more exporting multiple CSVs then compiling data.

Customizable: Options and formats can be tweaked to reflect personal taste. Newline or sameline braces for JSON. Attributes or child elements for XML. Format your data the way you want.

Install

You can install Export Sheet Data here

Development Status

Export Sheet Data supports a wide variety of features. Currently, this includes:

JSON

• Forcing all data to string values
• Exporting individual cells as JSON arrays
• Exporting a sheet's contents as an array of JSON objects
• Unwrapping a sheet's JSON for easier access after exporting

XML

• Exporting columns as attributes, child elements, or inner text of a row
• Formatting XML illegal characters like &, <, and >
• XML declaration support

General

• Visualize data before exporting
• Newline or sameline formatting
• Exporting specific sheets

Contributing

If you would like to add a feature to Export Sheet Data, be sure to read the wiki page on contributing. Also, take a look at the notes on project structure and check out the currently open issues.

Credits

Developed by Chris Ingerson.

License

Export Sheet Data is licensed under the MIT License, see LICENSE for more information.