forcestringvalues.md

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
    }
  }
}