Exporting data from Teams Calendar to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2111309%22%20slang%3D%22en-US%22%3EExporting%20data%20from%20Teams%20Calendar%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2111309%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20for%20me%20to%20(and%20other%20members%20of%20staff)%20to%20export%20the%20Calendar%20data%20to%20an%20Excel%20spreadsheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2111309%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2112089%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20data%20from%20Teams%20Calendar%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2112089%22%20slang%3D%22en-US%22%3E%3CP%3EHI%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F952210%22%20target%3D%22_blank%22%3E%40DuncanChisholm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20connect%20to%20an%20Exchange%20calendar%20using%20Power%20Query%20in%20Excel%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20me%20my%20Teams%20calendar%20is%20my%20outlook%20calendar%2C%20so%20this%20works%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20465px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F251665i702354E535150916%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2333126%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20data%20from%20Teams%20Calendar%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2333126%22%20slang%3D%22en-US%22%3EHello%20Wyn%2C%20do%20you%20know%20if%20its%20possible%20to%20also%20pull%20in%20shared%20calendars%20with%20this%20method%20at%20once%3F%20i%20was%20able%20to%20get%20it%20working%20for%20my%20own%20calendar%20and%20this%20method%20was%20so%20much%20faster%20than%20trying%20with%20access%20or%20the%20csv%20extract%2C%20so%20thats%20for%20that%20so%20far!%3C%2FLINGO-BODY%3E
Occasional Visitor

Is it possible for me to (and other members of staff) to export the Calendar data to an Excel spreadsheet?

5 Replies

HI@DuncanChisholm 

 

You can connect to an Exchange calendar using Power Query in Excel

 

For me my Teams calendar is my outlook calendar, so this works

 

 

image.png

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.

@DuncanChisholm 


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,

Screenshot 2022-02-04 110625.png

 

and then export to excel,

 

Untitled.png

 

Cheers.