Forum Discussion
Exporting data from Teams Calendar to Excel
Is it possible for me to (and other members of staff) to export the Calendar data to an Excel spreadsheet?
You can connect to an Exchange calendar using Power Query in Excel
For me my Teams calendar is my outlook calendar, so this works
Hello Wyn, do you know if its possible to also pull in shared calendars with this method at once? i was able to get it working for my own calendar and this method was so much faster than trying with access or the csv extract, so thanks for that so far!
- If you have permissions to access I think so
Wyn Hopkins no luck. i made sure the shared calendar is checked so it shows but its only pulling calendar data for my email address.