Usama
4 December 2024 16:14
1
Automatic google sheets export works but google sheets is very limited when compared to MS Excel. Is there a way to auto export to excel? Or even a way Excel online can connect to that google sheet?
All I do is generate some useful charts from my transactions. Those charts are very hard to do in google sheets and still very limited. I am giving up on sheets and want to do all that analysis in Excel.
Revels
4 December 2024 16:54
2
Why did you post in the topic about this and then make another one?
You can do anything you want to do in excel, with google sheets. What are you trying to do that you can’t?
Exporting transactions automatically is great for keeping a backup, importing into other services etc, but I’d like to see other services available by default, such as Microsoft 365 Spreadsheets/OneDrive (personal and business versions).
I’d very much love to see a way of connecting to Power Automate as well. I know I can connect PA to a spreadsheet, but a built-in Connector direct to the API would be great.
@AlanDoe
Usama
4 December 2024 17:07
3
Sorry about that, i posted a reply in that topic
Nope, Google sheets DOES NOT do everything that excel can do.
In my case, I wanted to see the graph of my total wealth overtime.
In Excel its extremely simple.
make a new sheet with a pivot chart, filter out pot-to-pot transactions, and show running average on the chart.
In Google sheets it took way too many steps and sheets because pivot table in sheets don’t have a cumulative sum.
Make a copy of the automated sheet and in the copied sheet add column that caclulates cumulative/running …