What Is Google Sheets?

What you need to know about the free spreadsheet system

Google Sheets is a free, web-based program for creating and editing spreadsheets.

Google Sheets, along with Google Docs and Google Slides, is a part of what Google calls Google Drive. It's similar to how Microsoft Excel, Microsoft Word, and Microsoft PowerPoint are each individual parts within Microsoft Office.

Google Sheets works best for those who have modest spreadsheet requirements, work remotely from multiple devices, and/or collaborate with others.

Two coworkers using Google Sheets at the same time on different computers
Lifewire / Julie Bang

Google Sheets is available for web browsers as well as Android and iOS devices.

Google Sheets Compatibility

Google Sheets is available as a web application, accessible through Chrome, Firefox, Internet Explorer 11, Microsoft Edge, and Safari. This means that Google Sheets is compatible with all desktops and laptops (e.g. Windows, Mac, Linux) that can run any of the aforementioned web browsers. A Google Sheets mobile app is also available to install on Android (running version 4.4 KitKat and newer) and iOS (running version 9.0 and newer) devices.

Google Sheets supports a list of common spreadsheet formats and file types:

Users can open/import, edit, and save/export spreadsheets (including Microsoft Excel) and documents with Google Sheets. Excel files can be easily converted to Google Sheets and vice versa.

Using Google Sheets

Since Google Sheets is available through Google Drive, one needs to first log in with a Google account in order to create, edit, save and share files. The Google account acts like a unified sign-in system that gives access to Google’s product catalog–Gmail is not required for using Google Drive/Sheets, as any email address can be associated with a Google account.

Google Sheets offers the basic and frequently-used features that one would expect when working with spreadsheets, such as (but not limited to):

  • Customize the spreadsheet and data (with autofill capability)
  • Work with rows, columns, and cells
  • Implement functions, macros, and scripts for complex calculations
  • Add charts/graphs, pivot tables, and images
  • Import and/or search for data in spreadsheets

However, there are some notable strengths to using Google Sheets versus other options:

  • Work with the same document every time — even from multiple devices, platforms, and/or locations — since files are stored in the cloud (Google Drive). Changes are automatically saved, and offline editing (via mobile app and the Google Chrome web browser) is also available.
  • Share files with others (instead of emailing multiple copies back and forth) for collaborative, real-time editing, commenting, and chatting. Google Sheets’ built-in revision history tracks all changes (both the people and edits they made) and gives users the option to restore the file to an earlier version. You can also present sheets in Google Meet. 
  • Google Chat Spaces is integrated into all Google services including Gmail, so your conversations carry over between apps. With Google Chat Spaces, you get features like in-line topic threading, presence indicators, custom statuses, expressive reactions, and a collapsible view.
  • Integration/access to other Google products, such as Google Forms (for creating/inserting feedback polls/questionnaires/surveys on spreadsheet presentations), Google Translate (cell functions for translating languages), or Google Finance (automatically finds and inputs specified finance info).
  • Easy to learn/teach and is free for individual use.

Versus Microsoft Excel

There is a reason that Microsoft Excel is the industry standard, especially for business/enterprise. Microsoft Excel has robust depth and resources that allow users to do and create practically anything. Although Google Sheets presents distinct advantages for the right types of people, it is no true replacement for Microsoft Excel, which includes (but not limited to):

  • More options for templates, customization, and advanced editing/formatting tools
  • Automatic adjustment of formulas when adding/deleting categories
  • Management and processing of huge amounts of data
  • A vast selection of charts and graphs for presenting information
  • Advanced functions/formulas ideal for finance, statistics, science, engineering, etc.
  • How do you merge cells in Google Sheets?

    Open Google Sheets > select the cells to merge > select Format in the menu bar > Merge Cells. You have the option of merging horizontally, vertically, or merging all.

  • How do you make a graph in Google Sheets?

    To create a graph in Sheets, enter all the data you want in the graph in your spreadsheet, then select all of the cells containing that data > Insert > Chart. Use the Chart Editor to choose the chart type (bar graph, pie chart, etc.).

  • How do you lock cells in Google Sheets?

    Select the cells to lock, then choose Data in the menu bar. Select Protected sheets and ranges > enter an optional description > Set Permissions. Then, choose who can edit the range > Done.

  • How do you wrap text in Google Sheets?

    To wrap text in Google Sheets, select the cells > select Format in the menu bar > Wrapping > Wrap.

Was this page helpful?