Excel Online as JSON API

In this tutorial, we'll show you how to turn your Excel Online into a JSON API that you can use in your applications.

You'll be able to read, create, update and delete data in your spreadsheet using simple HTTP requests - no coding required!

format_list_numbered 1. Prepare your Spreadsheet

For the Spreadsheet you're going to connect to sheet2api, the first row (1) must only contain column names.
All the other rows may contain data, in whatever format you'd like (symbols, numbers, dates, words, etc).

For example:

	A	B	C	D	E
1	Name	Favourite Thing	Image
2	Bugs Bunny	Carrots	Bugs.png
3	Elmer Fudd	Chasing Rabbits	Elmer.png
4

You may add multiple worksheets such as 'Looney Tunes', 'The Simpsons' to seperate different categories of data.
sheet2api will create an API endpoint for each of these automatically.

add_circle 2. Create Spreadsheet API

As per the video below:

1. Share & Copy the link to your Excel Online.
2. Create a Spreadsheet API using that link.
3. Proceed to the next step.

code 3. Use your API

Read Data

To read data from your spreadsheet, send a GET request to your API URL:

curl "YOUR_API_URL_HERE"

Create Data

To add new data, send a POST request with your data as JSON:

curl -X POST \
    -H "Content-Type: application/json" \
    -d '{"column1": "value1", "column2": "value2"}' \
    "YOUR_API_URL_HERE"

Update Data

To update existing data, send a PUT request with your updated data:

curl -X PUT \
    -H "Content-Type: application/json" \
    -d '{"column1": "new_value1"}' \
    "YOUR_API_URL_HERE?column1=old_value1"

Delete Data

To delete data, send a DELETE request with query parameters to match the rows you want to delete:

curl -X DELETE "YOUR_API_URL_HERE?column1=value1"