Import and Export CSV
Use CSV files to perform bulk operations on users, licenses, and configurations. CSV import/export enables large-scale data exchange between MedhaOps 365 and external systems.
CSV Import for User Creation
Upload a CSV file to create multiple users at once. The system validates all data before processing.
Required Columns
| Column | Example | Description |
|---|---|---|
| UserPrincipalName | john.doe@company.com | Login email (required) |
| DisplayName | John Doe | Full name (required) |
| Password | TempPass123! | Initial password (optional) |
| FirstName | John | Given name |
| LastName | Doe | Surname |
| Department | Sales | Department name |
| JobTitle | Account Executive | Job title |
| Manager | jane.smith@company.com | Manager’s UPN |
| License | M365_BUSINESS_PREMIUM | License SKU to assign |
Note: Download the CSV template to ensure correct column headers and formatting.
CSV Import for License Operations
| UserPrincipalName | LicenseSKU | DisabledPlans |
|---|---|---|
| john@contoso.com | ENTERPRISEPREMIUM | YAMMER_ENTERPRISE |
| jane@contoso.com | ENTERPRISEPREMIUM |
CSV Import for Bulk User Import with Templates
| FirstName | LastName | UserPrincipalName | Template | Manager |
|---|---|---|---|---|
| John | Smith | john.smith@contoso.com | Sales Representative | jane.doe@contoso.com |
| Emily | Jones | emily.jones@contoso.com | Standard Employee | bob.wilson@contoso.com |
| Mike | Chen | mike.chen@contoso.com | Frontline Worker |
Import Process
- Upload CSV — Select file or drag and drop. Max 5,000 rows per import
- Validate Data — System checks for errors: duplicate UPNs, invalid data, missing fields
- Review Preview — Review parsed data and fix any validation errors before proceeding
- Execute Import — Create users and assign licenses. Progress shown in real-time
- Download Results — Get report with success/failure status and temporary passwords
Export Options
- Full Report — All users with status and details
- Failures Only — Users that failed with error messages
- Audit Log — Operation timeline with timestamps
Last updated on