Instantly transform spreadsheet data into queryable APIs

Sheets2Json turns your spreadsheets into real APIs. Import Google Sheets, Excel Online, CSV, or XLSX files and get instant JSON endpoints you can query, filter, and integrate with any stack. No servers, no parsing scripts, just live data. External data, queryable and available through a simple API.

Get Started Read the Docs 
  1. curl --get
  2.   http://api.sheets2json.com/v1/data/collection/12345678 \
  3.   -d "where[Phase]=gas" \
  4.   -d "whereLess[AtomicMass]=100" \
  5.   -d "limit=10"
  1. {
  2.   "data": [
  3.     {
  4.       "AtomicNumber": 1,
  5.       "Element": "Hydrogen",
  6.       "Symbol": "H",
  7.       "AtomicMass": 1.007,
  8.       "NumberofNeutrons": 0,
  9.       "NumberofProtons": 1,
  10.       "NumberofElectrons": 1,
  11.       "Period": 1,
  12.       "Group": 1,
  13.       "Phase": "gas",
  14.       "Radioactive": null,
  15.       "Natural": "yes",
  16.       "Metal": null,
  17.       "Nonmetal": "yes",
  18.       "Metalloid": null,
  19.       "Type": "Nonmetal",
  20.       "AtomicRadius": 0.79,
  21.       "Electronegativity": 2.2,
  22.       "FirstIonization": 13.5984,
  23.       "Density": 0.0000899,
  24.       "MeltingPoint": 14.175,
  25.       "BoilingPoint": 20.28,
  26.       "NumberOfIsotopes": 3,
  27.       "Discoverer": "Cavendish",
  28.       "Year": 1766,
  29.       "SpecificHeat": 14.304,
  30.       "NumberofShells": 1,
  31.       "NumberofValence": 1
  32.     },
  33.     ...
  34.   ]
  35. }

Import data from tools you already use

Turn everyday spreadsheets into structured, queryable datasets instantly. Import directly from Google Sheets, Microsoft Excel Online, CSV, or XLSX files.

  • Auto-detects schema and field types from column headers
  • Target specific sheets or tabs within multi-sheet workbooks
  • Supports both static uploads and live, refreshed data sources
  • Keep in sync with data managed outside your codebase

No new tools to learn — just import and query.

Version control and management

Manage multiple version imports, query and compare different versions of your dataset collection.

  • Create and publish multiple versions per collection
  • Assign named versions for easy reference
  • Control which version is the active default
  • Automatically prune older versions

When your source sheet changes, just import a new version. Your API endpoint stays stable and predictable.

Fine-grained access control

Decide exactly who can access your data, and how.

  • Make datasets public, private, or token-restricted
  • Generate access tokens for different environments or clients
  • Set token expirations or revoke instantly
  • Manage access programmatically through the API

Your data, your rules.

Powerful querying & filtering

Query your collections with speed and flexibility using simple, SQL-like parameters over JSON APIs.

  • Filter by field values, ranges, or free text
  • Include or exclude specific fields
  • Paginate results with limits and offsets
  • Get consistently fast, optimized responses

Make your spreadsheet data universally accessible and always up to date via API. Read API Docs

Free On-Demand Parsing

Document Explorer

Use our helpful Document Explorer to test out your documents and convert your data into JSON with a simple to use UI right in your browser. Alternatively, dive right into our Document Data API.

Document Explorer
Document Data API

Document Data API

No Login Required - with our freely available Document Data API, simply pass a file URL and get JSON returned instantly.

Document URL

Obtain a URL to a publicly accessible XLSX, CSV, Google Sheet, or Microsoft Excel Online document

HTTP Request

Make a GET request and pass the public url to our Document Data API endpoint

Structured JSON

Recieve a structured JSON response with the target sheet row values as an array

Start free and upgrade as needed

No payment hassles. Cancel anytime.

Basic

Best for personal use
or as a free trial.

FREE
Always
  • Create up to 2 collections
  • Create up to 3 collection versions
  • Import up to 1,000 records
  • Import up to 10MB of data
  • Access to Collections API
  • Access to Collections Data API
  • Access to Documents Data API
Get started

Starter

Best for small projects
and lighter datasets.

-
Annual renewal
  • Create up to 6 collections
  • Create up to 6 collection versions
  • Import up to 25,000 records
  • Import up to 25MB of data
  • Access to Collections API
  • Access to Collections Data API
  • Access to Documents Data API
Coming Soon

Developer

Best for larger projects, teams,
and datasets.

-
Annual renewal
  • Create up to 12 collections
  • Create up to 10 collection versions
  • Import up to 100,000 records
  • Import up to 50MB of data
  • Access to Collections API
  • Access to Collections Data API
  • Access to Documents Data API
Coming Soon

Frequently asked questions

Sheets2Json is built for anyone who manages data in spreadsheets or CSV files and needs to make that data available to web applications or websites.

It's perfect for accessing data that lives outside your primary database or is maintained by another team or organization without an existing API.

Sheets2Json also makes it easy to prototype quickly or work with temporary datasets with no need to modify your database schema.

Get started for free today

Limited access to the platform for free. No credit card required.

Create a Collection