Documentation

Getting Started

Open any Google Sheet
Go to Extensions → Sheet to JSON → Open Converter
The sidebar will appear on the right

Output Formats

Array of Objects

Converts each row into a JSON object using the first row as keys.

Spreadsheet:

name	age	city
John	30	NYC
Jane	25	LA

Output:

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

Array of Arrays

Converts the sheet into a raw 2D array, including headers.

Output:

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

Nested JSON

Create nested objects and arrays using special header notation.

Dot Notation (Nested Objects)

Use . to create nested objects.

Spreadsheet:

name	address.street	address.city	address.zip
John	123 Main St	NYC	10001

Output:

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

Deep Nesting

Chain multiple dots for deeper nesting.

Spreadsheet:

name	address.geo.lat	address.geo.lng
Office	40.7128	-74.0060

Output:

[
  {
    "name": "Office",
    "address": {
      "geo": {
        "lat": 40.7128,
        "lng": -74.006
      }
    }
  }
]

Bracket Notation (Arrays)

Use [0], [1], etc. to create arrays.

Spreadsheet:

name	tags[0]	tags[1]	tags[2]
John	developer	designer	writer

Output:

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

Arrays of Objects

Combine brackets and dots for arrays of objects.

Spreadsheet:

name	items[0].product	items[0].price	items[1].product	items[1].price
Order1	Apple	1.50	Banana	0.75

Output:

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

Type Inference

When enabled, automatically converts string values to appropriate types.

Cell Value	Converted To	Type
123	123	number
45.67	45.67	number
-89	-89	number
true	true	boolean
false	false	boolean
TRUE	true	boolean
2024-01-15	"2024-01-15T00:00:00.000Z"	ISO date string
(empty cell)	null	null
Hello	"Hello"	string

Type Inference ON:

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

Type Inference OFF:

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

Examples

Simple Contact List

Spreadsheet:

name	email	phone
John Doe	john@example.com	555-1234
Jane Smith	jane@example.com	555-5678

Output:

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

Product Catalog

Spreadsheet:

id	name	price	category.main	category.sub	inStock
1	Laptop	999.99	Electronics	Computers	true
2	Desk	249.50	Furniture	Office	false

Output:

[
  {
    "id": 1,
    "name": "Laptop",
    "price": 999.99,
    "category": {
      "main": "Electronics",
      "sub": "Computers"
    },
    "inStock": true
  },
  {
    "id": 2,
    "name": "Desk",
    "price": 249.5,
    "category": {
      "main": "Furniture",
      "sub": "Office"
    },
    "inStock": false
  }
]

User with Multiple Addresses

Spreadsheet:

username	addresses[0].type	addresses[0].city	addresses[1].type	addresses[1].city
john123	home	New York	work	Boston

Output:

[
  {
    "username": "john123",
    "addresses": [
      { "type": "home", "city": "New York" },
      { "type": "work", "city": "Boston" }
    ]
  }
]

Tips

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

FAQ

Q: What's the maximum sheet size?

No hard limit. Processing happens in your browser, so very large sheets may take a few seconds.

Q: Can I export multiple sheets?

Currently exports the active sheet only. Switch sheets and export separately.

Q: Why are my numbers showing as strings?

Make sure "Infer data types" is checked before generating preview.

Q: How do I create an empty array?

Leave all array index cells empty - they will be omitted from output.

Back to Sheet to JSON

Documentation

Getting Started

Open any Google Sheet
Go to Extensions → Sheet to JSON → Open Converter
The sidebar will appear on the right

Output Formats

Array of Objects

Converts each row into a JSON object using the first row as keys.

Spreadsheet:

name	age	city
John	30	NYC
Jane	25	LA

Output:

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

Array of Arrays

Converts the sheet into a raw 2D array, including headers.

Output:

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

Nested JSON

Create nested objects and arrays using special header notation.

Dot Notation (Nested Objects)

Use . to create nested objects.

Spreadsheet:

name	address.street	address.city	address.zip
John	123 Main St	NYC	10001

Output:

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

Deep Nesting

Chain multiple dots for deeper nesting.

Spreadsheet:

name	address.geo.lat	address.geo.lng
Office	40.7128	-74.0060

Output:

[
  {
    "name": "Office",
    "address": {
      "geo": {
        "lat": 40.7128,
        "lng": -74.006
      }
    }
  }
]

Bracket Notation (Arrays)

Use [0], [1], etc. to create arrays.

Spreadsheet:

name	tags[0]	tags[1]	tags[2]
John	developer	designer	writer

Output:

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

Arrays of Objects

Combine brackets and dots for arrays of objects.

Spreadsheet:

name	items[0].product	items[0].price	items[1].product	items[1].price
Order1	Apple	1.50	Banana	0.75

Output:

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

Type Inference

When enabled, automatically converts string values to appropriate types.

Cell Value	Converted To	Type
123	123	number
45.67	45.67	number
-89	-89	number
true	true	boolean
false	false	boolean
TRUE	true	boolean
2024-01-15	"2024-01-15T00:00:00.000Z"	ISO date string
(empty cell)	null	null
Hello	"Hello"	string

Type Inference ON:

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

Type Inference OFF:

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

Examples

Simple Contact List

Spreadsheet:

name	email	phone
John Doe	john@example.com	555-1234
Jane Smith	jane@example.com	555-5678

Output:

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

Product Catalog

Spreadsheet:

id	name	price	category.main	category.sub	inStock
1	Laptop	999.99	Electronics	Computers	true
2	Desk	249.50	Furniture	Office	false

Output:

[
  {
    "id": 1,
    "name": "Laptop",
    "price": 999.99,
    "category": {
      "main": "Electronics",
      "sub": "Computers"
    },
    "inStock": true
  },
  {
    "id": 2,
    "name": "Desk",
    "price": 249.5,
    "category": {
      "main": "Furniture",
      "sub": "Office"
    },
    "inStock": false
  }
]

User with Multiple Addresses

Spreadsheet:

username	addresses[0].type	addresses[0].city	addresses[1].type	addresses[1].city
john123	home	New York	work	Boston

Output:

[
  {
    "username": "john123",
    "addresses": [
      { "type": "home", "city": "New York" },
      { "type": "work", "city": "Boston" }
    ]
  }
]

Tips

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

FAQ

Q: What's the maximum sheet size?

No hard limit. Processing happens in your browser, so very large sheets may take a few seconds.

Q: Can I export multiple sheets?

Currently exports the active sheet only. Switch sheets and export separately.

Q: Why are my numbers showing as strings?

Make sure "Infer data types" is checked before generating preview.

Q: How do I create an empty array?

Leave all array index cells empty - they will be omitted from output.