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!

Advertisement
  • Pingback: Migrate Excel Phone Lists To Outlook 2010 Address Book

  • Jan Anderrsson

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

    • http://www.addicitivetips.com Nakodari

      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.

      • Buck

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

  • anil

    Tahnks a lot…………………….:-)

  • http://www.fatima-group.com Muhammad Uzair Saqib

    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

  • Sarah

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

  • Paul Mercer

    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.

  • Suzi

    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

  • Radost

    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?

  • Mark

    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

  • reisen mittelmeer

    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

  • Krista

    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!!!

    • Grumbler

      Did you read the article?

  • Herb

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

    • Michael

      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?

  • MAK

    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.

    • Vic

      I am having the same problem Mak. Have you resolved it yet?

      • Tara

        Did you close the .csv file before trying to import?

  • Gary Hilton

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

  • Rosie Mendez

    blah blah blah…it doesn’t work at all…

  • Andrew

    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.

    • Ron

      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. 

  • zhe

    why all the info in excell is imported except the email?

  • Riks

    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

  • Marie

    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!

    • becca

      Marie,

      I have the exact same problem…

  • Tara

    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.

  • Fisherman

    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).

  • ZAIN

    I want import contacts in facebook from computer xls file

  • The New $hit

    You have to map the file by hand. This is the crucial step and you must do it.

    • Vicky

      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?

  • Salma Noreen

    It become lifesaver for me. thanks for sharing this useful tutorial :)

  • Alex

    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 …

  • Test

    Thank you so much

  • Info Stmltd

    cool, thanks!

  • Bonds

    thank u so much

  • Mrs_julia_gulia

    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.

  • Mrs_julia_gulia

    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.

  • Littlewendyfairy

    Thanks for this, it helped alot.

  • Hans

    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…

  • Mike White

    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!

  • Bob Dreyer

    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

  • bpara

    i tried and when sending mail i am getting error as “invalid recipient”.

  • Kim Dickens

    How do I merge and excel file into outlook contacts

  • Gratefully Sent

    I can finally import contacts into my sent items! Thank you :-D

  • Jo

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

  • sudharshan

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

  • Mehna

    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.

    • Catherine Grace

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

  • Catherine Grace

    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

  • Deb

    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??????

  • cjfb

    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.

  • Jadon

    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

  • Yatin

    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?

  • ronnie

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