Handle task lists, create project plans, analyze data with charts and filters, and much more.
With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.
What you need:
G Suite account & 10 minutes
1
To start, you need a new or existing spreadsheet.
In this section, you learn how to:
1.1
From the Sheets homepage: Click Create new spreadsheet .
From Google Drive: Click New > Google Sheets > Blank spreadsheet or From a template.
1.2
If you have an existing spreadsheet you created in another program, you can easily import and convert it to Sheets.
When you convert your spreadsheet from another program, a copy of your original file is created in the Sheets format. You can then edit it in your browser as you would with any other Sheet.
Have an Excel spreadsheet?
If you've already stored Microsoft Excel spreadsheets in Drive, you can also update them without converting to Sheets. If you've already stored Microsoft® Excel® spreadsheets in Drive, you can also update them withoutconverting to Sheets.
2
Now that you have a spreadsheet open, you can start working in it. Sheets automatically saves every change you make.
In this section, you learn how to:
2.1
Note: To see which functions are available, see the Google spreadsheets function list.
2.2
In your spreadsheet, select the cells you want to customize, then use the menus and toolbar to change their formats.
2.3
2.4
Add a sheet: At the bottom of your spreadsheet, click Add sheet to add another sheet.
Delete or copy a sheet: Open the sheet. Then, at the bottom of your spreadsheet, on the sheet’s tab, click the Down arrow add, and selectDelete or Duplicate.
3
Share your spreadsheet with your team, or people outside your company. People can make changes at the same time, and you can see their changes as they happen. You can share with people who aren't on G Suite, too.
In this section, you learn how to:
3.1
Share a file you own or can edit:
Everyone you shared with will receive an email with a link to the spreadsheet.
3.2
If team members aren’t available to collaborate in real time, leave feedback and questions for them to see later.
If a comment is important for a specific collaborator to see, enter addfollowed by their address. They’ll get an email with your comment, along with a link to the spreadsheet. They can then reply to your comment to answer questions or start a discussion.
When you’re done with a comment, click Resolve.
4
If you need printouts, other formats, or copies of your spreadsheet, Sheets can do that, too.
In this section, you learn how to:
4.1
To print your spreadsheet, click File > Print or click Print print.
You can choose which sheets to print, what features to include, and which layout you want.
4.2
To download your spreadsheet so you can open it in other programs, click File > Download as and choose one of the following formats:
4.3
Copying a spreadsheet is useful for creating templates. For example, if you write a lot of project plans, make copies of one plan. Then, update each copy for a new project without having to format it again.
To make a copy of your spreadsheet, click File > Make a copy. You can rename the copy, change where you save it in Drive, and optionally share it with the same collaborators.
4.4
If you need to collaborate with someone on your spreadsheet in your old program or format, such as PDF or Excel, you can email it as an attachment.
Note: This sends a copy of the spreadsheet instead of sharing the original, so you won’t be able to use Sheets’ collaboration tools.