Create Spreadsheets

How to Create Spreadsheets in Google Sheets

Create Spreadsheets

Creating a new spreadsheet is one of the most basic commands you need to know in Google Sheets. You can create a new, blank sheet or create a new sheet based on a variety of pre-designed templates.

Create a Spreadsheet

  1. Open a folder in Google Drive.
  2. Click the New button.
  3. Select Google Sheets.
    Create a Spreadsheet

A new, blank workbook is created, and you can start entering data.

Name a Spreadsheet

  1. Click in the name field above the spreadsheet.
  2. Type a new name, then press Enter.
    Name a Spreadsheet

The file is renamed.

Save and Close

As long as you're connected to the internet, Google Sheets will automatically save your work.

  1. Make sure that changes have been automatically saved.
    Save and Close

The spreadsheet is saved and will appear the same once you reopen it.

Create a Spreadsheet from a Template

If you need help getting started with a common document, such as a budget, schedule, or calendar, you can use one of Sheets' templates instead of starting from scratch.

  1. Click New.
  2. Click > next to Google Sheets.
  3. Select From a template.
    Create a Spreadsheet from a Template
  4. The Template gallery appears, with tabs that sort templates into two groups. The first tab is for templates you, or others in your organization, have submitted. The second tab is for built-in templates.

  5. Select a template gallery.
  6. There are plenty of templates available, organized into categories.

  7. Select a template.
    Create a Spreadsheet from a Template

A new spreadsheet is created using the template, with its design elements and placeholder data appearing.

FREE Quick Reference

Click to Download