Google Sheets vs. IBM Apptio vs. Microsoft Excel

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)

We use IBM Apptio exclusively for application TCO reporting. It compiles data from different sources then export to Excel to customize report for the user. Our intention is to start a TCO dashboard within IBM Apptio, so Excel is no longer required and leadership can drill down. We are also trying to fully automate our cloud billing.

Incentivized

I don't really know another program as powerful as Excel. I've used Google Doc programs but do not feel they come close. So far, anytime I've needed a table of some sort for data, whether it's budget oriented or information off a survey, the best system has been Excel. We do web audits on occasion and we create an Excel worksheet featuring every URL of the pages we're auditing, notes, data about the content, information about files attached to the page and other information to help us determine what pages need updating, deleting or otherwise. We also use Excel primarily to export our Google Analytics to in order for us to create reports for clients that need to see specific information about their traffic.

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

• Does very well at handling complex allocations and automation. Also great at bringing in data automatically, manipulating that data, and allowing you to feed that data into a complex model. So all the behind-the-scenes stuff works really well. It's also pretty good at visualization. It has some similar capabilities like a Power BI and Tableau, but generally provides most of the visualization technology that somebody would need with the tool.

Incentivized

• It is very good at embedded formulas and tying cells to one another
• It allows me to compare deals terms on a side-by-side basis and talk my clients through it easily.
• It is very helpful as well in terms of allowing me to filter/sort results in many different ways depending on what specific information I am most interested in prioritizing.

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

• For Validation purpose, if possible, enable the JavaScript code so we can the hide the Tab based on current period and more validation we can perform on client side.
• Sometimes we are faced the data load issue
• Improvement the performance tunning

Incentivized

• Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
• Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
• Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.

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 absolutely love it at the State of Kansas. It is very user-friendly, which helps us explain the information to those who are not as into the budgets. We consult out with Marysville, and they are super helpful in helping us with the behind the scenes stuff, like creating new tabs and uploading the reports for us to filter through. It is very simple to use and that helps us be able to teach others in our department how to use it properly.

Incentivized

Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.

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

We use this currently where I work and we have the consultant Maryville helping us with our Apptio reports and data. I originally used Apptio a few years back and since then I have switched employment, and I was able to talk to the leadership team about what we did at my previous job, and now we are building the reports here at my new place of employment

Incentivized

I'm giving it a 7 because it is my go to. But the fact other prefer Google Sheets when working with a team does get irritating. I've used the online version of Microsoft Excel that other teams can get into and it still seems behind Google Sheets. It's a little clanky and slow? If that's even a term.

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

Excellent, so far. SaaS-based...assuming effective data links and connectivity

I have rarely, if ever, had issues with its availability.

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

No issues that i know of

Incentivized

Excel load and performs calculations immediately. It integrate well with all Microsoft Office applications and does not slow them down.

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

I have not been directly involved with the post sales support team. However, that team has provided training materials and recommended practices that have been very helpful in coming up to speed on how to more fully use the product. My understanding from both vendor management and our upline stakeholders is that our relationship with Apptio is strong.

Incentivized

I have not had to use it often, but it is good.

Incentivized

Was awesome to have been taught by legendary Debbie Hagan for Cost Transparency in person. Her knowledge is extensive and she is an excellent trainer. Her years of experience really shined.

Incentivized

The all talented training organization crosses all the T's and dots all the I's. I am constantly learning and often refer to training documentation for post training real life issues.

Incentivized

Well, so far. Apptio Consulting covered specific model architecting areas particularly. Most of the heavy lifting is being done in-house with support from Apptio as it relates to tool impacts and needs. Some administrative tasks were redundant

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

So we've used Proven Optics, which is an add-on to ServiceNow. Well at least use it with certain customers and Nicus. Nicus is probably the biggest competitor of Apptio. The trouble with Nicus is their SQL-based ingestion process. It's a little bit more difficult. So the reason why you'd go with Apptio is that it's very easy and very intuitive to bring in new data sources and being able to model a lot of the data once it's already in the system doesn't require a lot of coding experience.

Incentivized

Out of Microsoft Excel, Microsoft Power BI, IBM SPSS, and Google Sheets, Microsoft Excel is by far the most common tool used for anything data-related across organizations. Accordingly, our organization has also implemented Microsoft Excel as a first-step tool. We recently adopted Microsoft Power BI (the free version), and use it occasionally (mostly for creating dashboards), but it is less commonly understood by stakeholders across our organization and by our clients. Accordingly, Microsoft Excel is more user-friendly and because of its popularity, we can easily look up how to do things in the program online. Google Sheets is a comparable alternative to Microsoft Excel, but because it's cloud-based and we have sensitive data that needs to be protected, we chose against using this software. Finally, a few users (including myself) have access to and utilize IBM's SPSS. For my role, it's a helpful tool to do more rigorous analyses. However, because of its cost and limited functionality as a simple spreadsheet, we only use it for more complex analyses.

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

I was not part of this process

Incentivized

N/A I was not involved in this process.

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

I would say it has the capabilities to span across multiple departments, though i am not as familiar with all the capabilities.

Incentivized

Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise

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

• It's delivered on a lot of those, especially the relationship between IT and financing that relationship's been a bit of a rollercoaster on that journey. We've come out the other end of it, and we're all friends now, which is a good thing. So they've accepted the Apptio output and are much more involved in providing the data and helping to use the tool, which is excellent. I think one of the downsides that are probably not talked about enough is the fact that, um, once you have trained and delivered a TMB skillset within your organization, they become very good at that. So if you've got any high-performing members in that team, they become extremely valuable elsewhere. And we've unfortunately suffered the case whereby one of our highest performers was immediately then poached and went off elsewhere for a much better opportunity. So we applaud that for them, but it's really hard to train other people. It's really hard to take them up to speed, and you have to sort of go through those picks and troughs every time. So that's just life, you know.

Incentivized

• Excel has positively impacted the business as it has increased our efficiency.
• It also saves us the time that we would have spent on making the calculations that it does for us.
• Since it works on all devices and is compatible with both Windows and Mac, we do not have to invest in any other alternative.