Fix Invalid Characters Error When Adding Microsoft 365 Users in Bulk
Question details
The user is encountering an error stating 'Email address incomplete or has invalid characters' when attempting to import multiple users via a CSV file, although the addresses work when added individually.

- Product
- Microsoft 365
- Device & OS
- not provided
- Scenario
- Adding multiple user accounts simultaneously in the Microsoft 365 admin center using a bulk-user CSV upload.
- Observed behavior
- The system rejects the CSV import, throwing an invalid characters error and failing to create the new user accounts.
Ensure you have administrator privileges in the Microsoft 365 admin center and have access to a reliable spreadsheet program capable of opening and cleanly saving CSV files without altering delimiters.
Download and Use the Official Sample CSV Template
Using the standard template ensures your column headers perfectly match what the Microsoft 365 system expects, avoiding structural errors.
Microsoft 365 requires a very specific CSV format to successfully import bulk users. Modifying the header row or using an outdated template often triggers the invalid characters error.
Log in to the Microsoft 365 Admin Center, navigate to 'Users', and then click on 'Active users'.
Click on 'Add multiple users' and select the option to 'Download a CSV file with headers and sample user information'.
Open the downloaded file in your spreadsheet editor. Paste your user data directly under the exact headers provided, ensuring you do not modify, rename, or delete the top header row.
Save the document strictly in the standard CSV (Comma delimited) format, return to the Microsoft 365 Admin Center, and retry the bulk upload.

Clean Up Hidden Spaces and Unsupported Characters
Invisible formatting, trailing spaces, or illegal characters in the email fields often trigger invalid character errors during bulk imports.
Compare Failing Row with Exported Data
Exporting an existing, functioning user helps you spot subtle formatting discrepancies in the rows that are failing.
Edit CSV Files Safely with WPS Office
While Microsoft 365 handles your user management, a reliable spreadsheet editor is crucial for formatting bulk upload files correctly. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, ensuring your CSV files are saved with precise delimiters and zero formatting corruption.

Frequently Asked Questions
Why does an email address work individually but fail in a bulk upload?
When added individually, the admin center interface automatically handles formatting and strips out accidental spaces. In a bulk CSV upload, the system reads the raw data exactly as written; any hidden spaces, missing required fields, or unsupported characters in the file will instantly trigger a validation error.
What is the correct format to save the bulk user file?
The file must be saved in a standard Comma Separated Values (CSV) format. Saving it as a standard Excel Workbook (.xlsx) or a text file (.txt) without standard comma delimiters will prevent Microsoft 365 from parsing the user data.
Are there mandatory fields in the Microsoft 365 bulk add template?
Yes, specific columns such as 'User Name' (which acts as the email address) and 'Display Name' are strictly required. Leaving these cells blank in any row will result in an 'incomplete or invalid characters' error.




