Skip to content
Blink Brief
Language:

Guide · Office and email

How to export your Microsoft Teams calendar (as .ics, to Excel or to Google Calendar)

By Blink Brief · Updated  · How pages are made

Microsoft Teams has no export of its own. Its calendar is your Outlook calendar: Microsoft says a meeting you schedule in Teams "will automatically appear in your Outlook calendar, and vice versa." So export it from Outlook. In Outlook on the web or new Outlook, publish the calendar (Settings › Shared calendars › Publish a calendar), copy the ICS link, and turn it into a file with the tool on this page. In classic Outlook for Windows, File › Save Calendar saves a date range as an .ics file. Then open the file in the free ICS viewer: Download for Excel (.csv) makes a spreadsheet, and Print or save as PDF prints the list.

Short answer

  • Outlook on the web or new Outlook: Settings › Shared calendars › Publish a calendar › Publish › copy the ICS link › open it to download the .ics › Unpublish.
  • Classic Outlook for Windows: File › Save Calendar › More Options › Date Range and Detail › OK › Save.
  • To Excel or a PDF: ICS viewer › Choose an .ics file › Download for Excel (.csv), or Print or save as PDF.

Teams' calendar is your Outlook calendar

Microsoft's Teams help: "When you schedule a meeting in Teams, it'll automatically appear in your Outlook calendar, and vice versa." The Calendar in Teams shows the calendar of your work or school account, the same one Outlook shows. We found no export command in Microsoft's Teams help; the export steps Microsoft gives are Outlook's. So sign in to Outlook with the account you use in Teams, and export from there.

Which Outlook you have decides the route. Outlook on the web (in a browser) and new Outlook for Windows publish the calendar as a link; classic Outlook for Windows saves a file directly. Going the other way, adding an .ics file to Teams, is in adding an .ics file to your Teams calendar.

Outlook on the web or new Outlook: publish, then download the .ics

Microsoft's steps for Outlook on the web:

  1. In Calendar, select Settings.
  2. Select Shared calendars.
  3. Under Publish a calendar, choose the calendar and how much detail people can see. For a full copy, choose the level with all details; with less, the file holds only times, or times with titles and locations.
  4. Select Publish. An HTML link and an ICS link appear.
  5. Copy the ICS link.

In new Outlook for Windows, Microsoft's path is the View tab › Calendar settings › Calendar › Shared calendars, then the same Publish a calendar steps. Microsoft says of the ICS link that "recipients can download the ICS file and import it into Outlook": opened in a browser, the link gives you the file. The tool below checks the link, gives you a button that opens it, and then checks the file you downloaded.

Turn the ICS link into a file, then check it

To do it by hand:

  1. Paste the ICS link into the address bar of a browser and press Enter. The file downloads.
  2. Open the file in a text editor, such as Notepad or TextEdit. It should start with BEGIN:VCALENDAR, and each event starts with BEGIN:VEVENT.
  3. The SUMMARY: lines hold the titles. If your meetings' titles aren't there, publish again with more detail.

If the button opens a calendar page instead of downloading a file, you copied the HTML link: copy the ICS link. If the browser shows an error, or the check says the file is a web page or empty, the link was copied wrong or the calendar is no longer published: copy the ICS link again from Shared calendars. The tool's hint about iCloud links is for iPhone calendars; an Outlook ICS link starts with https://. If the titles are missing, you published with less detail: change the level and copy the new link.

Classic Outlook: File › Save Calendar, with a date range

Classic Outlook for Windows (Outlook for Microsoft 365, Outlook 2024 and Outlook 2021) saves the calendar as a file with no link involved. Microsoft's steps:

  1. Open the Calendar and select the calendar you want to export.
  2. Click File › Save Calendar.
  3. Use the default name or type one in the File name box.
  4. Click More Options.
  5. Click the Date Range arrow and choose how much to include, or click Specify dates.
  6. Click the Detail arrow and choose how much detail to include.
  7. Click OK, then Save.

Microsoft calls the result "a snapshot of the calendar": later changes don't follow. It also warns that a large date range or Whole calendar "might create a large iCalendar file". For a list of the next few months, a date range is the better choice. The check above reads this file too.

Publishing is turned off (a work or school account)

Microsoft notes: "Calendar sharing may not be available for your account, or may be limited to people in your organization, depending on your organization settings." If Publish a calendar is missing or offers only busy times, your organization decides it, not Outlook. Then:

  • Use classic Outlook's File › Save Calendar if your organization still gives you classic Outlook.
  • Don't count on new Outlook's .pst export: Microsoft says "Calendar and contacts items saved in .pst files is not available in new Outlook at this time."
  • Ask IT whether calendars may leave the organization at all. Copying a work calendar to a personal account can break a company rule even where it works.

The admin settings behind publishing are named in exporting your calendar from new Outlook.

To Excel or a PDF: the ICS viewer

Open the ICS viewer and click Choose an .ics file, or drop the file on the box. It lists the meetings with their dates, times, time zones, places and notes: the first 500 of a larger file, up to 20 MB. It reads the Windows time zone names Outlook writes, such as "W. Europe Standard Time".

  • Download for Excel (.csv): every event as a row, with its title, start and end dates and times, time zone, place and notes. A repeating meeting is one row, with how it repeats in its own column. The ICS to Excel guide has the details.
  • Print or save as PDF: prints the list alone, without the buttons, on A4 or Letter. Choose Save as PDF in the print window for a PDF.

The file you open is read in this browser tab and never uploaded. When you press Add to Google Calendar or Add to Outlook, that one event's title, times, place and notes go to Google or Microsoft in the link that opens their calendar. Close the tab and the file is gone; nothing is saved. To show your Teams meetings in a personal calendar as busy times only, without titles, the free Busy Calendar tool makes a busy-only copy of the file.

To Google Calendar

A copy, from the file. Google's steps, on a computer: click Settings, then Settings; in the menu on the left, click Import & export; click Select file from your computer and pick the .ics; choose the calendar to add the events to; click Import. Google notes that "guests and conference data for that event are not imported." Import into a new, empty calendar if you may want to remove the whole copy later.

A calendar that keeps updating, from the link. In Google Calendar on a computer, next to "Other calendars", click Add other calendars › From URL, paste the ICS link and click Add calendar. Google: "You can only add a calendar with a link if the other person's calendar is public." A published Outlook calendar is, for as long as it stays published, so don't unpublish it if Google subscribes. More in adding an .ics link to Google Calendar.

A few meetings only. In the ICS viewer, press Add to Google Calendar under each one. Each press adds one event.

Unpublish when you're done

While the calendar is published, anyone who has either link can read it at the level you chose, without signing in. Once you have the file, unpublish it. Microsoft's steps for Outlook on the web: in Calendar, select Settings, select Shared calendars, and under Publish a calendar, select Unpublish. New Outlook has the same Unpublish under Shared calendars. Keep it published only while another calendar subscribes to the link.

Questions

How do I export my Teams calendar to Excel?

Teams has no export; its meetings are in your Outlook calendar. Get an .ics file from Outlook: publish the calendar in Outlook on the web or new Outlook and open its ICS link to download it, or use File › Save Calendar in classic Outlook. Open the file in the free ICS viewer and press Download for Excel (.csv): each event becomes a row with its title, start and end dates and times, time zone, place and notes.

Can I export my Teams calendar to Google Calendar?

Yes, through Outlook. Export the Outlook calendar as an .ics file, then in Google Calendar on a computer click Settings › Import & export › Select file from your computer, choose a calendar and click Import. To keep it updated instead, add the published ICS link in Google Calendar with Add other calendars › From URL; it works for as long as the calendar stays published.

Sources