Google Sheets vs. LibreOffice vs. Microsoft 365

Google Sheets is well suited in two main areas: is free to use and you don't need to buy a license to use it, comparing to the most direct competitors ; collaboration is in my opinion the best advantage, with multiple people working together and seeing others working in real time. It's less appropriate in low connectivity environments (offline capabilities)

If you're working with numbers, LibreOffice doesn't get in your way and try to make changes as it sees fit, forcing you to repeatedly go back and undo processes you didn't want, didn't ask for, and that have no place in the document you are trying to produce. All I want to do is assemble the data, process it for the task at hand, and then print it for distribution. LibreOffice allows me to do that.

Microsoft 365 would be well suited for medium to large enterprises. This is where there are several hundreds or thousands of people. Since most everyone has used one of the applications the learning curve would be reduced. Another reason would be the ability to implement security measures to prevent access to sensitive data. This could justify the cost of an Enterprise license.

Incentivized

• Collaborative planning : In the initial phase of project, Team leads and architects create a permission matrix along with the naming convention simultaneously, seeing who is editing / adding the details in real-time.
• Cost tracking : We use this tool to track cloud resource usage monthly costs, so that we can analyse it and send out comms for high cost based resources. By storing cost data here, it's easy for use to store data of last couple of years.
• Flexible documentation : For change logging of different scenarios we would need different / ad-hoc columns to be added on the fly, which makes using this tool much simpler then reputed third party tools.

Incentivized

• Tools like speeling, grammar, and thesaurus are super fast and intuitive
• Read-only content can be created by adding a section and password
• The right-click menus are very intuitive and change on the fly with what is needed depending on the content and situation
• Documents can be saved natively as *.docx or *.xlsx

Incentivized

• Chat with teams and the integrations with the other apps, and many more smaller ones, like to-dos, news, and the recent Outlook integration.
• Easy embedding on SharePoint to broadcast all the content created in the different tools.
• The office package is still robust with the good things from the past and new additions.

Incentivized

• Ease of use - I collaborate with a lot of folks on these and a lot of them have trouble using it.
• Would love more live features; for example, being able to have cells react to other inputs (checkboxes, etc) with reactive formatting
• More cross-usability with other Google products; it's hard to think of drawbacks honestly, this is a pretty seamless software.

Incentivized

• It doesn't provide all the functions it should with a paid subscription.
• There are features that are only available with Premium and I have premium and they are still not available.
• Paying for the premium version doesn't provide additional services than free version
• Customer service is nonresponsive and has been nonresponsive for years even prior to COVID.

• Forms lack comprehensive features and parameters for detailed questioning for example cannot be directly linked with Power BI
• Outlook email filters are not handy to use and require more detailing in terms of location past emails
• Teams requires substantially large amounts of system resources which could be finetuned

Incentivized

I am not involved in the purchase/selection process, but my organization is a Google shop, and Sheets meets most of our spreadsheet needs and works seamlessly with our other tools. I don't anticipate our switching anytime soon.

Incentivized

We use it consistently and have a lot of documents in the OpenDocument format so it will be necessary to use LibreOffice or a compatible product such as Openoffice in the future to be able to open these files. Because the license fee for Libreoffice is zero it is not very costly to keep using it - the costs are mostly for keeping it installed on the office PCs and regularly updated, and solving employee issues with the user support.

Incentivized

So far the Microsoft 365 platform provides features and tools that can cater to 100% of present organizations needs considering both technical and business necessities, however most features are not been effectively utilised at present. The current featureset is able to cover for most of the future needs of the business and technical functions.

Incentivized

It can easily handle most uses and functions. It is only for very large datasets or advanced analysis that it either lacks the proper functions or performance begins to slow. Most employees who continue to use competitors' products do so out of preference, familiarity with the user interface, or other surface-level reasons.

Incentivized

For all of the reasons in the foregoing evaluation. Its menus are clean, intuitive and straightforward. Any function I need to use can be accessed via keystrokes, without having to stop, move my hand to the mouse, deal with it, and then get back to the keyboard to proceed. It helps me keep my mind on my work and not worry about dealing with the mouse all the time.

Microsoft 365 is the gold standard for performing project tasks in a professional environment, enabling the quick transfer and exchange of files and ideas for team members who work locally and remotely. Its suite of tools is familiar and has evolved to being cloud based, allowing for files to be updated in real time from near and far.

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

Libreoffice is a desktop app not requiring any server part so it is always available when the PC is working normally. Installing it on another machine if one PC fails is very quick and easy. This is a non-issue.

Incentivized

To-date Microsoft 365 platform has offered an amazing uptime and availability percentage per year compared to all other products which provide the stability and overall business resilience of their ecosystem which is a great relief for information technology service entitites which heavy rely on Microsoft offerings as a whole to redeliver their own custom products

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

For big/imported tables or text documents with images loaded from the internet it is sometimes getting very slow, RAM and CPU intensive, and sometimes even hangs due to some memory leaks or other bugs. This is a long-term problem and is still not resolved perfectly.

Incentivized

The Microsoft 365 tools expects and demands a substantial amount of system resources to operate at optimal level and even more when integrated with other applications which is a downside, however given that external supporting tech factors such as fibre/broadband speed bandwidth, high speed RAM and ample storage resources are allocated the tools work error free providing robust communication

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

Support is not officially offered. However, you can find answers to any usage questions or trouble-shooting online easily, typically starting with a Google search. (I believe that all forums / tips for OpenOffice apply equally to LibreOffice, and vice versa.) While Microsoft Office, for example, officially includes support, I find that typically you end up going to a Google search in any case. So, this is not really a downside. However, in all these cases, you end up doing a lot of figuring things out for yourself.

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

The resellers involved with selling Microsoft products are reluctant to provide in person specialist trainings to consumers due to the fact of costs of economies of scale and is not provided free of charge most of the time. In Person trainings needs to be agreed to at the initiation of projects and implementations for better ROI.

Incentivized

The standard training offered with 3rd part resellers are fairly standard and covers the basic workability however the trainings needs to be specifically customised according to unique requirements of the organizations. for example an MSP would need to master specific communications verticals within Microsoft 365 whereas and online store using Microsoft 365 would needs to master a different set of tools within the suite to get the best ROI post implementation.

Incentivized

Generally easy to perform, issues are how to ensure regular automatic updates on Mac OS X. Fortunatly we have only a few machines with OS X run by management and we can do these updates manually occasionally. Windows updates are quite easy with the support of third party software such as Ninite or Chocolatey, and Linux updates are super-easy thanks to the package manager (apt-get).

Incentivized

The Microsoft support partners are more than capable of handling implementations and dealing with unprecedented errors during the implementations. Not part of the implementation though the setup was done with minimum misconfigurations which is evident with present live setup which works fine without any bugs and gaps at present context.

Incentivized

I have found that I can do almost everything I could have done in Microsoft Excel faster and easier in Google Sheets. We recommend Google Sheets in 99.9% of our use cases and feel it meets the needs of our workers very well. I am sure there are other spreadsheet creation programs out there, but because we are already in the Google environment, adopting Google Sheets in very easy.

Incentivized

I think it is fair to say this:

• If you are looking for a well-rounded, GNU-licensed product that will encompass word processing, spreadsheets, presentations, and database then LibreOffice is probably all you need.
• For online collaboration, links with cloud storage, and more robust support, Microsoft Office 365 and Google Docs are probably what you or your organization needs.
• LibreOffice is at its best for regular document creation and spreadsheet management. It is more cumbersome when it comes to fonts but also when it comes to linkages with cloud-based services. It is there, but you need some more computer knowledge to make it work.
• There are other free alternatives, most notably Apache Open Office, which is also a very good alternative if you do not like LibreOffice.

Having said that, I honestly think off-line computers or laptops used off-site can certainly benefit from having LibreOffice installed.

Incentivized

Typically I prefer working with companies with Microsoft 365 as their main tool because they're usually a fast growing company with a global presence. I like using it for work because it's easy to collaborate, share, review, comment, reply in any of the tools. The mobile app for Outlook and Teams are lifesavers when we're constantly traveling and you can join meetings on the mobile Teams to never miss a beat.

Incentivized

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

Microsoft pricing is not very expensive and yet not very cheap as well, and it hovers in between the baseline. The charges are mostly based on the tier level partners who charge based on their individual reputation in the market. Power negotiation will lead to cost effective and attractive pricing

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

With more users using it in the company there are more cases when a simultaneous editing of the same document is needed and this feature is lacking in Libreoffice even though the files concerned are shared and synced by some solution (we use ownCloud). Google Docs or MS Office365 via Sharepoint/Onedrive offer a better function for this.

Incentivized

Multiple tools within the same platform have been deployed successfully within different functional technical and non technical teams such as Devops, SOC, NOC, Shared services, Managed services, Global Information technology, Cloud operations, Finance, Administration, human resources and all these teams collaborate while maintaining central uniformity in terms of global standards who are dispersed in different geographical locations with ease

Incentivized

Have not directly obtained professional services from Microsoft but rather obtained specialized services such as implementations and configurations, setting up and integration support with Microsoft authorized suppliers, 3rd parties, and resellers, which has been a pleasant experience. Again the level of delivery quality on professional services is based on the level of hands on exposure of the 3rd party

Incentivized

• Don't need to pay for windows 365 license as it is free
• Has a positive impact since I am not cursing excel for annoying problems(I don't want the new Pivot table format, I want to use Classic and I don't want to expand/collapse arrows. "x$#%")
• [Haven't] looked at return on investment on work, but has "simplified" for basic and medium spreadsheets.

Incentivized

• I am able to quickly create and edit word processing documents and spreadsheets which are for all intents and purposes equivalent to documents I could create and edit in other tools such as Microsoft Office and Google Docs/Sheets.
• Lack of an online portal for sharing documents necessitates the use of Google Sheets for automation/integration. Ideal would be an all-in-one solution.
• Having open-source software that provides common functionality eliminates the need for expensive licenses.
• Lack of dedicated support is negligible. Most issues can be resolved using online search.

Incentivized

• We have a lot of nonprofit users, so they have a good ROI.
• I like the constant updates without having to purchase the software repeatedly.
• I used to purchase each Office (insert year here) often, so the software was up to date and had the newest options and connectors. I think my return on investment would have been much better if Microsoft had updated those versions to keep them current; after all, we did pay for them.
• Microsoft 365's offering a monthly fee or a discount for a year helps, and you can look at it as a free backup if you have everything set to back up to One Drive. (Cloud-based document filing you can access anywhere ( with an internet connection)—you Can't beat that!)