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.

Make the first row of your spreadsheet the header

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:

{
	"name": "Phillip",
	"email": "[email protected]",
	"canAttend": true
},
{
	"name": "Syed",
	"email": "[email protected]",
	"canAttend": true
}

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:

• https://api.sheety.co/username/projectName/emails
• https://api.sheety.co/username/projectName/events

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 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 →