Share via

Exporting a Teams Calendar

Anonymous
2024-08-01T18:47:49+00:00

Hello, I am trying to export our Teams calendar into Excel. I see the option but regardless of which month I am currently viewing I only get August and little bit of September.

Is there a way to get the entire year?

Microsoft Teams | Microsoft Teams for business | Files | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2024-08-05T13:39:13+00:00

    Dear Suzanne Kean1

    Thanks for your feedback!

    Based on your further description, may I know whether using the list view and copy paste is resolved your issue? If yes, could you kindly submit your feedback and vote. You could help any other community users who might be facing a similar scenario to easily find this thread/post.

    If not, please feel free to let me know, I will continue to assist you.

    Thanks for your precious time and your understanding would be highly appreciated. Have a nice day! 

    Sincerely, 

    Allen | Community Moderator

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-05T12:55:09+00:00

    Hello and thank you for your reply.

    I am using a group calendar so the option to "copy calendar" does not see to be there. I will need to use the list view and copy paste. Thank you!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-05T12:37:18+00:00

    Dear Suzanne Kean1

    Thanks for your response! Very sorry for late reply!

    Based on your further description, may I know whether you are using classic Outlook? If yes, and if you would like to export shared calendar to Excel/csv, you can do following steps:

    Go to your calendars in Outlook and change the view to list view>right clicked on your shared calendar and clicked "Copy Calendar">From there, created a folder to copy the shared calendar to, that was under your personal account. (You should be able to paste it anywhere under your exchange account)>Once the shared calendar was under your personal account> go into File > Open & Export > etc. select the shared calendar that was copied into your personal account to export as a csv.

    You can also use a list view and copy and paste the events into Excel or a text editor. If you need to export just a few items or use a filter, this works well and is just as fast as exporting to excel.

    About changing view: just click calendar button>choose calendar which you want to export>click the view button on the top>click change view option>choose list

    If you are using new Outlook, please switch back to classic Outlook, you can refer to toggling out of the new Outlook for Windows preview.

    Thanks for your precious time and your understanding would be highly appreciated. Have a nice day!

    Sincerely,

    Allen | Community Moderator

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-02T12:46:16+00:00

    Thank you for your reply. I originally tried doing this in Outlook but the calendar does not appear in my options list. Perhaps b/c it is a group calendar? I have editing rights to the calendar

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-08-02T03:24:56+00:00

    Dear Suzanne Kean1

    Good day!

    Thank you for posting to Microsoft Community. We are glad to assist!

    Based on your description, I understand you concern with exporting a Teams calendar into Excel.

    You can sign into Outlook with this account. Teams calendar is also show in Outlook calendar.

    • In classic Outlook, go to the calendar view.
    • Click on “File” > “Open & Export” > “Import/Export”.
    • Choose “Export to a file” and click “Next”.
    • Select “Comma Separated Values (CSV)” and click “Next”.
    • Choose the calendar you want to export and click “Next”.
    • Select the location where you want to save the file and click “Finish”.

    Open in Excel: Once the file is saved, you can open it in Excel to view and manipulate your calendar data.

    If you still have the issue, please feel free to let me know, I will continue to assist you.

    Thanks for your precious time and your understanding would be highly appreciated. Have a nice day!

    Best regards,

    Allen | Community Moderator

    Was this answer helpful?

    0 comments