Get Sheets productivity tips

Want to use Google apps at work or school?  Sign up for a Google Workspace trial

On this page

• Import data from Forms
• Save time with templates
• Find out if someone changes a spreadsheet
• Add checkboxes to cells

Import data from Forms

Analyze data from Google Forms by sending it to Sheets.

1. In Forms, open the form with the data you want to import.
2. At the top, click Responses.
3. Click MoreSelect response destination.
4. Create a new spreadsheet or select an existing one.
5. Click Create or Select.

Save time with templates

If you’re creating the same types of files over and over, such as expense reports and purchase orders, save time with a template.

Sheets: Choose an existing template:

1. Open Sheets and at the top, click Template Gallery.
2. Click the template you want to open it.

Create your own template:

1. Open Sheets and at the top, click Template Gallery.
2. At the top of the gallery, click your organization’s name.
3. Click Submit Template.
4. Click Select a spreadsheet, and choose the template file you created, and then click Open.
5. Select a category for your file.
6. Click Submit.

Your new template appears in the Template Gallery under your organization’s name.

Find out if someone changes a spreadsheet

Notification rules let you know when any changes are made to a spreadsheet.

Sheets: Create notification rules:

1. In Sheets, open the spreadsheet where you want to set notifications.
2. Click Tools Notification rules.
3. Select when and how you want to receive notifications.
4. Click Save.

Add checkboxes to cells

Use checkboxes to make Sheets more interactive. You can use  checkboxes with charts, filters, pivot tables, and formulas.

Sheets: Add or remove checkboxes:

1. In your spreadsheet, select the cells where you want to add checkboxes.
2. Click InsertCheckbox.

Note: In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include). You can see the value in the Formula bar. You can also change this value.

Note: In formulas, unselected checkboxes have a value of FALSE (exclude) and selected checkboxes have a value of TRUE (include). You can see the value in the Formula bar. You can also change this value.

 

_{Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.}