View on GitHub

ExportSheetData

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

Force string values

Force all data values to export as a string.

[!NOTE] null values will remain standard null values. They will not be converted to "null". See Null value format and Empty value format for more information on null and empty values.

Example:

Sheet name: Heroes

Name Human Age Superpower
Batman true 30  

Default Output:

{
  "Heroes": {
    "Batman": {
      "Name": "Batman",
      "Human": true,
      "Age": 30,
      "Superpower": null
    }
  }
}

Force String Output:

{
  "Heroes": {
    "Batman": {
      "Name": "Batman",
      "Human": "true",
      "Age": "30",
      "Superpower": null
    }
  }
}