Feb 02 2021 07:43 AM
Is it possible for me to (and other members of staff) to export the Calendar data to an Excel spreadsheet?
Feb 02 2021 06:48 PM
You can connect to an Exchange calendar using Power Query in Excel
For me my Teams calendar is my outlook calendar, so this works
May 06 2021 02:09 PM - edited May 06 2021 02:22 PM
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!
May 07 2021 02:14 AM
May 07 2021 06:58 AM
@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.
Feb 04 2022 08:09 AM
The solution provided doesn't really seem to solve the generic problem, of how to export a teams calendar to excel because for me at least it is not linked to Exchange. I was able to export the data by opening the calendar using the web view and then clicking "Export to Excel"
Open in web view,
and then export to excel,
Cheers.