Intro

Sheets are like exposed databases for your Site. They function like plain spreadsheets and you use them to connect cells to other areas of the platform.

This article will cover

• Creating Sheets
• Sheet Functions
• Sheets and Zapier

They help you with several major advantages during a site build:

1. Creating mini web apps.

2. Repeating content with a common design like blog posts, team members, or a directory.

3. Detaching content from the site.

4. Organizing data for use on the site (or for yourself/team).

The best way to understand how Sheets work and how they are useful is through an example.

Creating Sheets

To create a sheet from the Worksheet, you can either create a blank Sheet or upload a .csv file.

Then, type in any text into the cells to fill the sheet with your data. You can also drag and drop images directly into these cells to upload them.

Sheet Functions

When editing a Sheet, you can organize rows and columns by reordering, adding, and deleting them.

Reordering Columns and Rows

Click and drag the column or row header (letter or number) to reorder a column or row.

Adding and Deleting Columns and Rows

Right-click on a column header and you'll see the options to insert columns to the right or left and to delete the column. The same goes for rows.

Using Sheets

Sheets and Zapier

The.com also has Zapier integrated into Sheets. Click the Zapier button in the toolbar of the editor to see active Zaps or create a Zap.

Before setting up a Zap, make sure that you add custom column headers in the first row of the Sheet for all the data you anticipate receiving from the Zap.

Zapier makes the steps to setting up Zaps easy, and we have additional articles looking into this in more detail.