emptyvalueformat.md

Empty value format

Value exported for empty cells.

Null will export empty cells with a standard JSON null value while Empty String will export an empty string "".

Example:

Sheet name: Directors

Name	Skill
George	Creation
JJ

Null Output:

{
  "Directors" : {
    "George" : {
      "Name" : "George",
      "Skill" : "Creation"
    },
    "JJ" : {
      "Name" : "JJ",
      "Skill" : null
    }
  }
}

Empty String Output:

{
  "Directors" : {
    "George" : {
      "Name" : "George",
      "Skill" : "Creation"
    },
    "JJ" : {
      "Name" : "JJ",
      "Skill" : ""
    }
  }
}