Sheets2JSON is a simple service that provides a read-only REST endpoint for any publicly accessible Google Sheet, .xlsx/.xls, or .csv document. This api will attempt to return the provided Sheet data in structured JSON. Pass in any remote document or Google Sheet url and recieve a structured JSON response.
Obtain a link to any pubilc .xlsx/.xls, .csv, or Google Sheet
Make a GET request and pass the public url to the Sheets2Json endpoint as the
Recieve a structured JSON response with the target sheet row values as an array
This API service consists of a single supported endpoint and is read-only. You can pass in specific query parameters that can be used to modify the JSON responses, for example adding custom
headers (column names or keys) to override the remote documents. You can also use
orderby to sort the JSON object in the response. Lastly, for documents that have multiple workbooks/sheets, you can pass in a
sheet parameter and the name of the desired Sheet to return. By default the first sheet in the document will always be returned.
There is only one single supported endpoint:
Make a GET request to this endpoint where
url is a valid publicly accessible xlsx, xls, csv, or Google Sheet link. The
url parameter is the only required parameter that needs to be present on every request. Additional supported query parameters can be found below, and can be used to customize or mutate the response from the API.
Below are two examples for what the API would be expecting for the
There are five(5) supported query parameters for the above endpoint:
||String||Yes||Full url to document (see above for examples).|
||Boolean | String||No||Can be a boolean (
||String||No||Sort resulting data array by speficic object key.|
||String||No||Sheet name of desired worksheet in the document. If no
Below are a few examples of how to interact with the API and what to expect as a response. All examples are using the same Google Sheet as the data source: