SheetJSON.com

Convert Google Spreadsheets to JSON API endpoints instantly. No signup required. No dumpster diving for an API key.

Quick Start

1. Set your spreadsheet access to "Anyone with the link."
2. Ensure the first row contains the column headers
3. Replace `docs.google.com` with `sheetjson.com` in the URL

Example

Try this example of a Food Truck directory:

Example Spreadsheet:
https://docs.google.com/spreadsheets/d/1olparkGzvli14s-Jn-uVX66vhAf64Fpt78e7pfQPtQ8/edit?gid=1971483596

API Endpoint:

Sample Response:

[
{
  "truck_id": "FT003",
  "truck_name": "Pasta.exe",
  "cuisine_type": "Italian",
  "signature_dish": "Code Red Ravioli",
  "price_range": "$$",
  "current_location": "Silicon Valley Mall",
  "is_open": true,
  "rating": 4.7,
  "last_review_date": "2024-01-15",
  "weekly_schedule": "Wed-Sun: 12:00-22:00",
  "close_time": "22:00",
  "updated_at": "11/13/2024 20:10:08"
}, 
// ... more entries 
]

Features

• 🚀 Frictionless: No registration or API keys required
• 🔄 Fresh: Responses are cached for 10-60 seconds
• 🏎️ Fast: Utilizes the Cloudflare Edge Network

Accessing Specific Sheets

Use the gid query param to access different tabs in the spreadsheet:

https://sheetjson.com/spreadsheets/d/{spreadsheetId}?gid=1234

Use Cases

• 🏎️ Rapid prototyping
• 📊 Dashboard data sources
• 💻 Simple CMS
• 🌐 Access public datasets

Limitations

• Only works with public spreadsheets
• Cache duration: 10-60 seconds
• Reasonable rate limits may apply

Credits

This service is built with Hono, @github/public-google-sheets-parser and hosted on Cloudflare Workers.

Terms of Use

This service is provided as-is without any guarantees.