Complete API Documentation
Build Powerful APIs from Sheets
Connect your Google Sheets and Excel spreadsheets to create REST APIs in minutes. Everything you need to know is here.
đź“‹Format Your Spreadsheet
For the Spreadsheet you're going to connect to SheetToAPI, the first row must only contain column names. All the other rows may contain data in whatever format you'd like (symbols, numbers, dates, words, etc).
| Column | A | B | C | D |
|---|---|---|---|---|
| 1 | id | Name | Favorite Thing | Image |
| 2 | 1 | Bugs Bunny | Carrots | bugs.png |
| 3 | 2 | Elmer Fudd | Chasing Rabbits | elmer.png |
You may add multiple worksheets such as 'Looney Tunes', 'The Simpsons' to separate different categories of data. SheetToAPI will create an API endpoint for each of these automatically.