[tomnipotent]

Excel 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]

How? Through what interface, or by what feature name to Google?

[easton]

Excel 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/2...

[jodrellblank]

Thanks :)