Ever wondered how to import the contacts from Outlook or Probably already available  in CSV format into Exchange 2010 GAL or Global address list. Well the procedure is quite simple, Please note the following procedure.

Steps to Import CSV into Global Address List

A) Export all the contacts from Outlook to CSV sheet

Go to File tab.–> Options –> Advanced –> Export, click Export –>  Export to a file, select format CSV.

B)   Import the Exported contacts to Global Address List

  • Save Exported file in location “C:\Contacts.csv”
  • Run this command from EMS:

Import-csv C:\Contacts.csv | foreach {new-mailcontact -name $_.”First Name” -externalemailaddress $_.”E-mail Address”;set-contact -identity $_.”First Name” -office $_.office -department $_.department -company $_.company -FirstName $_.”First Name” -LastName $_.”Last Name” -City $_.”Business City” -State $_.”Business State” -PostalCode $_.”Business Postal Code” -Phone $_.”Business Phone” -Mobile $_.”Mobile Phone”}

PS: Some of the values like Mobile Phone and Country Name cannot be imported with this command

Feel free to reach out to us for more support options here

The following two tabs change content below.
An automobile enthusiast at heart and computer geek by profession, started my Career with MS in 2005.Left Jobs and started Pledge Technologies (the parent company to Grishbi) back in 2009.We have been providing IT consulting to various Small and Medium businesses across US and UK since then.Our company specialises in Microsoft Server technologies like AD, Exchange, the rest and with numerous Office 365 migrations under our belt, we quite an expert with that too. Whatever we learn in our day to day life, we share it back on Grishbi as a Thank for all the love and support our customers have given us.
%d bloggers like this: