1. Home
  2. MS Office
  3. How to import contacts from excel file to outlook 2010

How To Import Contacts From Excel File To Outlook 2010

In so many situations, one needs to import contacts to Outlook from an Excel spreadsheet. Follow these simple steps to import contacts from an Excel Sheet in to Outlook 2010, the only pre-requisite is that your Excel sheet should be in the Comma Separated format.

Convert an Excel Sheet in to the CSV (Comma Separated Values) Format

Click the File Menu and choose the Save As option, browse and select the location to save the file, specify the name of the file and choose CSV from the Save as Type drop down box.

CSV Format

Importing a CSV File in to Outlook

Lets assume that we have converted the Excel sheet to the CSV format as mentioned above, now launch Outlook 2010, and click the Office button(File menu). Then click the Open option and choose Import.

Imprt Outlook 2010

Now in the Import and Export Wizard, choose the Import from another program or file option.

Imnport and Export

Click the Next button and choose the file type Comma Separated Values (Windows) and then click Next.

CSV Format Outlook 2010

Now browse and select the CSV file.

Import Excel 2010

Hit Next and select and choose the Destination Folder.

Destination Folder Outlook 2010

Finally confirm the action and hit the Finish button. Here you can change the destination as well.

Import Outlook 2010 Final Step

Your Excel sheet contacts will be imported to your destination folder. Enjoy!

62 Comments

  1. You don’t discuss the issue of regional settings as I have hit a brick wall in South Africa its ; in most tutorials it doesn’t tell you that you have to change your regional settings before replacing your ; to ,

  2. hi, import/export complete but the names that are in Arabic language are shown as garbage in outlook now. Any advise?

  3. I have exported a list of contacts in Outlook 2010 to a CSV file. I want to instruct a group of people how to import it onto their PC, which is all straightforward. This will update the previous copy of the CSV which they all imported a few months back. If I have deleted some of the older unwanted contacts in my new CSV export, how can I get these deletions to take effect for everyone else when they import it? There are only options for what to do with duplicates, and nothing regarding contacts that have been removed from the list. Thanks!

  4. I just tried to convert my 190 entries from Excel into Outlook, using all the instructions (converting them to CSV format, etc.), but only about half of them show up in my Outlook contacts. Any advice? The ones that were imported are all mapped correctly.

  5. Excellent instructions although some of the folders highlighted could imply (wrongly) that you should select them.

  6. How to get “file as” field in outlook? it is not showing anywhere in import or export of outlook data file .csv
    It changes to “first & Last name” while import back same data we exported to CSV file
    Any one can help on this?

  7. Hi

    Can any one help. I have followed all above but when I go to my file in outlook it just says NONE. I’m guessing I havent copied over correctly can any suggest where i am going wrong. In my excel spread sheet I have all my email addresses in column A and in box one I have the word email saved as a CVS. Please help

  8. I opened the file in Notebook as suggested below but I couldn’t figure out how to change the “.” to whatever it was supposed to be. Notebook doesn’t have many dropdown menus.

  9. I have complete every step, doubled checked and have the excel file as a CSV, get to the last step and the finish button is greyed out!! I have tried everything. HELP!!!! I dont feel like adding 30 individual email addresses. What to do??????

  10. Importing into “suggested contacts” gave better mapping and then could be added to a contact group. Thanks for the help above (was going crazy b4!) xxx

  11. I fail to understand the logic behind importing contacts into Sent Items folder. I use Outlook 2010 and looking for tip on importing them DIRECTLY into New Contact Group/Custom Distribution List within Contacts folder.

    It appears that Microsoft has left that end loose. Would love to hear from someone who knows how to accomplish that.

    • I did it by importing into “suggested contacts” first and then joining new members into a contact group from there. 🙂

  12. After a great research was helpless in getting contacts into 2010 outlook, finally now got my contacts imported successfully thanks dude,

  13. Thank you – I’m addicted to importing contacts through my sent items folder! Much Appreciated!!!

  14. Hi

    I followed your steps exactly. I get to the step of importing the CSV data but the next step; is gvreyed out. Can you help?

    Thanks

    Bob Dreyer

  15. I was able to do this in Outlook 2010, importing .CSV addresses into Contacts, but formatting Contacts needs work!  BTW, I got a free utility, Outlook Export from CodeTwo that enabled me to export Addresses from my Outlook 2002.  It worked great!  Too bad Microsoft doesn’t feel obligated to support their “legacy” S/W!

  16. Apparently regional settings play some role here. When converting to csv, you might thik it is a universal format but… In some reagions the “;” is used instead of “,”. So if you open the csv in notepad and change “;” with “,” then it works as a charm…

  17. Thanks!!! Really helped me out, and quickly! And a good tip before importing is to create a folder under your main contacts folder, so you can input the group directly in to a unique folder.

    Two thumbs up, very simply explained.

  18. Thanks!!! Really helped me out, and quickly! And a good tip before importing is to create a folder under your main contacts folder, so you can input the group directly in to a unique folder.

    Two thumbs up, very simply explained.

  19. To Fisherman …

    thanks soooo much, this was just the right solution. It is so stupid that this mistake is in the new programs … with your solution it is the perfect workaround …

    • Hi, I have mapped my emails to allow the csv to import correctly into Outlook. The contacts are now showing in my contacts folder. Unfortunately now, when I go to mail to send an email, the contacts are not in the address book which I have saved them in. Does anyone know how to resolve this?

  20. At last… It took me more than a day.

    – Open the csv-file which you exported form another mailprofram in Notepad++ (free download).
    – Change the ‘;’ in ‘,’ (comma’s)
    – Save thefile as ‘[your preffered name].csv’ and choose the first option (save as:) *.*
    – Than it’s an Excel-file with the correct comma’s in stead of ‘;’
    – Than import that file in Outlook 2010 as above (of course in the contacts folder).

  21. I didn’t have a problem with the email, but none of the phone #s, addresses or other fields came over. If the email is missing, did you get the columns in the right order? Supposedly it’s:

    First Name, Last Name, Title, Company, Cell, Home, Work, Email, Addr, City, State, Zip, Country

    My first, last, title, company, and email came over correctly, but none of the phone #s or address pieces came over.

  22. I also have problems with the email. I can get email addresses to import as long as the excel column is mapped to the email field, but when I have the contacts sorted by location I cannot select a group (or even one) and simply send an email. It sends me an error message telling me that I have to enter a valid email address. BUT, if I double-click and open an individual contact and click the icon to send a message, it works – so obviously I have a valid e-mail address. And the problem only happens with those contacts that were imported from excel. Very frustrating!

  23. Hi …Can somebody help me .. I have Office 2010 and when I import from *.csv to my contact list I am not able to import the “+” symbol in my Phone numbers (contacts list)… thanks

  24. Unfortunately, this tutorial leaves off after the easy part is done.

    What do I do when the import dialog with mapped an unmapped fields pops up?

    Sorry, not useful enough for what I’m running into. Thanks for your effort though.

    • I couldn’t agree more Andrew. The last step is the mapping and it’s more than a little confusing. All the other info was great, but the final step is simply absent. 

  25. so easy to understand and follow i had looked at a few examples but this was by far the best!!!

  26. I tried all the above steps for importing a CSV File in to Outlook. When I get to ‘Now browse and select the CSV file”, select the file, the “Next” button is greyed out and I could not proceed. I tried many times, made sure I had a CSV file, checked properties, tried all of the duplicate options, created a new profile and nothing worked. I’ve been struggling with this for months, doing research, trying different options. Please help!! I have Outlook 2010, been using Outlook in different versions for years on my PC’s.

  27. I have managed to import the contacts only they are all missing email addresses…can anyone send me some advise..please

    • I have the same problem – I am with a new company and I went from Outlook on Windows 7/Vista contacts to Outlook 2003 – no emails – I have tried all kinds of work arounds including creating a export of the file from 2003 and then pasting the email addresses in and trying to import – so far no luck – anyone have a smart idea here?

  28. Hi,

    Can someone tell me if it is possible to import email addresses from excel to outlook 2010? I really need help with this PLEASE!!!

  29. Other Thank,set judge fight driver paint yeah slip operate due hear writing attempt cup campaign satisfy skill rise even prefer concerned good finance last can drink discuss vote capacity leader class at origin deep tomorrow kind community division along investment justice proportion when aim sign flight rock touch design during advise danger northern rather control selection tea future beautiful upper touch start rare address telephone atmosphere act bank round court vary operation in point gain his talk upper within little demand royal suffer sport particular

  30. Hi,

    I’m trying to import a list of events into Outlook, and include a friendly link in the description field. I.e. Click here to book tickets for the event.

    However, I can only seem to insert the full URL, and not add a friendly link.

    Any ideas?

    Cheers

  31. Hi!
    I’ve tried to import Contacts the way you’ve showed but it just didn’t work: the information (full name, company, address, phones etc.) places all in just one field (the “FULL NAME” field in Outlook 2010) or separates in weird way and I cannot fix it with “Mapping” – can you please explain why is that?

  32. I have done this seamlessly in Outlook 2003. However, in Outlook 2010, when I click on the properties of the Contacts to add them to the address book, even with a brand new profile, the option is still greyed out. They can be seen, but not used. How do you make the address book link to them? Thanks

  33. I have Outlook 2003 and found, to reflect on the first comment, that it works by importing into the Contacts folder, not Sent mail. It worked immediately with the contacts folder; sending to Sent mail gave me a message it was importing but to be patient. I left it alone for forty-five minutes and the message didn’t change and it was at that point I tried the Contacts Folder and it worked. Yay.

  34. Is it possible to use a similar method to import email addresses to a contacts list in the address book?

  35. Thanks for help. Actually i have done the same process in outlook 2007, but i was unable to find import/export option in outlook 2010. Anyhow it was great to me.

    Thanks & Regards
    Muhammad Uzair Saqib
    Pakistan

  36. Why would anyone copy “Contacts” to the “Sent Items” folder?

    • This is just a simple demonstration of importing, showing the steps it takes to make it possible. You will obviously import it in some other folder.

    • Since this is a demo to import CSV into to contacts, why use another file to import too. Not a lick of sense.