Documentation

Getting Started

1. Open any Google Sheet
2. Go to Extensions > Sheets to JSON > Open Converter
3. The sidebar will appear on the right

Output Formats

[
  { "name": "John", "age": 30, "city": "NYC" },
  { "name": "Jane", "age": 25, "city": "LA" }
]

[
  ["name", "age", "city"],
  ["John", 30, "NYC"],
  ["Jane", 25, "LA"]
]

Nested JSON

Create nested objects and arrays using special header notation.

[
  {
    "name": "John",
    "address": {
      "street": "123 Main St",
      "city": "NYC"
    }
  }
]

{
  "address": {
    "geo": { "lat": 40.7128, "lng": -74.006 }
  }
}

[
  { "name": "John", "tags": ["developer", "designer"] }
]

{
  "items": [
    { "product": "Apple", "price": 1.5 },
    { "product": "Banana", "price": 0.75 }
  ]
}

Type Inference

When enabled, automatically converts string values to appropriate types.

{ "count": 42, "active": true }

{ "count": "42", "active": "true" }

Examples

[
  {
    "name": "John Doe",
    "email": "john@example.com",
    "phone": "555-1234"
  }
]

[
  {
    "id": 1,
    "name": "Laptop",
    "price": 999.99,
    "category": { "main": "Electronics" },
    "inStock": true
  }
]

Tips

1. Header names become JSON keys — Keep them simple, no spaces recommended
2. Empty cells become null — When type inference is enabled
3. First row is always headers — In Array of Objects mode
4. Preview first — Always preview before downloading to verify structure
5. Array indices start at 0 — Use [0], [1], [2], etc.

FAQ