Outlook Calendar export/report

Cliona McCabe 11 Reputation points
2022-03-11T16:46:40.543+00:00

Our audiologists are using colour-coded entries in their Outlook calendars to show different types of appointments they have with their clients. Is it possible to use Outlook calendar to get a report on how many different types of appointments they have put their calendars in a particular date range?

Outlook Management
Outlook Management
Outlook: A family of Microsoft email and calendar products.Management: The act or process of organizing, handling, directing or controlling something.
4,920 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Faery Fu-MSFT 17,116 Reputation points Microsoft Vendor
    2022-03-14T08:50:11.45+00:00

    Hi @Cliona McCabe ,

    According to my test, it is feasible, here are the steps for your reference:

    1. Export the Calendar to a CSV file.
      Choose File > Open & Export > Import/Export > Export to a file.
      182754-export-a-file.png
      Choose Comma Separated Values.
      182755-comma-separated-values.png
      Now, select the “Calendar” option in the folder list and click the “Next” button.
      182772-calendar.png
      Click the “Finish” button, you’ll be given the option to choose the start and end dates for the data you want.
      182736-finish.png
      Choose a date range and then click the “OK” button. Every appointment within that date range will be exported.
      182746-range.png
    2. In the CSV file, filter on the color categories.
      182782-filter.png
      182763-type.png

    If the answer is helpful, please click "Accept Answer" to help other people
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.