View on GitHub

ExportSheetData

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

Ignore empty cells

Prevent cells with empty values from being exported.

This is useful for reducing file size and clutter by removing elements with no value.

Example:

Sheet name: Flame Pokemon

Name Type1 Type2
Charmander Fire  
Charmeleon Fire  
Charizard Fire Flying

Default Outputs:

JSON:

{
  "Flame Pokemon" : {
    "Charmander" : {
      "Name":"Charmander",
      "Type1":"Fire",
      "Type2":null
    },
    "Charmeleon" : {
      "Name":"Charmeleon",
      "Type1":"Fire",
      "Type2":null
    },
    "Charizard" : {
      "Name":"Charizard",
      "Type1":"Fire",
      "Type2":"Flying"
    }
  }
}

XML:

<pokedex>
  <Flame_Pokemon>
    <Charmander>
      <Type1>Fire</Type1>
      <Type2></Type2>
    </Charmander>
    <Charmeleon>
      <Type1>Fire</Type1>
      <Type2></Type2>
    </Charmeleon>
    <Charizard>
      <Type1>Fire</Type1>
      <Type2>Flying</Type2>
    </Charizard>
  </Flame_Pokemon>
</pokedex>

Ignore Outputs:

JSON:

{
  "Flame Pokemon" : {
    "Charmander" : {
      "Name":"Charmander",
      "Type1":"Fire"
    },
    "Charmeleon" : {
      "Name":"Charmeleon",
      "Type1":"Fire"
    },
    "Charizard" : {
      "Name":"Charizard",
      "Type1":"Fire",
      "Type2":"Flying"
    }
  }
}

XML:

<pokedex>
  <Flame_Pokemon>
    <Charmander>
      <Type1>Fire</Type1>
    </Charmander>
    <Charmeleon>
      <Type1>Fire</Type1>
    </Charmeleon>
    <Charizard>
      <Type1>Fire</Type1>
      <Type2>Flying</Type2>
    </Charizard>
  </Flame_Pokemon>
</pokedex>