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
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.
