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%3E%3CP%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%20thanks%20for%20that%20so%20far!%3C%2FP%3E%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?

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