Google Sheets Features

Google Sheets

Cloud-based spreadsheet and collaboration platform

4.67/5 (10,792 reviews)

Google Sheets Feature Summary

  • Calculators
  • Conditional Formatting
  • File Conversions
  • Multi-User Collaboration
  • Pivot Tables
  • Templates

Competitor Feature Comparison

API
Analytics
Audit Trail
Charting
Collaboration Tools
Collaborative Workspace
Commenting
Conditional Logic
Customizable Templates
Data Capture and Transfer
Data Extraction
Data Format Management
Data Import/Export
Document Automation
Document Management
Document Review
Document Storage
Document Templates
History Tracking
Microsoft Outlook Integration
Permission Management
Project Templates
Real Time Analytics
Real Time Data
Role-Based Permissions
Scheduled Reporting
Search Functionality
Survey Management
Surveys & Feedback
Template Management
Third Party Integration
Learn moreCompare App
API
Analytics
Audit Trail
Charting
Collaboration Tools
Collaborative Workspace
Commenting
Conditional Logic
Customizable Templates
Data Capture and Transfer
Data Extraction
Data Format Management
Data Import/Export
Document Automation
Document Management
Document Review
Document Storage
Document Templates
History Tracking
Microsoft Outlook Integration
Permission Management
Project Templates
Real Time Analytics
Real Time Data
Role-Based Permissions
Scheduled Reporting
Search Functionality
Survey Management
Surveys & Feedback
Template Management
Third Party Integration
Visit WebsiteCompare App
API
Analytics
Audit Trail
Charting
Collaboration Tools
Collaborative Workspace
Commenting
Conditional Logic
Customizable Templates
Data Capture and Transfer
Data Extraction
Data Format Management
Data Import/Export
Document Automation
Document Management
Document Review
Document Storage
Document Templates
History Tracking
Microsoft Outlook Integration
Permission Management
Project Templates
Real Time Analytics
Real Time Data
Role-Based Permissions
Scheduled Reporting
Search Functionality
Survey Management
Surveys & Feedback
Template Management
Third Party Integration
Visit WebsiteCompare App

Mobile apps

iOS App


884,848 reviews

Requires iOS 11.0 or later. Compatible with iPhone, iPad, and iPod touch.

Android App


765,809 reviews

Google Sheets Feature Reviews

25 reviewers had the following to say about Google Sheets's features:

Brian Tesene

Great for colaboration

2019-04-17

Pros

Google sheets is great for collaboration. Everyone has the same documents and the same tools available.

Cons

I am not a huge fan of Google's file management interface.

Rating breakdown

Ease of use
Features

Time used: 1-2 years

Frequency of use: Occasionally

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Industrial Automation company, 201-500 employees)

Google Sheets is all you need for basic data entry and management

2019-04-23

I use google sheet's for many simple projects and data management and integrate it into automation tasks and basic project management roles.

Pros

- Easy to use - Free - Cloud Storage - Free - Full functionality spreadsheet software - Free

Cons

- Honestly there really aren't any specific cons - Maybe easier integration with other tools?

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
( company, 1001-5000 employees)

Everything you expect in Excel-like software. plus real time collaboration, and many plugins

2018-07-27

capability to share my document, again, realtime changes, with awesome access control so they can only see/view/comment. can be downloaded offline if necessary.

Pros

complete sets of feature ability to link to specific cells ability to collaborate real-time with co-workers access control goes down to the tab and cells. awesome - restriction based by email

Cons

so easy to make docs, people tends to abuse this. soo many Google Sheets document all over the place. for all occasion the fact that need to be online to edit the document they have offline capability, but not straight forward. haven't tried that myself

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
imelda rushford

Great data management.

2019-01-13

Good user interface which makes it easy to use.

Pros

Greater data management and analysis which is very reliable.

Cons

The data storage for the sheets is limited which require large storage.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
( company, 11-50 employees)

I use Google Sheets frequently in my job.

2018-06-07

Easy access, easy collaboration, great functionality, and a refined ability to download to different file types.

Pros

To be able to comment and assign tasks within the document without changing the content has become a really important part of our review and proofing process.

Cons

Often I access a document from a link a coworker sent, or by searching for it.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Daniel Palomino Maya

Best open and free alternative to the MS Office option

2019-03-25

It's the office tool I use more often, the ui is easy to understand and intuitive.

Pros

The collaborative interface as in every product of the G Suit is excellent and allows you to work with your colleagues while watch in real times the modifications and changes to the document.

Cons

This is a more limited tool than others for offline desktop, and since is an online cloud solution the quality of connection or the management of browser resources can affect the performance, so you can't just copy and paste great amounts of information without waiting some time for the information to be processed.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Kari Voliva

Easy Tool for Professional or Personal Use

2019-04-12

Personally, I have used it for wedding planning, coordinating home moves and party planning.

Pros

Although we have a lot of options for collaboration efforts at my office, my team and I keep coming back to Google Sheets for the simplicity and intuitive nature of the program.

Cons

We haven't found a good tracking system for changes.

Rating breakdown

Value for money
Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Ben Lambert

A good way to share information within small workgroups

2018-06-22

We are able to instantly share changes to documents within the workgroup, and the collaborative features make it better for collaboration than our more powerful full Document Management system.

Pros

This is especially useful where multiple users need to access or edit the information collaboratively. We extensively use the scripting features to make it more powerful.

Cons

The features of Sheets are not as good as those of Excel, and scripting is not always a painless experience.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Consumer Services company, 1001-5000 employees)

Spreadsheets that are shareable

2019-12-28

I’d probably suggest something with more features if you’re looking for a tool for project management.

Pros

I love how easy it is to share and manage access (view only, edit or comment only) to Google Sheets.

Cons

I wish there was a way to expand and condense rows within sheets, similar to what you can do in Smartsheets. I also wish all of the excel formulas worked in google sheets.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Government Administration company, 11-50 employees)

Sheets basics uses help basic workflows

2019-02-13

Pros

I like the integrations with Google's drive in document management.

Cons

I think that Google can add a bunch more integrations that other third party software companies use.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Music company, 501-1000 employees)

Google Sheets

2018-09-11

Brilliant, it is a core aspect of my day-to-day business management and I use it collaboratively with my business partner.

Pros

The ease of use compared with Microsoft Excel, without losing core features.

Cons

I hope that Google will increase functionalities that is currently created by third-party add-ons; having said that the very capacity to easily 'add-on' these features is fantastic.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Magnus Okeke

Every Company Should Document with it

2018-11-27

You can make changes on a doc and it'll automatically save.

Pros

I started using it during my product management course where we used it to setup a "Feature Table" where you compare your product's features with your competitor's features.

Cons

Google Sheets requires some advanced knowlegdge if you're looking to carryout complex tasks like calculations. You need to know the formualrs too

Rating breakdown

Ease of use
Features

Time used: 1-2 years

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Human Resources company, 201-500 employees)

Good spreadsheet application for collaboration

2018-05-18

The detailed version tracking, ability to add comments and even chat with others right there are a great plus

Pros

Sharing and permission control is easy and intuitive.

Cons

I still go to Excel as running this on Sheets can tend to be slow and I have not even explored the in-depth functionalities in Sheets as the idea of doing such complex things on the cloud with an internet connection seems like it would be really slow.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Ashish Agrawal

Google sheets is a productive tool to keep spreadsheets online

2018-03-30

It is very efficient in terms of data storage and manipulation.

Pros

Google sheets support all features and functionalities offered by Microsoft Excel.

Cons

Although It happened couple of times but basic cut, copy and paste functionalities didn't work and then i updated the browser version and things started working again.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Tiago Pigatto Lenza

Best alternative

2020-06-28

We use google sheets to track most of our experiments with marketing and to document most of our sales reports.

Pros

It’s great for collaboration and since it integrates with most softwares I consider it the best spreadsheets tool out there.

Cons

Since the software is free, most of the integrations are community based, and some are not really that great.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Krista Appel

A great versatile tool

2019-03-14

I have had positive experiences using this software to collaborate on projects with others while working remotely.

Pros

This software makes it easy to collaborate on spreadsheets with others.

Cons

I wish there were more templates to choose from.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Monthly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Troy David

Google Sheets is the best leadind spreadsheet and data analysis software.

2019-09-17

The best thing about this software is that it is the clean interface and easy management of data and files which really helps us.

Pros

The best thing about this software is that we are able to collect data automatically from the different websites and we are also able to summarize the data in a easiest way.

Cons

When this software does automatically calculation with my data then there might be some errors create.Some functions are not well documented and can be challenging to use.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Besmir Muka

I use it over excel

2019-02-27

I use Google Sheets for various business activities. From e-commerce csv to ordinary management data sheets.

Pros

Accessibility, Adaptability, Sharing, Security

Cons

Confusion and not very well data organisation tools and frames.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Higher Education company, 5001-10000 employees)

Easy to use data management

2018-09-24

Pros

It is much easier to collaborate using this software compared to Excel.

Cons

No cons in using this software - it's a great data management tool.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Eric Eduardo Weichhart

Online spreadsheets made easy

2018-09-22

I have been using this software for several years now, giving it several types of uses: workflow and task management, projects research, quick surveys between coworkers and data tracking.

Pros

Being a cloud service brings some advantages as well, such as autosave, being able to leave comments and live to edit with other users.

Cons

Also, browsing in mobile devices can be a bit hard when it comes to huge spreadsheets.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
A verified reviewer

Great collaborative tool for spreadsheets

2018-07-02

Pros

Google sheets is incredibly easy to use and collaborate with.

Cons

Document management can be difficult when it comes to sharing.

Rating breakdown

Ease of use
Features

Time used: 2+ years

Frequency of use: Daily

Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
A verified reviewer

Easy sharing and project collaboration with my team

2018-03-01

Ease of data management, file shating and project management

Pros

Google sheets provide ease of file sharing and project collaboration especially in cloud computing.

Cons

Add ons are a bit unstructured and cannot be found as in other products that includes these features in the product from the start and in the functions ribbon.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Source: Capterra
Helpful?   Yes   No
Read more
Sheikh Asif Imran

Integrates and syncs data with people and machines

2019-09-30

We have been using this online tool for all data integrations for projects and teams alike.

Pros

Team management tools or growth hacking tools can also be designed within it.

Cons

It's not easy to access Google Sheets on handheld devices without the app.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Gerardo Romero

Google Sheets helps a lot in the management of my accounts

2018-07-26

It has helped me a lot in the management of my personal and work calculations

Pros

It also offers 15GB of free storage that helps a lot.

Cons

It could offer new ways to improve its functionality, and thus be much easier for some people who do not understand the new technologies

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Less than 6 months

Frequency of use: Weekly

Source: Capterra
Helpful?   Yes   No
Read more
Michael G

A Great (Free) Collaboration Solution

2019-12-31

It allows us to speed up the rate at which we complete presentations due to real-time collaboration.

Pros

Documents are also backed up to Google Drive storage.

Cons

It doesn't have all of the same functionality as powerpoint, and it takes a bit more navigating to find documents in a browser versus accessing them locally.

Rating breakdown

Value for money
Ease of use
Features

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more