The Ramp for Excel plugin sounded very appealing, but I was expecting a bit more.
Instead of just loading the transaction details into a new sheet, I was expecting that it would allow me to build PivotTables and PivotCharts connected directly to the RAMP data online that I could refresh (e.g. like providing a PowerBI dataset / or something similar). That would have allowed to create custom Excel dashboards for all types of things that refresh with the click of a button.
Maybe there still is a way, is the API that the Excel App uses available to be used directly by users? Then I could use PowerBI with PowerQuery to download and refresh all the data daily and build my own dashboard based on that. I already tried to do that with the official API, but the data is quite nested within the JSON structure that it takes a bit of time to transform every into a simple table. Whereas this Ramp for Excel tool spits out everything nicely into one table.