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.
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.
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
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.
Collaborating in Google 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.
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.
Most Excel functions are the same in Sheets. For a list of common functions, see the Sheets cheat sheet.
Some unique functions 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
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.
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.
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.
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.
Click ToolsScript editor.
Create your script.
For more information, see Overview of Google Apps Script.
Overview of ad ons and macros
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
