Data Import & Export

Fix the Missing Active Directory Connector in Microsoft 365 Excel

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

Find or restore the From Active Directory data connector in Microsoft 365 Excel.

Fix the Missing Active Directory Connector in Microsoft 365 Excel
Product
Microsoft 365 Excel
Device & OS
not provided
Scenario
The user wants to import Active Directory data through Excel's Get Data interface.
Observed behavior
The From Active Directory option is missing, including after Office was updated and reinstalled.
Before you start

Open Excel and check File > Account for the installed Office version and update channel. Menu names and connector availability can vary by platform and Microsoft 365 release.

Solution 1Recommended

Check Excel's Get Data Menu and Ribbon Settings

Look for the connector in its current menu location and check whether the command is available for the ribbon.

1
Open Get Data

In Excel, select Data > Get Data and look under From Other Sources for From Active Directory.

2
Inspect ribbon commands

If the option is missing, open File > Options > Customize Ribbon. Under Choose commands from, select All Tabs, then expand Data > Get & Transform Data > Get Data and look for From Active Directory.

3
Add the command if available

If the command appears in the list but not on the ribbon, add it to a custom group using the Add button, then select OK.

Check Excel's Get Data Menu and Ribbon Settings
Menu availability varies: If the command is not listed, ribbon customization alone cannot restore it. Check your Excel version, platform, and connector availability.
Free Microsoft Office alternative

Work With Exported Directory Data in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Excel formats. If your administrator can export directory data to a spreadsheet or CSV file, you can open and work with it in WPS Spreadsheets. WPS does not restore Excel's Active Directory connector.

Open and analyze exported directory data in a spreadsheetCompatible with Microsoft Excel XLSX and XLS filesOpen CSV exports for straightforward data reviewFamiliar spreadsheet interface helps make migration easyFree and lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Where should the Active Directory connector appear in Excel?

When available, look under Data > Get Data > From Other Sources > From Active Directory. The location and availability can vary by platform and release.

Can I add the connector back through Customize Ribbon?

Open File > Options > Customize Ribbon and look under All Tabs > Data > Get & Transform Data > Get Data. If the command is listed, you can add it to a custom group. If it is not listed, ribbon customization cannot make it available.

What should I check if reinstalling Office did not help?

Open File > Account and About Excel to record your version and build. Then ask your administrator or Microsoft Support to verify the update channel, platform, license, and connector availability.

Can WPS Office fix the missing Excel connector?

No. WPS Office cannot restore a Microsoft Excel connector. However, WPS Spreadsheets can open directory data exported separately to formats such as XLSX or CSV.