Google Sheets

Handle task lists, create project plans, analyze data with charts and filters, and 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.

Choose from a wide variety of budgets, schedules, and other pre-made spreadsheets — all designed to make your work that much better, and your life that much easier.

1. Create or import
To start, you need a new or existing spreadsheet.

• 1.1. Create a new spreadsheet
  

Choose an option:
   

• From the Sheets homepage: Click Create new spreadsheet
  

.
   

• From Google Drive: Click New > Google Sheets > Blank spreadsheet or From a template.
  

• 1.2. Import and convert old spreadsheets to Sheets
  

If you have an existing spreadsheet you created in another program, you can easily import and convert it to Sheets.
   1.Go to Drive.
   2. Click  + New> File Upload.
   3. Choose the existing spreadsheet from your computer to add it to Drive. Supported files include .xls, .xlsx, .xlt, .ods, .csv, .tsv, .txt, and .tab.
   4. In Drive, right-click the spreadsheet you want to convert.
   5. Select Open with and choose Google 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.

2. Add content
Now that you have a spreadsheet open, you can start working in it. Sheets automatically saves every change you make.

• 2.1. Enter and edit your data
  

   1. Rename your spreadsheet: Click Untitled spreadsheet and enter a new name.
   2. Enter text or data: Click a cell and enter text.
   3. Insert more items: Click Insert and add charts, images, drawings, functions, notes, and more.
Note: To see which functions are available, see the Google spreadsheets function list.

• 2.2. Customize formats and fonts

In your spreadsheet, select the cells you want to customize, then use the menus and toolbar to change their formats.

• 2.3. Work with rows, columns, and cells
  

   1. Add rows, columns, and cells—Select a cell or block of cells. Then, on the menu bar, click Insert and choose where to add the row, column, or cells.
   2. Delete or hide rows and columns—Right-click the row number or column letter and select Delete or Hide.
   3. Delete a cell or a block of cells—Select the cells you want to delete. Click Edit > Delete cells and shift up, or Edit > Delete cells and shift left.
   4. Move rows and columns—Click the row number or column letter to select it. Then, drag it to a new location.
   5. Freeze header rows and columns—Keep some data in the same place as you scroll through the rest of your spreadsheet. On the menu bar, click View > Freeze and choose an option.

Share and collaborate
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.