Google Sheets · Schema

Sheet

A sheet in a spreadsheet.

Google WorkspaceProductivitySpreadsheets

Properties

Name Type Description
data array Data in the grid, if this is a grid sheet.
merges array The ranges that are merged together.
conditionalFormats array The conditional format rules in this sheet.
filterViews array The filter views in this sheet.
protectedRanges array The protected ranges in this sheet.
charts array The specifications of every chart on this sheet.
bandedRanges array The banded (alternating colors) ranges on this sheet.
slicers array The slicers on this sheet.
View JSON Schema on GitHub

JSON Schema

google-sheets-sheet-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "Sheet",
  "type": "object",
  "description": "A sheet in a spreadsheet.",
  "properties": {
    "data": {
      "type": "array",
      "description": "Data in the grid, if this is a grid sheet."
    },
    "merges": {
      "type": "array",
      "description": "The ranges that are merged together."
    },
    "conditionalFormats": {
      "type": "array",
      "description": "The conditional format rules in this sheet."
    },
    "filterViews": {
      "type": "array",
      "description": "The filter views in this sheet."
    },
    "protectedRanges": {
      "type": "array",
      "description": "The protected ranges in this sheet."
    },
    "charts": {
      "type": "array",
      "description": "The specifications of every chart on this sheet."
    },
    "bandedRanges": {
      "type": "array",
      "description": "The banded (alternating colors) ranges on this sheet."
    },
    "slicers": {
      "type": "array",
      "description": "The slicers on this sheet."
    }
  }
}