Exchange Online Migration CSV Format for Administrator Credentials
Question details
The user needs to know the correct CSV format for migrating to Exchange Online, specifically whether an administrator credential can be used in place of individual user passwords.
- Product
- Exchange Online
- Device & OS
- not provided
- Scenario
- Setting up a batch email migration to Exchange Online using a CSV file for user provisioning and authentication.
- Observed behavior
- The legacy Domain/Admin_UserName/User_UserName format fails or is unsupported for Exchange Online, requiring a different standard format.
Ensure you have global administrator access to your Exchange Online environment and determine the specific migration endpoint required for your tenant before creating your batch file.
Use the Standard Supported CSV Format
Exchange Online requires standard column headers with individual user credentials for basic migrations, rather than legacy administrative credential formats.
The legacy Domain/Admin_UserName/User_UserName format is primarily designed for certain on-premises Exchange scenarios. Exchange Online generally does not support substituting a single global admin credential for individual user passwords within the legacy CSV batch format.
Launch your preferred spreadsheet tool, such as WPS Spreadsheet, to create a new blank workbook.
In the first row, type the exact following headers in columns A, B, and C: EmailAddress, UserName, Password. Do not include spaces before or after the text.
Fill out the subsequent rows with the destination email address, the source username, and the specific account password for each user.
Click File, choose Save As, and ensure the format is set strictly to CSV (Comma delimited) before uploading to the Exchange Admin Center.
Utilize Modern Migration Endpoints
If you require delegated administrator authentication, switch from a basic CSV batch migration to a modern hybrid endpoint.
Manage Your Migration Spreadsheets Seamlessly with WPS Office
While resolving complex IT tasks like Exchange migrations, you need a reliable spreadsheet tool to format, clean, and export your CSV files accurately. WPS Office provides a highly compatible, free alternative to Microsoft Office that makes working with critical data files fast and error-free.
- 1. Download the software: Visit the official WPS Office website and download the free installation package.
- 2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to set up the suite on your device.
- 3. Edit your CSV: Launch WPS Spreadsheet to create or edit your Exchange Online migration list accurately.
Frequently Asked Questions
Can I use a single admin password for all users in an Exchange Online migration CSV?
No. Exchange Online generally does not support using one administrator credential (like Domain/Admin_UserName/User_UserName) in place of individual user passwords within a basic CSV migration format. You must provide specific passwords or use modern hybrid migration endpoints.
What are the exact column headers required for a basic Exchange Online CSV migration?
The documented format requires three specific column headers typed exactly as follows: EmailAddress, UserName, and Password. These must reside in the first row without trailing spaces.
Why is my CSV migration batch failing in the Exchange Admin Center?
Failures frequently occur due to improper formatting. Ensure your file is saved as a standard CSV (Comma delimited), has no hidden spaces in the headers, and strictly uses the EmailAddress, UserName, Password format instead of legacy admin formats.
Where can I request feature support for delegated administrator authentication in CSV batches?
You can submit feature requests and feedback directly to the product team via the official Microsoft Exchange Online feedback portal to advocate for enhanced migration options.
