Google Sheets Pricing, Features, Reviews & Comparison of Alternatives

Google Sheets

Spreadsheet software

4.67/5 (9,397 reviews)

Google Sheets overview

Pricing

Value for money

Devices

Web-based

Markets

United States

Google Sheets reviews

Excellent
6,655
Very good
2,382
Average
341
Poor
16
Terrible
3
Value for money
Features
Ease of use
Customer support
  4.8
  4.4
  4.6
  4.4
Mazyar M. Hedayat, Esq.

The Only Way to Spreadsheet

Used daily for 2+ years
Reviewed 2018-12-22
Review Source: Capterra

Overall, I couldn't organize my office, my work, maybe my life, without Google Sheets. It is still far and away the best solution to represent the abstract, then make the abstract concrete and specific, then put data into effect. Frankly, I probably over-use Sheets sometimes - as if it were a database instead of just a spreadsheet. But it's so tempting to put every kind of information into Sheets and let the visuals inform you. I could go on, but you get the point. This is "the" Google product in my office.

Pros
Easy to use. Super-flexible. Dynamic - move rows and columns by dragging and dropping. No need to cut and paste. None of that "Insert Cut Cells" like with Excel. Of course there is amazing integration with other Google products and third-party apps. Then there is the whole "cloud" aspect, which is life-changing. Once you experience real-time collaboration from anywhere, you really can't go back. Then there are the intelligent graphs it creates from data. Information makes much more sense when represented visually, and Sheets does that instantly and effectively.

Cons
Despite its rapid improvement over the past few years, in some ways Google Sheets is still playing catch-up with Microsoft Excel. For instance, Sheets still provides no easy way for the user to drag and drop large numbers of cells. Try it and you get an awkward exercise in counting, guessing, and hoping that an action does not result in a mess. Then there are the byzantine "scripts" you have to type in to automate cells or get a desired result. I'm not a programmer. And the way in which Sheets makes the user guess whether it even has certain features at all. There are hundred "little things" like these that need improvement and could bee seen as "bugs." Or maybe Google just doesn't want to be the office standard. But I don't believe that. So yes, Sheets has a way to go, but it's on the right track.

Rating breakdown

Ease of use
Features

Likelihood to recommend: 10/10

Minimize review

Luis Daniel Rodriguez Vega

The best spreadsheet online :D

Used weekly for 2+ years
Reviewed 2019-12-24
Review Source: Capterra

I honestly don't even use Microsoft Excel anymore, since it's a great value for the price of free and it does everything Excel does and you can coillaborate with others.

Pros
How robust it is for an online application and how good it can handle complex formulas and allow you to online-share and live work with coworkers when analyzing data. Also the options to export it as an .xls and mobile app offerings that can allow me to keep track of the ranges of application data I need to use. You can share the links with permissions and if you're in a group/organization you can also keep the files safe for coworkers. Exporting is great too for working with Excel and same with importing excel documents.

Cons
Sometimes the mobile offering can lack a bit. It's mostly based for basic data viewing and nothing too heavy and complex. Same with trying to open the link on an mobile phone. If there's a lot of tabs with data, it can be really laggy and take a while to load. Also sometimes importing stuff from Excel won't show appropiately because they are Microsoft propietary so keep in mind when importing excel spreadsheets.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Likelihood to recommend: 9/10

Minimize review

Nicole Jones

Life Saver to Those Excel Novices

Used daily for 2+ years
Reviewed 2019-11-29
Review Source: Capterra

Overall Google Sheets sweeps the competition. I've switched back and forth between the two and always come back to Google Sheets. The learning curve is shorter, and it's more team-friendly.

Pros
EASY TO USE! Many business professionals have been trained in Excel, taken classes, and watched many YouTube videos trying to make an equation happen. Well, Google Sheets has simplified that. Selections are easier, mass deletions are easier, equations make a little bit more sense, and duplicating pages are simple as they should be. If you are doing basics to intermediate work on the excel, then Google sheets may make your life easier. AND YOU CAN SHARE IT WITH THE GROUP! Sharing a live document is the best part about Google Sheets; it allows for a team to work collaboratively on a document to get a quicker result.

Cons
The only con to Google Sheets would be for the Advanced user. There are fewer features and things you can do with Google Sheets, so if you are an accountant, or in acquisitions maybe stick with Excel. For the rest of the population, Google Sheets rocks.

Rating breakdown

Ease of use
Features

Likelihood to recommend: 10/10

Minimize review

Sofia Gomez

Recent access glitches

Used daily for 2+ years
Reviewed 2019-05-17
Review Source: Capterra

It’s been great up to these access issues which are locking people out. Several searches for solutions have not been able to resolve this issue, including Google Sheet resources. It’s been very frustrating and worrisome due to the sensitive information managed in these files.

Pros
Great for working in teams and staying in sync

Cons
Recently, google cloud products such as sheets or docs have been locking our accounts out every few minutes (revoking access). Even to the file owners (who have max control).

Rating breakdown

Value for money
Ease of use
Features
Customer support

Likelihood to recommend: 3/10

Minimize review

Andrea Sims

Almost as good as Excel

Used daily for 2+ years
Reviewed 2019-12-11
Review Source: Capterra

I do most, if not all, of my record-keeping in Sheets. It's length can be continued on and on without bogging down your computer like a large Excel file would. And being able to access it from anywhere at any time is a major plus.

Pros
Sheets is almost as good as Excel, but with slightly fewer features. My favorite thing about it, though, is that it's free and automatically saves to the cloud, meaning it can be accessed by just logging into your account from anywhere with an internet connection. Also very useful is being able to share it with others and collaborate on documents simultaneously, which is great for team projects. It also has a mobile phone app which is convenient for quick, on-the-fly changes. That is mainly why I switched from Excel.

Cons
It does have slightly fewer features than Excel, but mostly ones I can live without. I'm sure there's a way to do macros in Sheets, but that requires plugins and the like and I'm not quite advanced enough to do that. I also wish there were optional in-app tutorials on things like how to write a specific formula or whatever.

Rating breakdown

Ease of use
Features

Likelihood to recommend: 9/10

Minimize review

Kevin Wang

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

Used daily for 2+ years
Reviewed 2019-12-10
Review Source: Capterra

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.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Likelihood to recommend: 10/10

Minimize review

Neels Van Niekerk

Swiss Army Knife for Online Operators

Used daily for 1-2 years
Reviewed 2019-12-02
Review Source: Capterra

I literally use it everyday. Here are some examples: 1. Online workspace when I work on different computers in different locations. I always work on the latest (auto backed-up) version of the sheet. 2. One of the coolest and most powerful features is to provide data input sources for Data Studio (Google's powerful graphing tool). Output reports from for instance Facebook Ads reporting into a csv file, then upload that CSV into a Google Sheet . Then import that Sheet as data source into DataStudio and create amazing graphs and reports. And I automate the whole process with scheduled reporting and uploads to make it set and forget. Efficiency and automation is of great importance in my small business. That's why Google sheets really is a huge value adding tool for me.

Pros
1. The Powerful Formulas (for instance Arrayformula which lets you populate column(s) of data via complex calculation or manipulation with one formula in the top cell. 2. Regular Expressions built in - enables very clever data manipulation and filtering 3. Easy integration with other Saas tools like Chatbots, Charting tools, etc - provides memory, computation and automation to your process flows 4. Online storage - always available from anywhere and any computing device

Cons
1. The range select procedure is not very user friendly - make it closer to Excel way of doing. 2. When you copy rows or columns, provide the option to insert the copied rows or columns at the destination (like Excel). Currently you can only paste (overwrite). So you always need to make space before copy /paste which is unnecessary effort

Rating breakdown

Value for money
Ease of use
Features
Customer support

Likelihood to recommend: 10/10

Minimize review

Akshay Toshniwal

Google Sheets Review

Used daily for 2+ years
Reviewed 2019-11-07
Review Source: Capterra

The overall experience is really great, easy to use, and simple. The tool is not at all complex and very easy to use. It can be accessed anytime, anywhere and that makes Google Sheet really a great tool to work with!

Pros
Google sheet is an extremely easy to use tool that helps in managing data, work, and updates in real-time. Right from formulae creation to working with charts and graphs, the tool has it all and is very simple to use. The best thing about Google Sheet is the versioning system, where the last revisions and versions of the sheet is stored and it can easily be restored or viewed for updates whenever one wants. Besides this, being open-source, it helps in implementing great data analysis with almost zero to minimal cost. Highly recommended tool to be used in any organization

Cons
Few features in Google Sheet are either very difficult to use or not very user-friendly when compared to similar software like MS Excel like template options, multiple designs and formatting options and more. Considering all the advantages of Google Sheets, the tool still lacks few features and functions which need a lot of updates and fixes.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Likelihood to recommend: 10/10

Minimize review

Joshua Daum

Google Sheets is great for individual and collaborative use.

Used daily for 2+ years
Reviewed 2019-11-05
Review Source: Capterra

I use Sheets for almost everything I do: meeting registration and check-in, financial tracking, event signup, project planning, media management. I even built a relational database entirely in Sheets (it runs a little slowly -- Sheets is NOT a database platform -- but it works for our organization size).

Pros
Google Sheets offers an excellent (see what I did there?) spreadsheet experience with easy team collaboration and loads of extensibility. I can share a sheet with collaborators and have easy-to-use, granular control over access levels from team member to team member, down to the individual spreadsheet cell! Google Apps Script means that if there's a feature you need that Sheets doesn't have, you can create it.

Cons
My only issue is that I can't customize the menus the way I could in Microsoft Excel. The finicky little differences in functionality between Sheets & Excel used to bother me, but that has fallen off over the years.

Rating breakdown

Ease of use
Features

Likelihood to recommend: 10/10

Minimize review

Aijaz Ahmad Zende

Create your sheets online with ease.

Used daily for 2+ years
Reviewed 2019-12-04
Review Source: Capterra

For basic and mobile purpose, Google sheets is the best option. Using it in mobile app for carrying the documents in cloud and can download from anywhere. It does all your basic calculations easily.

Pros
It's a cloud based platform awesome for collaboration. One can work on the Google sheets from anywhere and from any part of the world with just simple internet connection. Just like other Google products the interface of Google sheets is very simple and doesn't require any special training. It does have a lot of functions to work on. Files can be shared with others and can be edited simultaneously with autosave function which saves the file in the cloud every second. The mobile application of Google sheets is as good as the web interface. Regular updates are awesome. Pivot tables are great.

Cons
It is good for basic spread sheets. More tools need to be added for complex functions. Requires internet connection everytime.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Likelihood to recommend: 10/10

Minimize review

Google Sheets features

Audit Trail

Additional information for Google Sheets

Key features of Google Sheets

  • Multi-User Collaboration
  • Templates
  • Calculators