View on GitHub

ExportSheetData

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

Export value arrays

Export value arrays will export a sheet as a JSON array, with each row being used as a single element of the array, if it only contains one column.

The difference between this and Export sheet arrays is value arrays can contain basic values like numbers, bools, or strings, while sheet arrays will always contain JSON objects as their elements.

Example:

Sheet name: Random

Values
1
TRUE
Three

Default Output:

{
  "Random": {
    "1": {
      "Values": 1
    },
    "true": {
      "Values": true
    },
    "Three": {
      "Values": "Three"
    }
  }
}

Value Array Output:

{
  "Values": [
    1,
    true,
    "Three"
  ]
}