Google Sheets

Google Sheets is a cloud-based spreadsheet tool by Google that allows users to create, edit, and collaborate on spreadsheets in real time. It supports functions, charts, data analysis, and automation through formulas and Google Apps Script, making it useful for everything from simple lists to complex data management.

What can you do in sheets?

Collaborate with other team members in real-time
Organizes data in rows and columns.
Perform calculations using formulas.
Create charts and graphs to visualize data.

Get Sheets on your devices

You can open Sheets in any of the following ways:

Any web browser – Go to sheets.google.com.
Google Drive – Click NewGoogle Sheets and create from scratch or from a template.
Most Google pages – At the top right, click the App Launcher Sheets.
Android devices – Install and open the Android app.
Apple iOS devices – Install and open the iOS app

Edit Excel files in Sheets

Open an Excel file from Drive and edit it in Sheets. Any changes you make are saved in the original Excel format.

Chrome browser only

Make sure that the Office editing for Docs, Sheets and Slides extension is not installed:
- Open the Chrome browser and, at the top-right corner, click More More tools Extensions.
- If you see the Office editing for Docs, Sheets and Slides extension, click Remove.
In Drive, double-click an Excel file.
A preview of your file will open.
At the top, click Open with Google Sheets.

You can now edit, share, view version history, collaborate in real time with others and more. All changes that you make are saved to the original Microsoft Office file.

Collaborating in Google Sheets

Edit Excel files in Sheets

Open an Excel file from Drive and edit it in Sheets. Any changes you make are saved in the original Excel format.

Chrome browser only

Make sure that the Office editing for Docs, Sheets and Slides extension is not installed:
- Open the Chrome browser and, at the top-right corner, click MoreMore toolsExtensions.
- If you see the Office editing for Docs, Sheets and Slides extension, click Remove.
In Drive, double-click an Excel file.
A preview of your file will open.
At the top, click Open with Google Sheets.

You can now edit, share, view version history, collaborate in real time with others and more. All changes that you make are saved to the original Microsoft Office file.

Import Excel data into Sheets

You can import data from an Excel file to a new (or existing) Sheets file. Your Excel file won't be changed, even as you change the Sheets file.

In Sheets, create a new or open an existing spreadsheet.
Click FileImport.
Choose the Excel file and click Select.
Choose an import option:
- Create new spreadsheet
- Insert new sheet(s)
- Replace spreadsheet
Click Import data.
If prompted, click Open now.

Performing Basic Operations in Sheets

Functions in Sheets and Excel

Most Excel functions are the same in Sheets. For a list of common functions, see the Sheets cheat sheet.

Some unique functions in Sheets:

Adding Charts in Sheets

In a spreadsheet, highlight the range of data that you want to create a chart for.
Click InsertChart.
(Optional) To customize the chart, click More Edit chart.

You can also add a Sheet chart to a Slides presentation.

For details about adding charts, see Add and edit a chart or graph.

Data Visualisation in Google Sheets

Add Charts to your Docs and Slides

Help people visualize data in a presentation or document by adding charts
from Sheets. If the source data changes, you can update the chart with the
click of a button.

In Sheets, open the spreadsheet and, in the chart, click MoreCopy chart.
In Docs or Slides, paste the chart.
Choose an option:
- To update the chart if the source data changes, keep the Link to the spreadsheet selected. Then, if source data changes, at the top of the chart, click Update.
- To keep the chart unlinked (not updated), select Paste unlinked.
Click Paste.

Automate tasks with macros

Macros and Apps Script help you automate repetitive tasks.Or, if you need custom functions, menus or windows, you can create them with Google Apps Script.

Record a macro:

In Sheets, open a spreadsheet.
At the top, click Tools> Macros> Record macro.
At the bottom, select the type of cell reference to use:
- Use absolute references—When you run the macro, it will only do tasks on the exact cells you select. For example, if you start in cell B1 (recording starts when you place your cursor) and then click cell D1 and bold it, the macro will always bold cell D1.
- Use relative references—When you run the macro, it will do tasks on the cell you select and work you do on other cells. For example, if you start in cell B1 and add a formula and then click cell D1 and bold it, the macro will always add the formula and then move 2 cells to the right and bold that cell.
Complete the task you want to record. When you’re done, click Save.
Name the macro.
(Optional) Create a custom shortcut for the macro.
Click Save.
Click Tools>Macros>your macro to run a macro.

Create a script:

Click Script Editor.
Create your script.

For more information, see Overview of Google Apps Script.

Overview of ad ons and macros

Gemini in Google Sheets

Use Gemini to create budgets and tables
Streamline spreadsheet building by generating formulas with explanations from a prompt, with Gemini and Google Sheets.
Help me organise
Enhanced smart fill with Gemini in sheets
Collaborate with Gemini in sheets

Gemini in google sheets

Using Gemini in Sheets

Report abuse