I like using excel for quick analysis/calculations but I find it falls apart if you have like 100,000+ rows<p>Does any company make an alternative that can handle large amounts of data?<p>I don't need super fancy features, just the basics like being able to run a formula across a column or do pivot tables<p>I feel like there is an opportunity for a company to make something like this, even if it only supports a subset of excel features
Well, there are the HPC Services for Excel, were you can offload calculations to an HPC Cluster and support more rows. <a href="https://learn.microsoft.com/en-us/powershell/high-performance-computing/excel-offloading-to-azure-cluster?view=hpc19-ps" rel="nofollow">https://learn.microsoft.com/en-us/powershell/high-performanc...</a><p>its not an alternative, but maybe it helps for your use case.
Our startup, rowzero.io, easily handles tens of millions of rows and is a subset of Excel. Leave us feedback in the app if there are any missing features you need.
A relational database. Excel data generally maps well to an RDBMS. You can run sqlite, MySQL, or PostgreSQL locally on a typical desktop/laptop.<p>Excel can serve as the front-end to a “real” database.