Power Query Problems

How to Retrieve Recurrence Details from an Exchange Calendar in Excel

Natalie Taylor Oct 8, 2026 869 views

Question details

The user needs to extract recurrence information for appointments when connecting an Exchange Calendar to Excel.

How to Retrieve Recurrence Details from an Exchange Calendar in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Connecting to an Exchange Calendar using Power Query to analyze schedule data.
Observed behavior: Recurring appointments are displayed in the connection, but recurrence information like frequency or end dates is not exposed as standard columns and remains hidden.

Before you start

Ensure you have the correct login credentials and necessary permissions to access the target Exchange Calendar. It is also recommended to refresh your Power Query data connection before modifying the query steps.

Solution 1Recommended

Expand the Attributes Field to Extract Recurrence Data

Use the Power Query Editor to navigate into the nested records of the calendar data and expand the specific recurrence fields.

When Excel connects to an Exchange server, complex data types like recurrence rules are often nested within record or table fields rather than being displayed as flat text columns.

By expanding the Attributes field, you can expose these nested properties and merge them into your main data view.

Open Power Query Editor

Go to the 'Data' tab in Excel and select 'Get Data' > 'Launch Power Query Editor', or double-click your existing Exchange Calendar query in the Queries & Connections pane.

Locate the Attributes column

Scroll through your data preview to find the column typically named 'Attributes' that contains [Record] values.

Expand the Record

Click the expand icon (two diverging arrows) in the column header. Select 'Recurrence' or related schedule properties from the list, uncheck 'Use original column name as prefix', and click 'OK'.

Combine Delimited Values

If the recurrence data spans multiple nested lists, select the column, use the 'Extract Values' feature under the Transform tab, and choose a delimiter like a comma to combine them into a single text string.

Load the Data

Click 'Close & Load' on the Home tab to bring the newly expanded recurrence data back into your Excel worksheet.

Expand the Attributes Field to Extract Recurrence Data

Data Refresh: Once configured, clicking 'Refresh All' in Excel will automatically run these expansion steps on any new calendar appointments.

Free Microsoft Office alternative

Try WPS Office for Your Spreadsheet and Data Needs

If complex Microsoft Excel connectors like Exchange Power Query are slowing down your workflow or causing compatibility issues, WPS Office offers a lightweight, completely free alternative. It provides robust spreadsheet tools, familiar formulas, and seamless format compatibility without the heavy system requirements.

1. Download WPS Office: Visit the official WPS website to download the free installation package.
2. Install the Application: Follow the on-screen instructions to quickly install WPS Office on your computer.
3. Open Excel Files: Double-click your existing .xlsx calendar data files or drag them into WPS Spreadsheet to continue working seamlessly.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsEffortlessly manage scheduling data and calendar exports with advanced data manipulation toolsLightweight application that opens large datasets instantlyFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Excel show Exchange recurrence details by default?

Excel's default Exchange connector optimizes performance by only loading top-level calendar data. Complex, nested properties like recurrence rules are kept within the 'Attributes' record and must be manually expanded in Power Query.

Can I filter recurring appointments by their end date in Power Query?

Yes. Once you have expanded the Attributes field to reveal the recurrence end date, you can use the filter dropdown on that specific column in the Power Query Editor to exclude past or future events before loading the data to your sheet.

What if the Recurrence field shows as 'Table' instead of 'Record'?

If the field is a Table, it means there are multiple recurrence rules or exceptions attached to the item. Click the expand icon on the column header, select the necessary columns, and Power Query will generate new rows for each recurrence detail.

Does refreshing the data require access to the Exchange account again?

Excel securely stores your Exchange credentials in the Data Source Settings. You will not need to log in again during a normal refresh unless your password changes or your session expires.

Excel & Data Problems