Beware that this does also make fields that contain Office 365 specific data so you can’t use all of those fields so you’ll have to find out which ones you can’t use. csv file which you can use as a template.

Now you can even go further and type in “Get-Contact | Export-CSV c:filename.csv” and it will spit it all out for to a. In the pop-up Enter Credentials dialog, enter your Office 365 administrative username and password, and click OK.So first I had to get what fields I could import from Exchange and you can do that by logging into your Exchange Organization via PowerShell and then typing in the cmdlet “Get-Contact | FL” this will give you a list out of all the available fields that go with a contact.In the PowerShell console, type connect-msolservice and press Enter.Give consent or enter administrative privileges if prompted. Type powershell, make sure that Windows Azure Active Directory module for PowerShell is selected in the search results and press CTRL+SHIFT+ENTER to launch the console with administrative privileges.Log in to Windows 8 and switch to the Start screen.Export Office 365 User Informationįirst you need to authorize to Office 365 using an administrator account. For more information on installing these components, see “ How to Install the Windows PowerShell Cmdlets for Windows Azure AD and Office 365” on Petri IT Knowledgebase. Setup PowerShell Management for Office 365īefore you can run PowerShell commands to manage or export information from Office 365, you need to make sure that you have the PowerShell cmdlets for Windows Azure Active Directory installed locally, along with the latest version of the Microsoft Online Services Sign-In Assistant. In this Ask the Admin, I’ll show you how to connect to Office 365 and export user information using PowerShell.

Organizations with large Office 365 deployments may need to export user information to a comma delimited file (CSV), which can then be used as the basis for creating reports.

Export office 365 contacts powershell