Blockpad vs. Google Sheets vs. Microsoft Excel

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

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

• 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 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

• 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

• 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

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

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

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

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

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

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 had to use it often, but it is good.

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

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

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

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

• 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

• 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.