Google Sheets · JSON Structure

Google Sheets Extended Value Structure

Type: object Properties: 4
Google WorkspaceProductivitySpreadsheets

ExtendedValue is a JSON Structure definition published by Google Sheets, describing 4 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

numberValue stringValue boolValue formulaValue

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

Raw ↑ 
{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "ExtendedValue",
  "type": "object",
  "properties": {
    "numberValue": {
      "type": "number"
    },
    "stringValue": {
      "type": "string"
    },
    "boolValue": {
      "type": "boolean"
    },
    "formulaValue": {
      "type": "string"
    }
  }
}