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
Stackby
Score 9.0 out of 10
N/A
Stackby is designed to bring together the simplicity of spreadsheets, the functionality of databases and integrations with best business APIs to let anyone build their own tools, the way they want. No coding needed. Users can build a database from scratch, import data from pre-existing sources like spreadsheets or Google Sheets, or choose from over 100 pre-built templates across multiple categories. Stackby offers over 25 unique column types like text,…
Google Sheets is a great tool mostly for people in the finance department such as accountants who have to analyze hundreds of transactions. The software makes it easy to organize data and handle some analysis. Also, when it comes to data presentation, Google Sheets offers some of the best features. However, this is not to sat people outside the finance docket cannot benefit from this software. It is a great tool to have when handling data.
Based on my experience, I can provide specific scenarios where Stackby is well suited and others where it may be less appropriate: Project Management: Stackby is an excellent choice for project management scenarios. Its ability to create custom databases, track tasks, assign responsibilities, and collaborate in real-time makes it highly effective for managing and monitoring project progress. CRM and Sales: Stackby is well suited for managing customer relationships and sales processes. Its customizable database structure allows for organizing customer information, tracking leads, managing deals, and generating reports. The ability to integrate with other tools further enhances its usefulness in CRM and sales workflows. Content Planning: Stackby is a great fit for content planning scenarios. Users can create databases to manage editorial calendars, track content ideas, assign tasks to team members, and monitor content performance. Collaboration features facilitate seamless content collaboration and ensure timely publishing.
Shifting to Sheets after years and years of Excel is like learning to crawl after I've been running for years. Some sort of translator document. Such as if you use XYZ in Excel, the same function can be found here in Sheets
Functionality shuts down after 5K or so lines are used. I work in finance. We have hundreds of thousands of transactions we need to analyze.
If Big Query is the answer to large amounts of data, it needs to be as easy to use as Sheets is.
Implement the same views available on desktop into the mobile app
Internal automations (like Airtable)
Ability to implement and display info as a dashboard (like Airtable)
Polish up the formatting of formulas, inputting them causes user frustration due to the formula input cursor jumping around
Better intelligence and ease of inputting data in bulk i.e have the fields automatically identify what data is being input and format appropriately (like Airtable does)
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.
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
Stackby is overall pretty easy to use, especially if you're used to something like Airtable or SmartSuite. Some of the pages seem like near exact clones (though they put their own creative spin on things). I'd prefer a slighty fresher interface (like SmartSuite), but I'm willing to sacrifice that for the better price and great customer service.
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.
Microsoft Excel and Numbers on Mac. Used the first reiteration of the Windows 365 and was terrible. It stacks up well against excel due to power of two other Google products 1) Google search and 2) YouTube. If you cannot find an article or video to help you might be disappointed but keep looking.
I have also tried Ora.Pm. Infinity has better graphical interface, but nowhere near as many features and the UI isn't as effective (i.e, moving around with keys). Grist has a much more technical interface and it comes from being more of a database/interactive spreadsheet vs Stackby. Grist has much more functionality in terms of formulas, but is much harder to learn to use and less other functionalities. Ora.PM is more of a test at a task management app, and doesn't compare - Stackby is much better.
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.