TrustRadius: an HG Insights company

Google Sheets

Score8.9 out of 10

796 Reviews and Ratings

What is Google Sheets?

Google Sheets is the spreadsheet app available on Google Workspace, or standalone, with a free plan for personal use and accessible via mobile apps for iOS and Android.

Categories & Use Cases

Videos

Who Buys & Uses Google Sheets

Most Frequent Users

Top 3 industries using Google Sheets.

Based on HG Insights installation data
Powered by
View all Reviews
#1 most frequent

Professional, Scientific, and Technical Services

15.3%

16,700 installations of 109,027

“We use Google Sheets to store most of our data and agency information.”

— Director, Capaldi Marketing
Verified Review
#2 most frequent

Information

8.3%

9,028 installations of 109,027

“From keeping project records to Payments of the clients, everything in between is being handled on Google Sheets.”

— Director, Devtics Technologies
Verified Review
#3 most frequent

Manufacturing

6.3%

6,829 installations of 109,027

“The file-sharing feature also made it super easy to share files with relevant team members without having to give access to everything.”

— Managing Director, Vishisht Lifestyle
Verified Review

Google Sheets Reviews

What users are saying about Google Sheets.
View all Google Sheets reviews

Pros

  • Real-time collaboration and simultaneous multi-user editing across teams.
  • User-friendly interface and ease of adoption for data tasks.
  • Effective for comprehensive data organization and tracking (e.g., project, inventory, budget).

Cons

  • Lacks advanced functionality and specific features compared to Excel (e.g., rigid pivot tables, fewer shortcuts).
  • Limitations and complexity in certain formulas and functions.
  • Performance degradation and crashes when handling very large datasets (e.g., >10,000 rows).

Google Sheets - what else?

Incentivized
Verified User
Engineer in Information Technology (501-1000 employees)

Use Cases and Deployment Scope

I use Google Sheets almost every day to do my job. I always have to do some complex comuptation, statistics and it's a fantastic tool to manage easily all the computation I have. Whatever is my issue : scheduling, assessing options, project plan estimation, it's a very easy tool. What I really appreciate is the capability of this tool to keep the history of cells modifications. Thanks to that I can know who changed what. futhermore it's feasible to put comment to explain why a change occured.

Pros

  • table mangement
  • being able to sort from criteria
  • manage cells history
  • comment management

Cons

  • manage images in cells
  • having an app available for Windows (like Google Meet add-on)

Return on Investment

  • It helps me increase my productivity by 30% when I have to manage project plan estimation
  • Templates available in Google Sheets make me go faster (saving 20 min each time I need to create a spreadsheet)
  • My capability to interact with my coworkers is better thanks to the comment management

Usability

Alternatives Considered

Microsoft Excel and Apache Airflow

Other Software Used

Miro, Slack, Google Slides

Not the most powerful but good at what it does.

Incentivized
Andrew Defever
Teacher at Big Rapids Public Schools (51-200 employees)

Use Cases and Deployment Scope

Most users integrate Google Sheets with Google Forms to compile data, whether survey data or analysis of assessment results. Because multiple people can edit a sheet in real time, most spreadsheets shared across groups or teams use Sheets rather than Excel, regardless of purpose.

Pros

  • Collect/organize data gathered through Forms.
  • Allow for live collaboration within groups or teams.
  • Improved equation features and functionality.

Cons

  • Inability or difficulty setting up mail merge with other Google Suite programs (i.e. Docs).
  • Less "Advanced Functionality" than competitors, which limits the operations you can perform in Sheets.
  • Struggles with large data sets leading to slow performance or crashing.

Return on Investment

  • 100% of students trained in use of Google Sheets before graduation.
  • Students use sheets to compile/analyze survey data.
  • 70%+ senior students use sheets to create and use an advanced calculator.

Usability

Alternatives Considered

Microsoft Excel

Google sheets is an obvious choice.

Incentivized
Jamie Capaldi
Director in Marketing at Capaldi Marketing (1-10 employees)

Use Cases and Deployment Scope

We use Google Sheets to store most of our data and agency information. Google Sheets is highly versatile, easy to use, and accessible anywhere, making it the perfect choice for sharing information internally and with clients. Google Sheets is also integrated with several external tools, making it a strong choice.

Pros

  • Ease of use.
  • Load speed.
  • Accessibility.
  • Sharing ability.

Cons

  • Can stall or hang.
  • Features are basic.
  • Formatting options could be better.

Return on Investment

  • Manage multiple.
  • Clients
  • Live data feeds for lead generation.
  • Auto populating for campaigns.

Usability

Alternatives Considered

Microsoft Excel and Airtable

Other Software Used

PhantomBuster, Instantly, Google Drive

Google Sheets - Excellent for Fostering Teamwork!

Incentivized
Steve Crawford
Youth Pastor at Grace Bible Church of Hutchinson, KS (1-10 employees)

Pros

  • Helps coordinate accurate data
  • Helps eliminate inefficiencies and unnecessary busy work
  • Helps us prepare guests lists and rosters for events

Cons

  • Quicker response time when scrolling (seems jarring at times)
  • Better printing formatting (when you want to print a spreadsheet)
  • More aesthetically pleasing (sometimes appears very basic)

Return on Investment

  • Google Sheets has allowed us to put on successful major events
  • Google Sheets has allowed us to improve our inter-office teamwork and coordination
  • Google Sheets has helped us reduce inaccuracies and embarrassing mistakes

Alternatives Considered

Microsoft Excel and Apple Numbers

Other Software Used

Google Calendar, Google Drive, Mailchimp, Apple Numbers, Todoist: To-Do List & Task Manager, Wix, Zoom

Great Collaborative Spreadsheet Software

Incentivized
Kaley WhiteView profile
Data and Systems Analyst at Radformation (51-200 employees)

Use Cases and Deployment Scope

My department uses Google Sheets to track information such as task assignments and regulatory requirements. We also occasionally use it for data analysis and visualization. We do have a few more advanced Google Sheets that include Apps Scripts.

Pros

  • Collaboration, especially simultaneous
  • Document sharing
  • Connecting multiple Sheets

Cons

  • Tables. It's way behind Excel in this respect!
  • Missing some useful formatting, like sub- and superscripts
  • Color picker is not as usable as Microsoft Office's

Return on Investment

  • Suggestion mode has saved us so much time with redlining!
  • As a Google shop, my organization loves Sheets's seamless integration with other GSuite tools, especially GDrive.
  • Automations, such as formulas and Apps Scripts, have saved the finance and sales teams a bunch of time.

Usability

Alternatives Considered

Microsoft Office 2016 (discontinued)

Other Software Used

Airtable, Zapier, Google Drive