View on GitHub

ExportSheetData

Add-on for Google Sheets that allows data to be exported as JSON or XML.

Collapse single row sheets

Remove the wrapping element of a sheet that has only one row (not including the keys row).

This is similar to unwrapping single row sheets but does not place sheet fields in the root JSON or XML element directly.

Example:

Sheet name: Character

Name Age Role
Cid 25 Fighter

Default Output:

JSON:

{
  "Character" : {
    "Cid" : {
      "Name":"Cid",
      "Age":25,
      "Role":"Fighter"
    }
  }
}

XML:

<data>
  <Character>
    <Cid>
      <Age>25</Age>
      <Role>Fighter</Role>
    </Cid>
  </Character>
</data>

Collapsed Output:

JSON:

{
  "Character" : {
    "Name":"Cid",
    "Age":25,
    "Role":"Fighter"
  }
}

XML:

<data>
  <Character>
    <Age>25</Age>
    <Role>Fighter</Role>
  </Character>
</data>

Unwrapped Output:

JSON:

{
  "Name":"Cid",
  "Age":25,
  "Role":"Fighter"
}

XML:

<data>
  <Cid>
    <Age>25</Age>
    <Role>Fighter</Role>
  </Cid>
</data>