Office 365 (Outlook 2013) - Viewing Calendar in Excel

Important: Beginning March 1st, 2017, Office 2013 will no longer be available for installation from the Office 365. Please see the following document for further details: Office 365 - Microsoft Office 2013 path to retirement.

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.
  3. 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.
  4. Right click and select Copy
  5. Open an Excel file and Paste the information.



Keywords:office 365, outlook, export, calendar, excel, windows   Doc ID:58466
Owner:Help Desk K.Group:UW-Milwaukee Help Desk
Created:2015-11-24 13:16 CDTUpdated:2016-11-18 15:01 CDT
Sites:UW-Milwaukee Help Desk
Feedback:  2   2