3 ms·
Most people have no clue these features exist, or that Excel even has advanced data modeling that supports all sorts of goodies including strict types and joins
by tomnipotent 5y ago
Most people have no clue these features exist, or that Excel even has advanced data modeling that supports all sorts of goodies including strict types and joins/merges/appends. It's not as accessible as just basic sheets, but I've had no problem crunching millions of rows of data in Excel with sub-second response times.
- piyh 5y agoPowerquery is great, but too bad it breaks with version upgrades.
- jjtheblunt 5y agoisn't excel limited to just over a million rows?
- tomnipotent 5y agoExcel 2013 and later has a columnar database capable of handling millions of rows, but not through the standard sheets interface so it loses a lot of the utility people are used to.
- jodrellblank 5y agoHow? Through what interface, or by what feature name to Google?
- easton 5y agoExcel refers to it as the “Data Model”. It allows joining tables/sheets and referencing them from other tables. https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/23/introduction-to-the-data-model-and-relationships-in-excel-2013/ https://www.microsoft.com/en-us/microsoft-365/blog/2012/08/2...
- jodrellblank 5y agoThanks :)
- blowski 5y agoYes, although you can have multiple sheets each with a million rows. Kind of like sharding. But I’d be fascinated what kind of system spec is required to get good performance on those kind of numbers. I’ve been on a Mac for years, where Excel is crippled by limitations.
- LegitGandalf 5y agoWorking with a Mac for the first time this year, excel on Mac is actually worse than excel 2010 :(