Prepare your spreadsheet
For Sheety to serve your spreadsheet as an API, it needs to be in a particular format. With a few tweaks to your spreadsheet you can make it compatible with Sheety.
The first row of your sheet will be used as the header. This is the most important part of preparing your sheet, as the names you use here will be used as the property names in the returned objects. Each column in your sheet represents that property’s value.
For example, if your spreadsheet looked like this:
…then Sheety will return this:
Sheety will also ‘camelCase’ your header names to make them more JSON friendly.
Sheet names act as API endpoints
The name of your sheets (the tabs within the spreadsheet) will be used as the API endpoint name. So if your spreadsheet has a sheet called “Emails” and another sheet called “Events”, the URLs will look something like:
Singular names such as “Event” will automatically be converted to the plural “Events”. We suggest keeping your sheet names as simple as possible. Single descriptive words work best. The sheet name will also be used as the root property in the returned JSON.
💡 Sheety Tip: If you're familar with database naming conventions, think of sheets as your tables, and columns as...well columns!
Sheety will use the same formatting as your cells
Sheety will return your data in the same format as it’s stored in your spreadsheet. For example if you cell is formatted as a
Number, then Sheety will return that data as a number type in JSON.
And that’s it!
Hopefully that was pretty simple. Next up see how to add your spreadsheet to Sheety.
Create a project →