Comments on: How to import contacts to Outlook from Excel in 3 steps

In this article, I’ll show you how to import contacts from Excel to Outlook 2010-2013. You’ll find three easy steps for getting your contacts exported. Convert your data to .csv format, import them to Outlook with a special wizard and match Excel headers to the corresponding fields. Continue reading →

Table of contents

Comments page 2. Total comments: 54

  1. Very clear instructions, thanks. How can I create a separate sub-folder in the "contacts" folder to accommodate the newly imported data?

  2. Very useful info, thanks

  3. I followed the instructions and everything came out ok. Only when I open a contact I see the zip code is before the city and state in the card. How can I change that?

  4. My question was how to import from Excel
    This post is showing how to import from CSV.
    It is not the same thing.
    When saving an Excel file into CSV format, there is a big warning box advising that some features will be lost.
    I do not want to lose those features so that I will not end up with names such as Lud?k Jurkech instead of Luděk Jurkech.
    an alternative answer to my question would be how to control the code-page used by CSV files

    1. Zork that doesn't matter you just say okay but I get stuck at the last step in Outlook.

  5. Works in Outlook 2010..Thanks for sharing

  6. When I import from excel I not only get the contacts but also a ton of blank contacts. Is there a way of having the import only grab the cells that have names and not blank cells? Thanks

  7. Thank you very much. Nicely detailed

  8. I have 21 contacts and only 5 of them will import. Is there a limit of 5? How do I get all 21 in the same group?

  9. Hello I do get the same error as Steve and Hany; "Each time I get the message at the end saying, [Outlook could not complete the operation because the service provider does not support it]" Is there another way around it?

  10. given error message

    could not complete the operation because the service provider dose not support it

    any help?

  11. I have tried this many times. Even set up a dummy spreadsheet.

    Each time I get the message at the end saying, [Outlook could not complete the operation because the service provider does not support it]

    I use Office365 and constantly have the most up-to-date versions.

    This always worked fine in office 2010.

    Any ideas? Thanks :)

    1. Following. I've wasted 2 days trying to figure this out and I get the same error message. If you have the solution please let me know!

      1. Try saving the outlook document and closing the file. It worked for me. Also, I think data needs to be formatted as a table in outlook.

  12. Thanks for making this so easy. I spent at least 30 min trying to do it through Microsoft and was unsuccessful. This instruction was easy to follow and worked perfectly!

  13. Is there any way to save the mapping so I don't need to repeat the field mapping process? What is the purpose of the Default Map button? Can I create a custom default map?

  14. This was very helpful thank you very much

  15. Hello, thanks for this clear instruction. Unfortunately I have tried everything, but all values on the left hand side are aligned into one line/field. I have tried several times by changing the regional settings/list seperator but nothing works (I followed all steps mentioned here: https://answers.microsoft.com/en-us/office/forum/office_2010-outlook/csv-to-ms-outlook-2010-all-info-in-the-same-field/fb4a03b7-5311-44b1-bec4-bf05ec0b0187. But nothing seems to work.) Any idea what it could be?

    1. I have the same problem too

        1. This is not the answer to the question.
          I get one line With all the Fields from EXCEL. Not the own shown above With one Field per line.
          How to get MY Fields on separate lines? Otherwise, it will not work.

          1. I found out. Just use Notpad en replace all ; (semicolons) With , (comma) and it worked :-)

            1. Hi Martin,
              I have the same problem that you had. How did you manage to fix this?

            2. Hi Martin
              I've run into the same problem. I too get one line with all the fields from EXCEL. Not one Field per line. Can I ask how you used txt to solve this please?

            3. So then I ran into anothe problem. Which many has With Outlook. The contacts file disappeared. It is nowhere to be found. I can see it when copy TO:, but i cannot see it in the address list.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)