Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

Switch from Excel to Sheets

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

""

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 More""and thenSelect response destination.
  4. Create a new spreadsheet or select an existing one.
  5. Click Create or Select.

Select response destination.

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.

Sheets template gallery.

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 and then Notification rules.
  3. Select when and how you want to receive notifications.
  4. Click Save.

In a sheet, find the "Notification rules" option in the menu under "Tools".

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 Insertand thenCheckbox.

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.

In Sheets, open the Checkbox option by clicking Insert from the menu.
 

Back to top ""


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.

Was this helpful?
How can we improve it?
true
Get help from Small Business Advisors

Want to receive one-on-one guidance and tailored recommendations on how to make the most out of your Business Profile? Try booking an appointment with Small Business Advisors.


Important: This service cannot troubleshoot issues, including Business Profile verification or suspension, or Google Ads billing.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
false
false
false