Google Sheets Reviews

4.7 (12,599) Write a Review!

About Google Sheets

Online spreadsheet making tool that helps in creating, editing & sharing spreadsheets in real-time through any PC, mobile or tablet.

Learn more about Google Sheets

Pros:

Even greater is that since a sheet file can be uploaded in Google Cloud, then sharing the file and having the file available for all tech supports across the university.

Cons:

Nothing about the software is glaringly bad. I have occasionally had trouble with formatting when I have had to download a Google Sheets document as an Excel file.

Google Sheets ratings

Average score

Ease of Use
4.6
Customer Service
4.4
Features
4.4
Value for Money
4.8

Likelihood to recommend

9.1/10

Google Sheets has an overall rating of 4.7 out 5 stars based on 12,599 user reviews on Capterra.

Have you used Google Sheets before?

Share your experiences with other software buyers.

Filter reviews (12,599)

Kevin
Kevin
Software Engineer in Australia
Verified LinkedIn User
Gambling & Casinos, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

I am using google sheet to organise data, generate analytics and produce report.

5.0 3 years ago

Comments: Overall I am very happy with google sheets. It helps me collect and organise data, generate reports, charts etc. And collaborate with co-workers and very easily share my sheets with friends.

Pros:

It is very user friendly and you can share with your co-workers. It has wonderful collaboration functionalities, that multiple co-workers can view or edit the same spread sheet at the same time. And you can see it at real time. It provides data analytics functions, that let you create pivot tables to generate reports, graphs, charts, etc. I can also build forms within the sheet and creating a little programming functions to automate some tasks. It can be attached within email very easily, very well integrated with gmail.

Cons:

I have used Microsoft Excel for a very long time. Google sheets have some different shortcuts that makes me get confused sometimes. Also when you enter url links into the cell, and I always accidentally click on it and open a web page, but I only want to edit that field. When data set is too big, it gets extremely slow and sometimes it crashes itself and won't even open. It would be nice if the performance can be improved.

Ali
Special Education Teacher in US
Education Management, 501–1,000 Employees
Used the Software for: 1+ year
Reviewer Source

Easy to use and very hepful!

5.0 2 months ago New

Comments: I have enjoyed the ease of using Google Sheets. More people are switching and using Google over Microsoft so it is easier to use and have others outside of the district use. It is a quick and easy way to share information, track data, and keep a log.

Pros:

I love how easy it is to create different sheets. Once you figure out how to do what you need, it is easy to use again. There is a lot you can do with Google Sheets. I have used it to track data, make a schedule, take notes, and share information with other educators. I would highly recommend this to other people (even if they aren't in education.

Cons:

The only thing I have come across that I have struggled with is creating functions for very specific things. I tried what others had said to do, but it didn't work. It wasn't terrible but would've been nice to have.

Patrick
Self in US
Arts & Crafts, Self Employed
Used the Software for: 2+ years
Reviewer Source

Keeping sheets in order with Google Sheets

2.0 2 months ago New

Comments: Overall experience with google sheets is positive.

Pros:

The part of google sheets I like the most is the ability to obtain signatures on documents or waivers remotely.

Cons:

The commenting sections in Google sheets can be deemed as unnecessary when most people in my experience will just communicate their concerns or opinions through text.

Misti
Consultant in US
Nonprofit Organisation Management, Self Employed
Used the Software for: 2+ years
Reviewer Source

GoogleSheets are a must for co-working!

5.0 4 months ago

Comments: I have had a positive experience with GoogleSheets. The features that I need to complete my work are all found within Sheets!

Pros:

GoogleSheets live in the cloud and allow for co-working with ease. With nearly all functions of Excel, GoogleSheets permit you to store your data, sort, and communicate with your team. The added bonus of it living within your Google Drive make even the most buried sheet find-able with a quick search.

Cons:

Nothing I can currently think of as a drawback.

entin
Owner in Canada
E-Learning, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Great tools

5.0 2 months ago New

Comments: when the company is generous at the beginning of the good review will come back to them. While all competitors make a better features and focus on hight prices, all beginners will stay with google to start.

Pros:

enough to do everything on a small business, easy to use

Cons:

no con, simple tool and every business will need

Vijendr
Vijendr
Insurance Professional in India
Verified LinkedIn User
Insurance, 2–10 Employees
Used the Software for: 1+ year
Reviewer Source

Google's reply to MicroSoft with cloud based spreadsheet.

4.0 2 months ago New

Comments: Google sheets is a very productive software in my industry. I use it very frequently for data compilation and payments related work. It keeps my work smooth and fast.

Pros:

Being a part of Google's eco-system this software can be used with gmail id. It's a cloud-based spreadsheet which can be accessed by our team members from their respective systems/devices. It makes this device very easy to work with. Being a cloud-based application, it is very easy to share spreadsheets among team members.

Cons:

Google sheets does not have the same functions as Excel in terms of formulas and technical aspects. Windows keyboard's shortcuts also doesn't work well with this software.

Nhlanhla
business owner in South Africa
Verified LinkedIn User
Food & Beverages, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Google sheets Review

4.0 2 months ago New

Comments: overwhelming and great experience close to the excel feel with less feature but hopefully future developments will compete with the likes of Excel.

Pros:

easy to use for personal and business use the greatest feature is the ability to have over 100 people working on one document at the same time with changes being capture as we type or change data. that is an amazing feature which makes team work easy and effortless.

Cons:

only down side is that it is an online application however at least you can save documents your device , please consider create an offline application with same feature and more.

Romell
Physiotherapist in Canada
Hospital & Health Care, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Great free alternative to Microsoft Excel

5.0 2 months ago New

Comments: Great software, easily integrates to Google Drive, easy to share files with others for collaborating on projects together.

Pros:

Very easy to use and share between different people. Provides all the functionality that Microsoft Excel provides but is also available for free making it a great alternative.

Cons:

When multiple people are using the software and making changes at the same time, the page scrolls up and down with the last edit to the document. This makes it difficult for multiple people working on the same document at the same time. Alternative solution is to have one person do the editing but collaborating over the phone or through comments on the document.

park
park
manager in South Korea
Verified LinkedIn User
Internet, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

how easy it is to use

5.0 2 months ago New

Pros:

I've been using Google Sheets for more than 5 years, and I'm extremely satisfied with the results. The spreadsheet program offers an incredibly intuitive interface and convenient cloud storage that makes it easy to access my data from virtually anywhere. With a wide range of features, like spreadsheet formulas and charts, I can quickly manipulate and analyze my data in ways that weren't possible before. Best of all, the collaborative functionality allows me to share my work with others and collaborate on projects in real-time. Google Sheets is definitely a must-have tool for anyone looking to get started with spreadsheets

Cons:

One drawback of Google Sheets is that it doesn't offer advanced formatting options like Microsoft Excel. Additionally, it can be difficult to work with large datasets due to the limit on file size and cell numbers for each sheet. Lastly, certain features and functions may not be available in some countries or regions.

Ryan
Ryan
Marketing Analytics Engineer in US
Verified LinkedIn User
Marketing & Advertising, 501–1,000 Employees
Used the Software for: 2+ years
Reviewer Source

Google Sheets is a great tool but will never be Excel

4.0 2 months ago New

Comments: It is a great program that can be used in place of Excel when it is not available but it would be rare for me to choose Sheets over Excel, all else being equal.

Pros:

I like the collaboration features and that it provides a lot of good functions for data manipulation. I also like that the pivot tables automatically update which provides a better user experience for less technical people

Cons:

Try as I might, I just cannot get used to Sheets compared to Excel. I think that Excel functions are simpler and all of the menus are in more intuitive places. I can never find the filters and data format tools in Sheets when I need them because they are in different (less intuitive) places than Excel.

Chris
Owner in Canada
Music, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Very Useful and Practical Spreadsheet Program

5.0 3 years ago

Comments: Overall, I use Sheets daily. It integrates flawlessly with other Google services as well as IFTTT and 3rd party workflow utilities. Google Assistant can update your spreadsheets by voice and the functionality is perfect for all of my needs. I require no other spreadsheets and I still find new functionality I wasn't aware of as I go.

Pros:

Google Sheets is a cloud based browser interface software. You don't actually have to install an application in order to use it. although, unless you're on a PC or Mac you'll want to anyway just for the ease of use of the app interface. Because of the cloud base all of your documents are accessible on any device that you can sign in on with your Google account. To use the software it stores your data in a free Google drive or if you choose a paid Google One storage service. The biggest point here is that if you choose not to have the massive storage you still get plenty of free space to hold as many of your free spreadsheets as you can imagine. So you can utilize these services for no cost and have all of the base functionality that any regular business or person would require. Combine the service delivery model with the the functionality of Sheets and you've got a winning formula to tackle most if not all of your needs. You can utilize formulas, traditional row column handling, paste in graphics or use charts etc. All in all, it has every major function available that the average user could need/want.

Cons:

The interface getting into Sheets can seem a bit clunky at times. Unless you're used to cloud based services you may find yourself frustrated desperately seeking the same button. It auto saves and you need to therefore be able to interface with the cloud to access your spreadsheet or think ahead and use the 'make available offline' option. The interface is a little different if you're coming from a Microsoft world so there will be a bit of a change you'll go through adapting.

Nathaniel
Systems Analyst in US
Legal Services, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Sheets: Can be very useful

4.0 3 years ago

Comments: We used sheets to replace some of our excel spreadsheets and I think overall it was a positive. It allows far more easier access to collaboration and editing, and the ability to access a sheet virtually anywhere you have the internet is amazing (phone, computer, tablet, etc.). You can leave notes for other users, create and share new books and link them to anything else. It has made tracking certain things vastly more efficient. Sheets does lack some features that excel may offer, and some of the formulas and "control" is different but I think the ability to add custom modules is far easier and can supplement the missing features. My personal experience is automating sheets is far easier than in Excel

Pros:

Being able to collaborate on sheets with others is I think the biggest draw of this application. I am able to update things on the fly and not have to worry about version management or other people using outdated data. I also enjoy being able to access sheets virtually anywhere I have internet access which means I can review/edit sheets basically no matter where I am

Cons:

Fundamental differences and missing features from excel that made the transition a little difficult. The initial conversion was probably the biggest hurdle but once those were overcome it was one of those things that I wish I had bitten the bullet and done before

Jonathan
Director in US
Architecture & Planning, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Google Sheets is great for quick collaboration

5.0 3 years ago

Comments: Google Sheets has helped us keep track of data across an organization of about 20 people very effectively. If it is properly setup, not everyone using it needs to understand every detail of it and it's very intuitive.

Pros:

I like the fact that it's very quick and simple to setup a spreadsheet for any use, with separate pages. The ability to invite multiple people and control their permissions also enables a small business to allow everyone in on sensitive information while controlling who can edit it.

Cons:

I wish it was a bit easier to setup formulas and functions. I have gone down quite a few online rabbit holes to figure out how to get it to do what I want, but it was rewarding when I did finally figure it out. If there was a better in-program tutorial for some of these functions that would go a long way.

Prem
Prem
Freelancer in India
Verified LinkedIn User
Information Technology & Services, Self Employed
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Evergreen Sheets management and tabular data management software on cloud

5.0 5 months ago

Comments: Using it since 2013 and it is the best and free to use app from google. Has build so many great things with Google sheets. Can't make an imagination without it.

Pros:

Mostly every SaaS and web apps has an Google sheet endpoint making it universal sheets usage platform to integrate, share and manage data in business with team and members

Cons:

It has limited operation capabilities t work with multiple images... Need an inbuilt image management system

Verified Reviewer
Verified LinkedIn User
Writing & Editing, Self Employed
Used the Software for: 2+ years
Reviewer Source

My go-to for documentation!

5.0 3 years ago

Comments: This is something that I use daily, as a replacement for a planner (the fact that I can so easily customize what I have on my study plan is a big benefit to me), as well as a tool for group work on the biostatistical analysis of data. It is something that is highly customizable to what you need (hence my two vastly different methods of using it), and keeps your laptop from slowing down due to either 1) large program use or 2) high amount of storage.

Pros:

As a student, there is a lot of group work that goes into different projects, especially when learning about biostatistics and other classes where complex data-driven mathematics must be done. Google sheets allow for team collaboration in the simplest way possible. Also, its a very seamless software. When compared to Excel, it does not glitch at all (whereas on my computer, because excel is such a large program, it often slows down other apps if I am multitasking, or freezes up itself). Lastly, it also frees up a lot of storage on your device! Since none of the sheets are actually stored on your computer, it won't take up memory (and is simple to retrieve, either through your google drive or through the google sheets website)

Cons:

The amount of formulas and programs that it has is slightly less than excel, and if you are working in a research lab then exporting data from google sheets to a statistical analysis program may not be compatible (since many of them require to excel as a source for data). However, if you are just looking for a simple datasheet, then this would not even be a problem for you.

Sherry
Educator in US
E-Learning, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

All the Data Functions You Need

5.0 3 years ago

Comments: I've used Google Sheets for over 10 years and it makes all my business accounting much less painful to complete.

Pros:

Google Sheets is an easy to use spreadsheet software that has all the functions needed to create accurate data analytics.

Cons:

Google sheets isn't a direct mirror of some of the more expensice spreadsheet software, but it has all the basic functions needed to run my business with ease. The feature that I miss the most from other software is the ability to sum multiple columns at once. Having to sum columns individually is more time consuming, and yet still easier and more accurate than doing them by hand.

Gia
Actor/Writer in US
Entertainment, Self Employed
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Forget Excel

5.0 3 years ago

Comments: Love it! I really love how groups of people can edit the Sheets, and that Google tracks all the changes so you can go back and see who added what.

Pros:

This FREE software has become my go-to for all things spreadsheet. I do my billing on here, track my expenses, and run out possible financial scenarios (planning to buy a house... takes a lot of planning!).

Cons:

Like any software, not everything translates perfectly, but I did just import all my dad's contacts from Quickbooks to a CSV file, and Google Sheets handled everything exactly right. That's not always the case, but that's the hazard of any program. I still don't understand the keyboard shortcuts like I did in the old days of Excel, but the online tutorials you can search for will pretty much solve whatever action you need to make in Sheets.

Crystal
Clinic Manager in US
Hospital & Health Care, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

My go to

4.0 3 years ago

Comments: I love Google Sheets and I am excited to continue to learn more about different features it has to offer. I would recommend it to anyone in a small business or someone who is wanting to get more into spreadsheets.

Pros:

I really enjoy Google Sheets above all other. It’s user friendly has many features that come in handy once you have learned them. The different tabs make it convenient to store multiple information on the same sheet while keeping them separated. Love editing and sharing is extremely efficient also

Cons:

Wish that alerts or reminder notifications were possible without having to use coding.

Sander
Product development manager in Belgium
Retail, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

The perfect answer for collaboration on data

5.0 3 years ago

Comments: This app made me a data geek. I love it for its ease of use, wide online documentation and free version to start and learn.

Pros:

The best feature that has made this product indispensable to me to this day, is the possiblity to link 2 cloud based sheets and cherry pick what data is visible to what team member. Something that is not possible with any alternative.

Cons:

The one feature that is an eyesore for me is that it is not possible to array a concatenation of text.

Andrew
Owner in US
Food & Beverages, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

SHEETS helps our business stay organized!

5.0 2 years ago

Comments: Overall, Google Sheets is a valuable resource for our small business. The ease of use, instant sharing and cross-platform compatibility is awesome. The more features we take advantage of, the better off our team is in the long run. Definitely recommend Google Sheets for anyone trying to streamline communication.

Pros:

Our business uses GOOGLE SHEETS every day. We have different sheets set up for paperless inventory, and different managers can access them to make changes. We have a lot of moving parts and changing ingredient lists, and the fact that someone can add an item to our kitchen ingredient list, and someone else has instant access is really helpful for our business.

Cons:

I have a lot of email accounts, and some of them are outside of Google. Sometimes that creates issues if there is a shared SHEET that gets sent to a non-google account. It makes sense that you have to have a Google account (not necessarily an email) but it can get tricky having to ask people to resend an invitation to a personal email address.

Josh
Owner in US
Design, Self Employed
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Amazing free option for spreadsheets

5.0 2 years ago

Comments: It is super comparable to excel and it is totally free and easy to share the doc with others in your google drive for editing.

Pros:

Google sheets is free so how can you not like it. It seems to do everything that Microsoft excel does plus it integrates with some other things I have. If you need a spreadsheet software use Sheets instead of paying for excel. I have done full budgets and even made a very simple payroll system off of it that calculates everything.

Cons:

I had used excel in the past so really the only thing was there was a little curve getting to know it and know how it was different than excel. Really the only thing that annoys me is that when you sum stuff it doesn't automatically try to find the numbers to be summed so you have to drag it.

Heather
BDC Manager/ Ordering Manager in US
Automotive, 501–1,000 Employees
Used the Software for: 2+ years
Reviewer Source

Google Sheets Is My Go To Tool For EVERYTHING

5.0 5 months ago

Comments: By far the best product on the market. I use Google Sheets for EVERYTHING. From lists for work to organizing things within my personal life.

Pros:

This product is seamless. Being able to live update documents with a team is a game changer. Comparing to other options on the market, this is by far the easiest to use.

Cons:

I would say the only thing I would like improved on this program is the process for sharing under different accesses. If I have multiple people I only want to be able to view, and others I want to be able to edit, the process of having to invite them each individually is tasking. I love the option to share the document via a link but it doesnt allow you to change the access for different links. If you change the settings it changes them for all unless you have granted them access specifically.

Summer
Animal Transport specialist in Kuwait
Import & Export, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Very inexpensive way to do schedules, accounts etc across non compliant devices

5.0 2 years ago

Comments: I use Google sheets to lay out everything that needs doing per client per date so that I can quickly keep track of what needs doing & when. I use different colours for different meanings and different sheets for completed work, years & accounting. Basically anytime I need to store raw data this is how I would do it.

Pros:

One of the best features is the fact that I can work on it off line and then it automatically updates when I am online. It also means that I can access my documents from anywhere and any device as long as I can log into google safely, whether it is android, iphone or imac. This is very important for me as I often have to be working "light" as in with only my phone on me, but I am still able to access all my data, which is really important. Feature wise, as far as I can tell it is the same as the Excel suite across platforms. The most important feature for me is that it is compatible on both the imac and android phones. As I work off both interchangeably, using excel for Mac does not work on an android phone and this really messes me up. So Google sheets is a safe alternative for me that does not give me any issues on either device.

Cons:

Honestly, I do not have an issue with it. It does what I need it to do. If I have issues I suspect it is more user error / lack of knowledge rather than a problem with sheets.

Mike
Product Manager - Consultant in Canada
Sports, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Solid Collaborative Spreadsheet Tool with the Essential Features

5.0 3 years ago

Comments: Google sheets is an excellent collaborative spreadsheet tool that allows multiple users to work on the same spreadsheet concurrently without worrying about merging files later. Google sheets can be shared with specific people within your organization or the entire organization, and even people outside of your organization with this product. Colleagues can also request to spreadsheets to receive approved access, giving secure but not excessive security. Our company has had great success by building spreadsheets internally and then sharing the finished sheet with a client. We have also had success working on sheets collaboratively with a client in the past. The “see history” feature allows you to go back in time to see who changed what and revert to a previous copy should major mistakes be made. The product provides powerful formulas as well as a scripting language that can be leveraged. There is also conditional formatting. We use this to track numerical values, as well as check lists when doing client implementations, shared directly with clients. Google sheets is an excellent online tool that makes sense to use if you are already using Google products. It can be used to track progress on projects, initiatives and even client implementations successfully. It is a very light weight tool that does not take a lot effort to get set up and start working on right away.

Pros:

The formulas that Sheets provide have good documentation within the product, and there’s also documentation online to help understand the syntax and how to use each formula. For those who are used to excel you will need to get familiar with some of the changes, but there significant overlap. Powerful formulas such as Vlookup are also available which is nice if you are used to MS Excel. For those who have used VBA in Excel, you will have to relearn the scripting language that Google sheets provides. The scripting language is functional and fun to use however it is more like JavaScript then VBA. You will need to have prior development experience in order to leverage the scripting functionality, similar to how VBA works with Excel. For those in your company who are not excel power users, then they should see very little difference between Ms Excel and Google Sheets, and should be able to easily complete the job that they have to do within Google sheets. The sharing and collaboration features are good and what you would except from a tool used internally and with clients.

Cons:

The scripting language provided is useful however I have found VBA to be far more useful at this time. Certain features such as conditional formatting and other features from Microsoft Excel are either harder to use or not available in the Google Sheets right now which ultimately makes MS Excel my preferred choice if I’m doing “power user” work. Google sheets is likely to continue to improve and bridge the gap between itself and Excel, I still however would prefer to use Excel over Google sheets if no collaboration is required on a document. The user community is not as large as Excel’s, making it harder to get help online for certain issues.

Kavindu Githsara
Kavindu Githsara
System Specialist in Sri Lanka
Verified LinkedIn User
E-Learning, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Google Sheets is the Best Collaborative Spreadsheet Tool Now a Days

5.0 5 months ago

Comments: I have been using Google Sheets for over 5 years now. No major issues so far. And it is very cost effective when comparing to the other spreadsheet solutions in the market. We don't have to put additional efforts to get familiar with google sheets. it has all the facilities as same as MS Excel. It has a very clean and useful interface. Not only that But also Google Sheets provides lots of Integration Options with 3rd Party Software and Systems in the market. Finally i should say this is a grate choice for any type of Businesses around the world to make their tasks much easier.

Pros:

Every user has a common knowledge about MS Excel since decades. The best thing that Google Sheets has is it provides all the Features and Functions that MS Excel provides. Sometimes more than that. Google sheets is a Cloud Based System. Which means anyone can access their google sheets anywhere in the world at anytime with out limitation. This should be the grate advantage of google sheets. Google sheets provides real time Editing and Sharing. That makes google sheets one of the best collaborative tools in the market today. And it is 100% Free to Use. Google sheets can be accessible via any device even your mobile phone or tablet.

Cons:

Sometimes we faced some formatting issues when we export our google sheets as a word document or pdf. Same thing happens when we import documents to google sheets.