CSV Upload

Upload CSV

If Autodiscovery is unavailable, list of mailboxes which need to be migrated needs to be supplied via CSV file.

For CSV Upload method to work, CSV needs to contain the proper data. Example of usable CSV is:

username
Lorna.Tassin@yourdomain.com
Felipe.Duwe@yourdomain.com
Marilyn.Devonshire@yourdomain.com
Jenna.Yoquelet@yourdomain.com
Rolf.Lawin@yourdomain.com
Ellis.Valdo@yourdomain.com
Tillie.Astle@yourdomain.com
Alva.Gosling@yourdomain.com
Alfonso.Searight@yourdomain.com
Katelynn.Popoca@yourdomain.com

The easiest way to obtain such a CSV file is to run a query from Exchange management shell on your Exchange server or from regular PowerShell if you are connected remotely.

Simple example which would return a list of all mailboxes (user/resources/shared including) is:

Get-Mailbox | select PrimarySmtpAddress | Out-File C:\Temp\AllUsersCsvList.csv

This query would save a file called AllUsersCsvList.csv in C:\Temp folder of the computer on which it was triggered

Output will look like this:

PrimarySmtpAddress
------------------
Hellen.Muse@yourdomain.com
Darby.Arrezola@yourdomain.com
Angella.Phetteplace@yourdomain.com
Agustina.Gilmer@yourdomain.com
Cordell.Patzer@yourdomain.com
Karyl.Rifenburg@yourdomain.com
Charise.Parkhouse@yourdomain.com
Jeannie.Devier@yourdomain.com
Louella.Mucerino@yourdomain.com
Tracey.Yopp@yourdomain.com

This file needs to be edited with a text editor (e.g. Notepad). First two lines need to be replaced with a single line “username”

username
Hellen.Muse@yourdomain.com
Darby.Arrezola@yourdomain.com
Angella.Phetteplace@yourdomain.com
Agustina.Gilmer@yourdomain.com
Cordell.Patzer@yourdomain.com
Karyl.Rifenburg@yourdomain.com
Charise.Parkhouse@yourdomain.com
Jeannie.Devier@yourdomain.com
Louella.Mucerino@yourdomain.com
Tracey.Yopp@yourdomain.com

If only User mailboxes are needed, query is similar:

Get-Mailbox |
where {$_.RecipientTypeDetails -like "UserMailbox"} |
select PrimarySmtpAddress |
Out-File C:\Temp\AllUsersCsvList.csv

If only mailboxes from a specific Organizational Unit need to be selected (replace “domain.local/company/users” with the path to your desired OU):

Get-Mailbox |
where {$_.OrganizationalUnit -like "domain.local/company/users"} |
select PrimarySmtpAddress |
Out-File C:\Temp\AllUsersCsvList.csv

Or combination of these two queries can be used

Get-Mailbox |
where {($_.OrganizationalUnit -like "domain.local/company/users") -and ({$_.RecipientTypeDetails -like "UserMailbox"})} |
select PrimarySmtpAddress |
Out-File C:\Temp\AllUsersCsvList.csv