TrustRadius: an HG Insights company

Google Sheets

Score8.9 out of 10

781 Reviews and Ratings

Get a Demo

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

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).

Not the most powerful but good at what it does.

Incentivized
Andrew Defever
Teacher at Big Rapids Public Schools (51-200 employees 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 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 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

Google Sheets is just awesome

Incentivized
Muhammad RohanView profile
Director in Information Technology at Devtics Technologies (1-10 employees employees)

Use Cases and Deployment Scope

I use Google Sheets pretty much every single day across almost every department. From keeping project records to Payments of the clients, everything in between is being handled on Google Sheets. For our marketing side, we put campaign performance data into Google Sheets, things like Google Ads metrics, SEO tracking, social media KPIs, and build out custom dashboards for clients.

Pros

  • Data Entry
  • Calculations
  • Sorting
  • Custom Macros
  • Project Management
  • Tracking
  • Marketing

Cons

  • Pivot tables are functional but they feel rigid compared to Excel

Return on Investment

  • Improved the data management
  • Records keeping
  • Tracking
  • Marketing

Usability

Alternatives Considered

Microsoft Excel and Airtable

Other Software Used

Google Ad Manager, Google Analytics, Google Search Console

Good for organization and structure

Bridget Griggs, Ph. D.View profile
Talent Management Advocate in Human Resources at HopHR (1-10 employees employees)

Use Cases and Deployment Scope

We are currently using Google Sheets to manage some of our candidate pipelines on the potential and archived sides of the business. It makes it easy to collaborate in real-time on some of the tasks we need to complete on any given day. Right now, it is being used, in some capacity, by the entire company.

Pros

  • It is a great way to collaborate in real-time with any member across the organization.
  • It easy very easy to create formulas, data validation options, and pivot tables for data analysis.
  • It is a great way to see the revision history and changes that other collaborators have made on the document.

Cons

  • I was using Google Sheets for more but I moved to Airtable because it is easier to quickly sort the information into groups for better visualization.
  • I find the filtered views to be useful but if there were more flexibility on moving the data around, that would be great.
  • The above two points were my major reason for leaving Google Sheets for some parts of the business.

Return on Investment

  • Google Sheets has allowed me to stay organized with all of our potential clients in one place.
  • Google Sheets allows for layering through the different views and filtering you can establish, making an effective tool to create a follow-up sequence.
  • Google Sheets goes beyond just being a spreadsheet. It also allows me to organize when contracts are nearing completion and set up a protocol for next steps.

Usability

Alternatives Considered

SeaTable and Airtable

Other Software Used

SeaTable