Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
Clone or download
Synthoid Update index.md
Removed XML 'Don't format illegal characters' option as it is no longer supported.
Latest commit 59716c2 Dec 9, 2018
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
docs Update index.md Dec 9, 2018
src Fixed oversight causing XML reserved characters to be encoded twice. Dec 9, 2018
LICENSE Initial commit Jul 7, 2016
README.md Update README.md Dec 9, 2018
ReleaseNotes.pdf Fixed oversight causing XML reserved characters to be encoded twice. Dec 9, 2018

README.md

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. Default or stringified values for JSON. Attributes or child elements for XML. Format your data the way you want.

Install

You can install Export Sheet Data here

Documentation

The best way to figure out how to use Export Sheet Data is by opening the sidebar, reading the tooltips of various options and experimenting with the output using the Visualize option.

For detailed documentation on each option, take a look at Export Sheet Data's documentation.

If you want to create more advanced data structures, make sure to read the Wiki page about Nested Elements.

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
  • Creating complex data structures via Nested Elements

XML

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

General

  • Visualize data before exporting
  • Exporting specific sheets
  • Unwrapping or collapsing a sheet's data for easier access after exporting
  • Minifying exported data to produce smaller files

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 with help from the community.

License

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