Export calendar events to Excel
You can save the events of a calendar to an Excel workbook (.xlsx), for a report, a planning meeting or a hand-over. The same window can also copy all events of the chosen days into your own Outlook calendar.
Export events to Excel
Open the calendar and show what you want in the file. The sources switched on in the legend, the Categories filter and the search text apply to the export.
Select the Export to Excel icon at the right end of the calendar toolbar, after My view and Print.
My view, Print and Export to Excel at the right end of the toolbar In the Export to Excel window, check From and To. They start with the days of the current view. You can export up to 366 days at once.
The Export to Excel window opens with the days of the current view Select Export. Your browser downloads a file named after the calendar and the dates, such as Council meetings (demo) 2026-10-26 - 2026-11-29.xlsx.
If there are no events in the chosen days, the window says No events in this period. and no file is created.
What the file contains
The workbook has one sheet with one row per event. A recurring event gets a row for each of its occurrences in the chosen days. The column headings are in the language of the app.
| Column | Content |
|---|---|
| Title | The event’s title |
| Start | Date and time; for an all-day event, the date only |
| End | Date and time; for an all-day event, its last day |
| All day | Yes for an all-day event |
| Calendar | The event’s source, as the legend names it |
| Details | The text the calendar shows next to the title, such as the location or the organizer |
| Categories | The event’s categories, separated by commas |
| Description | The description as plain text, without formatting |
The file is built in your browser.
Add all events of a period to your Outlook calendar
The Add to my calendar button in the same window copies every event of the chosen days into your own Outlook calendar.
- Select the Export to Excel icon and choose From and To.
- Select Add to my calendar. The window shows the progress, for example Adding 3 of 12….
- When it is done, the window shows a summary: Added: 9. Already in your calendar: 3. Not added: 0.
- The same filters apply as for the export: only the sources, categories and events that the view shows are copied.
- Each occurrence of a recurring event becomes a separate event in your calendar. To copy a series as one recurring event, use the event’s own menu, see Add events to your Outlook calendar.
- An event you have copied before is not copied again; it counts as Already in your calendar.
- Events that are already in your own Outlook calendar are skipped, and so are events of meeting rooms, internet calendars (iCal) and Google calendars. If none of the events can be copied, the window says No events in this period can be added to your calendar.
- Up to 200 events can be copied at a time. For more, the window asks you to choose fewer days.
- The copies have no attendees, so nobody receives an invitation. What a copy contains.