Others

Fix Invalid Characters Error When Adding Microsoft 365 Users in Bulk

Steve KSteve K Nov 4, 2026 870 views

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.

How to Fix Invalid Characters Error When Adding Microsoft 365 Users in Bulk
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.
Before you start

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.

Solution 1Recommended

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.

1
Access the Admin Center

Log in to the Microsoft 365 Admin Center, navigate to 'Users', and then click on 'Active users'.

2
Download Template

Click on 'Add multiple users' and select the option to 'Download a CSV file with headers and sample user information'.

3
Input Your Data

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.

4
Save and Retry

Save the document strictly in the standard CSV (Comma delimited) format, return to the Microsoft 365 Admin Center, and retry the bulk upload.

Download and Use the Official Sample CSV Template
Avoid Header Modifications: Even a minor typo, an extra space, or a missing column in the header row will cause the entire CSV file to fail Microsoft's validation process.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Safely edit and save bulk upload CSV templates without hidden delimiter issues or data corruption.Lightweight design ensures quick loading even when handling large datasets.Familiar user interface requires no learning curve to master.
microsoft office alternative - wps office

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.