Excel has a lot of this stuff builtin as well in the PowerQuery editor [0] which supports CSV, JSON and XML data sources. Albeit not SQL, it allows you to do al

Excel has a lot of this stuff builtin as well in the PowerQuery editor [0] which supports CSV, JSON and XML data sources. Albeit not SQL, it allows you to do almost everything SQL can do, but in a GUI. After you're done preparing your data in PowerQuery you can run PowerPivot on it for aggregations. [0]: https://cdn-5a6cb102f911c811e474f1cd.closte.com/wp-content/uploads/2018/02/Main-Areas-of-the-Power-Query-Editor.png https://cdn-5a6cb102f911c811e474f1cd.closte.com/wp-content/u...