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.
N/A
Google Workspace
Score 9.1 out of 10
N/A
Google Workspace enables teams of all sizes to connect, create and collaborate. It includes productivity and collaboration tools for work: Gmail for custom business email, Drive for cloud storage, Docs for word processing, Meet for video and voice conferencing, Chat for team messaging, Slides for presentation building, and shared Calendars.
Google Sheets is great for just recording tabular information that needs to be shared with and/or edited by multiple people. Sharing and collaborating is especially convenient because Sheets is designed to be browser-based; while Excel has a browser version, it's limited compared to the desktop app. Google Sheets's editing, suggesting, commenting, and viewing permissions settings are absolutely perfect for my department. Google Sheets does not handle large datasets well. It does not load in a timely manner and often freezes. Apps Scripts fail to process large amounts of data.
I find that google workspace covers all the bases that I would need my day to day work solution to offer. Workspace is perfect if you're someone working in sales who regularly sets up and hosts meetings. The meet solution is reliable, the transcription through Gemini is almost always perfect, and the recording function is easy to use. Calendar backs this up well by being simple and easy to use. Although having the ability to share your calendar link for people to book in meetings would elevate this further. You can also never go wrong with Gmail, it is reliable, has strong spam filters and rarely ever goes down. On the flip side, despite Docs, Slides and Sheets covering the basic functionalities that you would need to create a good base level of documents, it does lack some advanced functionalities that other providers offer. Especially in Sheets, I use sheets regularly for importing and exporting data for cold outreach, it works perfectly fine for this, but if you were looking to start creating dashboards etc using sheets as the base for this, it can start to get a bit tricky and limited.
Google Calendar...amazing. I don't need to ask team members when they're busy anymore and play this game of bouncing times back and forth. All I need to do is enter their email address and it shows my calendar and theirs side by side and then select the day and time I find that works best for the both of us.
I actually prefer Google Meet over Zoom. Zoom bogs down my computer and I find their UI overcomplicated for what it actually does. Google Meet is simple and does practically everything Zoom does without needing to pay any extra money.
Sheets integrates with our CRM (Copper) so it's perfect for us. Being able to export information out of our CRM into sheets and then create pivot tables from that data makes our lives a million times better.
Pricing is a little bit higher than other services
The cost of each email inbox costs the same whether you want just email or all of the features. For example, we wanted a support email address that we could setup our support desk with. The cost of that added account is the same as the account I use with all of the features.
They removed their free tier for small organizations like mine and restricted the free tier from adding new domain names. This was likely due to abuse, but everyone lost the privilege of the free service.
There is no better solution for cloud storage and real time collaboration. The amount of features included in G Suite is unmatched and out of other things we’ve tried over the years, nothing comes close to being as great of a tool.
Overall the formula functions could improve but there's workarounds for them. Utilzing different formulas or approaches for building out accounting schedules. While collebrating with multiple team members and different departments being able to go in and see where others are on the sheets is helpful. Google Sheets overall is a great product
On the user end, it's great, probably some of the most user friendly products out there. On the admin side, it can get a little more arcane, but it's still better than a lot of other services. At worst I wrangle some CSVs to perform mass changes, but it's a far cry from the days of Powershell scripts or purely manual entry.
Like most Google products, Google Sheets rarely has outages or slowness, and when it does, connection is always momentarily restored. I can't recall a time when I've been unable to access Google Sheets but able to access other sites just fine. That said, errors aren't uncommon when handling large data volume. You know what they say about using spreadsheets as databases, but sometimes it's just the most convenient option, especially for smaller or one-off projects, and not being able to store large amounts of data hampers our ability to move quickly with scrappy prototypes or full solutions. It would be great if we could better integrate our data manipulation (Apps Script) with big data in the sheet.
Again, Google Sheets is no exception to Google's general high speed and reliability, but load times can be slow for larger amounts of data. I've used Sheets with Zapier and have used the Python API, and speed has never been an issue.
I have never contacted Google Sheets support, but Google Sheets makes it very easy to report an issue or suggest a feature from Sheets itself (Help > Help Sheets improve), and I've had mostly good experiences with support for other Google products.
My experiences of getting support have been positive. Calling in is not overly difficult, but it does require getting a PIN. The knowledge of those responding to the calls has been impressive. I have managed to work with them to fix two Google bugs that I had identified. These bugs required a some technical expertise and the support staff were able to understand the issue and forward the concerns to the appropriate persons. The first bug was fixed with 24 hours. The second bug took a little longer, but it was also more complicated to reproduce.
The major reason I use Google Sheets over Microsoft Excel and Apple Numbers is for its ability to allow multiple users to access and work on the same spreadsheet at once. This is incredibly more efficient and effective than updating and sending copies upon copies of the same Excel or Numbers spreadsheet back and forth as email attachments.
There are lots of competitors to various tools in Workspace, like Meet versus Zoom. However, Microsoft is the other big competitor I can think of for Google Workspace as a whole. To me, at least, the strength of Workspace is how easy it is to share and collaborate with others. For items that I only need for myself and can keep on my own computer, I typically rely on Microsoft Word, Excel, etc. For items that I need to share, I turn to Workspace a lot. Being able to collaborate in real-time and not having to send documents back and forth is so amazing, and such a time saver. And I love that Workspace is also a built-in tool with Dropbox now.
I'm not involved with the purchase, but I assume everything goes smoothly and that the pricing structure is predictable and reasonable. We do not get surprise fees.
Google Sheets works very well with multiple users. It's convenient to see in real-time who is collaborating in a sheet, down to the specific cell that they're viewing/editing. Linking Sheets across departments is convenient with the IMPORTRANGE function.
