Others

How to Export Microsoft 365 Active User Data with Street Addresses

Algirdas Jasaitis Sep 28, 2026 869 views

Question details

The user needs to export a complete list of active users from Microsoft 365 that includes their street addresses, but this specific column is missing from the data export.

How to Export Active User Information and Street Addresses in Microsoft 365

Product: Microsoft 365 Admin Center
Device & OS: not provided
Scenario: An administrator is attempting to export active user directory data for organizational or administrative purposes.
Observed behavior: The standard Microsoft 365 active-user data export is incomplete because the street-address column fails to appear in the exported file.

Before you start

Ensure you have global administrator or user management administrator privileges in your Microsoft 365 tenant, as standard users cannot access the Admin Center or create tenant-level service requests.

Solution 1Recommended

Submit a Service Request in the Microsoft 365 Admin Center

Since community forums lack the backend administrative access required to fix incomplete tenant data exports, you must open a direct support ticket with Microsoft.

This specific export issue requires investigation by Microsoft support engineers who have the necessary tools to access administrative logs and enable the missing data fields for your organization.

Log in to the Admin Center

Navigate to the Microsoft 365 Admin Center and log in using your administrator credentials.

Navigate to Help & Support

On the left-hand navigation menu, click on the 'Support' section and select 'Help & support' (or 'New service request').

Describe the Issue

Type a brief description of your issue, specifically stating that the street-address column is missing when you attempt to export active user information.

Submit the Ticket

Follow the on-screen prompts to submit the service request so a Microsoft support engineer can review your administrative data and resolve the export issue.

Submit a Service Request in the Microsoft 365 Admin Center

Administrative Permissions Required: If you are not an administrator, you will not see the Support option. You must ask an administrator in your organization's IT department to create this service request on your behalf.

Free Microsoft Office alternative

Easily Manage Your Exported User Data with WPS Office

Once Microsoft Support resolves the issue and you successfully export your active user list, use WPS Office to easily open, filter, and format your CSV or Excel files. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office.

1. Install WPS Office: Download and install WPS Office for free on your device.
2. Open the Application: Launch WPS Spreadsheets from the main WPS Office dashboard.
3. Import Your Data: Click 'Open' and select your newly exported Microsoft 365 user data CSV or XLSX file to begin managing your records.

Fully compatible with Microsoft Excel (.xlsx) and CSV formatsEasily filter, sort, and manage large user data exportsFree, lightweight, and fast-loadingFamiliar user interface ensuring seamless migration with no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why is the street address column missing from my Microsoft 365 user export?

By default, certain user properties might not be included in standard quick exports from the Microsoft 365 Admin Center, or there may be a backend syncing issue in your tenant requiring Microsoft Support to intervene.

Can standard Microsoft 365 users export active user data?

No, exporting full active user lists with detailed organizational data requires administrative privileges, such as Global Administrator or User Management Administrator roles.

How long does it typically take for Microsoft Support to resolve a service request?

Response times vary based on your organization's Microsoft 365 subscription plan and current support volumes, but standard administrative requests are typically addressed within 24 to 48 hours.

Office Quick Solutions