Google Sheets vs. Microsoft 365

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.

Incentivized

Office everyday things since time immemorial. It's hard for Google Suite or any other to compete with Microsoft. They have everything, and it all works great, with incredible tools and capabilities. The new integrations work seamlessly most of the time, such as embedding a Power BI in a PPT. Expecting too much AI, like note taking, or LLM-based PPT, is not available in my tier at least, so depending on the budget, you won't get all you may expect from an AI leader. For diagramming and process maps, you're better off with other tools like those above.

Incentivized

• It is a cloud-based platform.
• You can work in the same file simultaneously with your colleagues.
• It allows you to share files much faster.
• It allows you to access your Google Sheet files whenever you like and wherever you like if you have stable internet connection.
• It has great integration with other Google software.
• Google Sheets is very user-friendly and very intuitive to use.

Incentivized

• It allows us to keep our email organized. I like the fact that I can create folders in Outlook, and they replicate on my mail server.
• Excellent for drafting and saving those documents as PDFs without needing PDF editing software.
• Spreadsheets - what more is there to say?

• Pivot tables are different but could be improved upon; sort, totals, filters
• When entering negative numbers as the first in a formula you need to remember to "+-100+25" instead of "-100+25"
• The power of the internet of course makes it easy to find solution, but the help function is not easily available
• Color coding changes on the cell, but there is not an easy way to click on a cell and use the selected color; like excel

Incentivized

• Microsoft 365 really needs to work on protection part. In complex environment it is not reliable as compared to its competitors like Proofpoint. There are many instances where it fails to perform effectively.
• In SharePoint Online the versioning feature of the document needs to be improved by Microsoft. Sometimes when we have to roll back to the previous version it does not work as expected.
• In Teams messaging and app permission policies can be improved. There are some settings where we have to add a lot of things manually.

It is easy to use, free of charge for basic functionality, and easy to share with people within or outside your team or company

Incentivized

There are many features of Office that we cannot replicate in any other tool. Plus people know it already. It's not going away anytime soon.

Incentivized

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

Incentivized

It being the default office suite means it's user experience and idioms are things that everyone is generally very used to and fluent with.

The sharing is relatively simple, being directly hooked into Entra AD, and expiry being a first class concern.

It's usability decreases at scale, with multiple people simultaneously making edits can make documents unusable.

Incentivized

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.

Incentivized

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.

Incentivized

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.

Incentivized

Over the past 8 years of using Microsoft 365, I have noticed that they change vendors often. This always leads to a poor experience in the beginning, then levels out after some time for the company to get things worked out. As a customer, it is really frustrating because I don't have time when something isn't working to have them "look into my issue" and get back with me. They have even closed a ticket I specifically told them to keep open. Your applications are only as good as the support.

Incentivized

Everything works and I use it all the time.

Incentivized

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.

Incentivized

Its very user-friendly, collaborative and efficient that boosts productivity using cloud tools. their security is strong and it provides data protection. There are regular updates that shields us from attackers too. It offers a wealth of learning resources, including tutorials, help articles and video guide to help users make the most of the application and personally upgrade their skills.

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.

Incentivized

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.

Incentivized

• We've used it to prepare quick budgets, presentations for funds that have helped raise money
• It has helped us quickly analyze raw data, collaboratively.
• it has helped us work more efficiently by making it easier to work from one sheet and not lose track of versions by passing around attached documents

Incentivized

• It has helped keep the high-energy culture my company has since it allows easy communication and calls.
• Positively impacts responses from clients, since we can see how many times they have been contacted. (the more someone is contacted, the less likely they are to respond. Microsoft helps make sure we all know who and who not to contact)
• positively impacts my ability to focus, since you can mute notifications. Since I look at my computer all day, it is helpful to lock in and not get distracted by the many emails I receive a day. You can also change preferences, so emails with high urgency are still seen.