Google Sheets

Score8.9 out of 10

764 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

Spreadsheet

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

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

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

Kaley White View profile

Data and Systems Analyst at Radformation (51-200 employees 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

Muhammad Rohan View 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