Office 365 (Outlook 2016) - Viewing Calendar in Excel

This document explains how to export a calendar from outlook into excel

Current versions of Microsoft Outlook no longer allow calendars to be exported in a format that can be opened in Microsoft Excel. However, with these steps it is possible to view the calendar information in Microsoft Excel. Unfortunately, this will only work for Windows users.

Windows

  1. Select the calendar you wish to export.
  2. In the View tab in the main menu bar, select Change View and then List. This will display your calendar in a list rather then in a calendar view.


  1. Select the range of appointments you would like to transfer by clicking the first one, holding shift and then clicking the last. This will highlight the whole range.


  1. Right click and select Copy
  2. Open an Excel file and Paste the information.