Is there a fast/performant alternative to Excel?

Question

I like using excel for quick analysis/calculations but I find it falls apart if you have like 100,000+ rowsDoes any company make an alternative that can handle large amounts of data?I don't need super fancy features, just the basics like being able to run a formula across a column or do pivot tablesI feel like there is an opportunity for a company to make something like this, even if it only supports a subset of excel features

SvenL · Accepted Answer

Well, there are the HPC Services for Excel, were you can offload calculations to an HPC Cluster and support more rows. https://learn.microsoft.com/en-us/powershell/high-performanc...its not an alternative, but maybe it helps for your use case.

gamegoblin · Answer

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.

gregjor · Answer

A relational database. Excel data generally maps well to an RDBMS. You can run sqlite, MySQL, or PostgreSQL locally on a typical desktop/laptop.Excel can serve as the front-end to a &ldquo;real&rdquo; database.

RGamma · Answer

Use PowerQuery/PowerPivot/DAX.

Is there a fast/performant alternative to Excel?

Well, there are the HPC Services for Excel, were you can offload calculations to an HPC Cluster and support more rows. https://learn.microsoft.com/en-us/powershell/high-performanc...
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.
Excel can serve as the front-end to a “real” database.

Use PowerQuery/PowerPivot/DAX.