How to Import contacts from Excel into Outlook?

February 6, 2020

Step 1: Save your Excel workbook as a .csv file

You must save your worksheet as a CSV file to import your contacts. The steps below work on all versions of Outlook / Excel.

  1. In your workbook, click the worksheet with the contact information you want to import.

  2. Click File > Save As.

  3. Choose where to save your file.

  4. In the Save as type box, choose CSV (Comma delimited) (*.csv), and click Save.

  5. Click OK.

  6. Click Yes to have Excel save the current worksheet as a CSV file. The original workbook (the .xlsx file) closes.

  7. Close the CSV file.

 

Step 2: Import Your Contacts Into Outlook

  1. Start Outlook.

  2. Click File in the top left.

  3. Click Open & Export > Import/Export.

  4. Choose Import from another program or file and then click Next.

  5. Choose Comma Separated Values and click Next.

  6. Browse and find the file you saved in Step 1.

  7. Under Options, choose whether to replace duplicates (existing contacts), create duplicate contacts, or not import duplicates.

  8. Click Next and choose the destination folder for your contacts. Contacts should be selected by default, but if it’s not, scroll up or down until you find it. You can also choose a different folder, or create a new one.

  9. Click Next.

  10. Make sure the checkbox next to Import “MyContacts.csv” (assuming that’s your file name) is selected.

  11. Don’t click Finish yet, because you’ll need to “map” some of the columns in your CSV file to the contact fields in Outlook. Mapping can help the imported contacts turn out just the way you want.

 

Steps 3: Map fields from your CSV file to Outlook fields

If your field in Excel was called First, and it is the First Name, you need to map it to the Outlook field called First Name. You map by dragging files from the left to the right. This is shown at the 1:35 mark in the video above.

 

 

 

 

Share on Facebook
Share on Twitter
Please reload

Recent Posts
Please reload

Archive
Please reload

Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square
ABOUT US

PURE IT ACADEMY, your destination for IT Courses and everything related to career development for IT professionals. PURE IT academy is committed to elevate Caribbean's IT professionals by providing in-depth knowledge and understanding of technology, relevant experience and flexibility to stay ahead of the ever evolving technologies in the IT landscape.

SUBSCRIBE FOR EMAILS
ADDRESS

+5999 841-7873

 

Penstraat 23
Willemstad, Curaçao

info@pure-it-academy.com

www.pure-it-academy.com

  • Grey LinkedIn Icon
  • Grey Facebook Icon
  • Instagram
  • Grey YouTube Icon

Stay connected