How to export Outlook contacts to Excel 2016, 2013 or 2010

In this article I will show how you can quickly export contacts from Outlook 2016, 2013, 2010 and 2007 to an Excel spreadsheet. First I will explain how to use the build-in Outlook Import / Export function, and after that we will create a custom contacts view and copy / paste it to an Excel file.

All of us need to export contacts from the Outlook address book to Excel once in a while. There may be various reasons to do this. You may want to update all or some of your contacts, backup the contacts or make a list of your VIP clients so that your partner can take care of them during your vacation.

Today we will dive into 2 possible ways of exporting Outlook contacts to Excel and I'm going to show how you can quickly do this in different Outlook versions:

Export Outlook contacts to Excel using the Import and Export function

The Import/Export function is available in all Outlook versions. However Microsoft failed to find little room for it on the ribbon (nor on the toolbar in earlier versions) so that it would be within easy reach. Instead, they seem to have been trying to hide this function deeper and deeper with each new version of Outlook, which is funny, because it's really useful.

Read this article to learn how you can quickly export all needed details of all your Outlook contacts to an Excel worksheet at a time.

Where to find Import/Export function in different Outlook versions

Well, let's see where exactly the Import/Export wizard resides in each Outlook version and after that I will walk you step-by-step through exporting Outlook contacts into an Excel file.

Import/Export function in Outlook 2016 and 2013

On the File tab, choose Open & Export > Import/Export:
Import/Export function in Outlook 2013

Alternatively, you can open the same wizard by going to Options > Advanced > Export, like you do in Outlook 2010.

Export function in Outlook 2010

On the File tab, choose Options > Advanced > Export:
Export function in Outlook 2010

Import and Export function in Outlook 2007 and Outlook 2003

Click File on the main menu and choose Import and Export... It was pretty easy, wasn't it? ;)
Import and Export function in Outlook 2007 and Outlook 2003

How to export Outlook contacts to Excel using the Import/Export wizard

Now that you know where the Import/Export feature is located, let's have a closer look at how to export contacts from your Outlook address book to an Excel spreadsheet. We are going to do this in Outlook 2010, and lucky you are if you have this version installed :)

  1. Open your Outlook and navigate to the Import/Export function, as shown in the screenshots above. I'll remind you that in Outlook 2010 you can find it on the File tab > Options > Advanced.
  2. On the first step of the Import and Export wizard, choose "Export to a file" and then click Next.
    On the first step of the Import and Export wizard, choose 'Export to a file'.
  3. Select "Comma Separated Values (Windows)" if you want to export your Outlook contacts to Excel 2007, 2010 or 2013 and click the Next button.
    Select 'Comma Separated Values (Windows)' if you want to export your Outlook contacts to Excel 2007, 2010 or 2013.
    If you want to export the contacts to earlier Excel versions, then select "Microsoft Excel 97-2003". Note that Outlook 2010 is the last version where this choice is available, in Outlook 2013 your only option is "Comma Separated Values (Windows)".
  4. Select the folder to export from. Since we are exporting our Outlook contacts, we choose Contacts under the Outlook node, as shown in the screenshot below, and click Next to continue.
    Choose Contacts under the Outlook node.
  5. Well, you have just chosen the data to export and now you need to specify where you want to save them. Click the Browse button to select a destination folder to save the exported file to.
    Click the Browse button to select a destination folder.
  6. In the Browse dialog, type a name for the exported file in the "File name" field and click OK.
    Type a name for the exported file and click OK.
  7. Clicking the OK button will bring you back to the previous window and you click Next to continue.
    Click Next to continue.
  8. In theory, this might be your final step, i.e. if you clicked the Finish button right now. However, this would export absolutely all the fields of your Outlook contacts. Many of those fields contain inessential information like Government ID number or Car Phone, and they may only clutter your Excel file with redundant details. And even if your Outlook contacts do not contain such details, empty columns would still be created in an Excel spreadsheet (92 columns altogether!).

    Given the above, it makes sense to export only those fields that you really need. To do this, click the Map Custom Fields button.
    Click the Map Custom Fields button to choose the fields you want to export.

  9. In the "Map Custom fields" dialog window, firsts click the Clear Map button to remove the default map on the right pane and then drag the needed fields from the left pane.
    Click the Clear Map button to remove the default map and then drag the needed fields.
    You can also drag the selected fields within the right pane upwards and downwards to rearrange their order. If you have accidentally added an unwanted field, you can remove it by simply dragging it back, i.e. from the right pane to the left.

    When you are done, click the OK button. For example, if you want to export a list of your clients, your settings may resemble the screenshot below, where only the business related fields are selected.
    When you have finished mapping the fields, click the OK button.

  10. Clicking OK will bring you back to the previous window (from step 7) and you click the Finish button.

That's it! All of your Outlook contacts are exported to a .csv file and now you can open it in Excel for reviewing and editing.

How to export contacts from Outlook to Excel by copying / pasting

Someone may call "copy / paste" a newbie way, not suitable for advanced users and gurus. Of course, there is a grain of truth in it, but not in this particular case :) In fact, exporting contacts by copying / pasting has several advantages compared to the Import and Export wizard that we have just discussed.

Firstly, this is a visual way, i.e. what you see is what you get, so you wouldn't see any unexpected columns or entries in your Excel file after exporting. Secondly, the Import and Export wizard lets you export most, but not all of the fields. Thirdly, mapping the fields and re-arranging their order might also be quite burdensome especially if you are choosing many fields and they do not fit within the visible, above the scroll, area of the window. And the last but not the least, you need to recall where the Import and Export function resides in your Outlook, as you remember it has a different location in each Outlook version.

All in all, copying and pasting Outlook contacts manually might be a faster and more convenient alternative to the build-in Import/ Export function. This approach works with all Outlook versions and you can use it to export your contacts to any Office application where copy / paste works, not just Excel.

You start by creating a custom view that displays the contacts' fields you want to export.

  1. In Outlook 2013 and Outlook 2010, switch to Contacts and on the Home tab, in the Current View group, click the Phone icon to display a table view.
    In Outlook 2010, click the Phone icon to display a table view.
    In Outlook 2007, you go to View > Current View > Phone List.
    In Outlook 2003, it is almost the same: View > Arrange By > Current View > Phone List.
  2. Now we need to choose the fields we want to export. To do this, in Outlook 2010 and 2013, switch to the View tab and click the Add Columns button in the Arrangement group.
    Click the Add Columns button to add fields to your custom contacts view.
    In Outlook 2007, go to View > Current View > Customize Current View... and click the Fields button.
    In Outlook 2003, the Fields button is under View > Arrange By > Customize...
  3. In the "Show Columns"" dialog, click on the needed field in the left pane to select it and then click the Add button to add it to the right pane that contains the fields to be shown in your custom view.
    Add fields to display in the custom contacts view.

    By default, only the frequently fields are displayed, if you want more fields, open the drop-down list under "Select available columns from" and choose All Contact fields.
    Open the drop-down list and choose 'All Contact fields'.

    If you want to change the order of columns in your custom view, select the field you want to move on the right pane and click either Move Up or Move down button.
    Click either Move Up or Move down button to change the order of columns in your custom view.

    When you added all the desired fields and set the order of columns to your liking, click OK to save the changes.

    Tip: An alternative way of creating a custom contacts view is to right click anywhere on the row of field names and choose Field Chooser.
    Right click on the row of field names and choose Field Chooser.After that you simply drag the fields you need to where you want them in the row of fields' names, as shown in the screenshot.
    Drag the needed fields to the row of fields' names.

    Voila! We have created a custom contacts view, which was actually the main part of the work. What is left for you to do is press a couple of shortcuts to copy the contacts' details and paste them to an Excel document.

  4. Press CTRL+A to select all the contacts and then CTRL+C to copy them to clipboard.
  5. Open a new Excel spreadsheet and select cell A1 or any other cell that you want to be the 1st cell of your table. Right click the cell and choose Paste from the context menu, or press CTRL+V to paste the copied contacts.
  6. Save your Excel sheet and enjoy the results :)

That's how you export Outlook contacts to an Excel worksheet. Nothing difficult, is it? If you have any questions, or know a better way, don't hesitate to drop me a comment. Thanks for reading!

98 Responses to "How to export Outlook contacts to Excel 2016, 2013 or 2010"

  1. Jeff Jones says:

    question- I have my contacts in different categories such as business, personal etc. What if I want to export only business contacts to Excel?

    Thanks

    • admin says:

      Hi Jeff,

      Thank you for your question. For me to be able to give you the most accurate and correct answer, please let me know your Outlook version and how exactly you grouped the contacts by categories. Did you simply assign a category via the "Categorize" context menu, or did you create an Additional Address book for each category, or several distribution lists?

      If you used the Categorize option, then you can use the second approach described in the article - Export contacts from Outlook by copying / pasting.

      Before you perform step 4, sort your contacts list by the "Categories" column, simply by clicking it. Usually this column comes last in the list, in the right hand part of the screen. Select only contacts of the business category and then copy/paste.

      Alternatively, you can export all contacts to Excel, and then sort by the "Categories" column. This seems to be an easier way.

  2. Kari says:

    re Outlook 10 For me the File menu to options to advanced to export does not work because it does not allow me to choose the category in contacts that I want to export to excel.
    I used to do this all the time in the past but now for some reason I can not figure out how to make this happen.

    There used to be an export button on the ribbon and now it is not available.
    I have used outlook for years and years and all of a sudden it is more difficult.
    What am I doing wrong??

  3. Kayla says:

    What about the information under "All Fields",how to export that to excel?

    • Alexander says:

      Hi Kayla,
      Use the 2nd way described in the article (by copying / pasting).
      In step 3, select all the contact fields in the right pane and click Remove, to avoid duplicates. Select 'All fields' under "Select available columns from" on the left, select all fields under "Available columns", and then click the Add button.

  4. Matt says:

    Here's what happens when I try the cut and paste method with OL2013 and Excel2013, the header line is below, with line break meaning column break, and all contacts underneath are similarly scrambled across columns (should be seven columns, now five):

    First
    "Name Last"
    "Name Company Street"
    "Address City State ZIP/Postal"
    Code

  5. David says:

    Hi Alexander,
    I have the same problem as Matt. Is there an easy fix ?
    Thanks

    • Alexander says:

      Hello David,

      Sorry, I do not have a fix at the moment. I will do some research later this week and then report you the results. Please let me know what your default browser is and if you have all the latest updates installed.

  6. EricH says:

    Hey Alexander,

    I created a new Excel add-in which makes all those saving and locating the file etc. superfluous.

    Simply load your table with your existing contacts in Excel and click on "ContactXPorter" - the rest is super easy.
    More details here:
    http://www.h-d-c.de/php/services_software_contactxporter_en.php

    Would love to hear your and ll other user's comments on my add-in!
    Hope it helps a bit to make exporting contacts from Excel to Outlook much easier... ;-)

    Best,
    Eric

  7. Byron says:

    I exported the pst file. I have changed my mind and do not want do do this as a back up. Every time I open outlook (20130) I get pop up windows saying that outlook can not locate the pst file. I have to cancel the windows so outlook will go ahead and open. How can I tell outlook to stop trying to export anything?

    Thanks,

    Byron

  8. Denise says:

    Will the contacts still be available in outlook if I use the import/export method you suggest? Which method is best for copying Distribution Lists, not individual contacts?

    • Alexander says:

      Hello Denise,

      Of course, the contacts will still be available in Outlook. As for copying the distribution lists, both methods will work, so you can choose the one you like better.

  9. Bonster says:

    Hi, I have followed these direction but my fields will not paste in a single row, they insist on stacking like this.
    Full Name Mobile Phone E-mail Categories Home Address Home Address City
    Marisela and Alfred Nuno Market Clients 2 Hurles St
    Simi Valley, CA 93065 Simi Valley CA 93065
    Dawn and Derek McLaughlin 80043886 mailittodawn@ Market Clients 36 Waco Ave
    Simi Valley, CA 93063 Simi Valley CA 93063

    Suggestions?

    • Alexander says:

      Hello Bonster,

      How exactly did you copy the contacts – via a csv file or clipboard? What is your Windows version, Office version and localization?

    • Joseph Lyons says:

      It's probably old news by now, but the solution is to choose the "Home Address Street" column, not the "Home Address" column. The latter column is the standard Outlook column, and it includes that carriage return in the formatting behind the scenes.

      There is no "Mailing Address Street" column, unfortunately.

  10. Luz A. Rodriguez says:

    Best ever instruction.
    Thanks

  11. Dyan Nill says:

    I have exported my DL and am trying to reimport it. When I get to "select destination folder", there are no folders for me to pick and the "next" button is greyed out. My only option is to go back or cancel. How do I get a destination folder listed there? Thx.

  12. Dyan Nill says:

    Sorry, using a CSV file and Outlook 2010. Thx again.

  13. Simon says:

    Thanks for this article it was very useful, exporting as a CSV file has helped. However n the email extraction column it displays the email as

    abc@abcinvest.com SMTP ( abc@abcinvest.com)

    All in the one line, I don't want to have this SMTP and the email again in bracketts, any suggestions on how to extract without this showing. I just want the email abc@abcinvest.com

    Please please help !!!

  14. Max says:

    I've gone through both ways, export and copy and paste. Neither wokrs for me. When I export to the csv file all I get is a header and no contact info. When I change the view to phone and add the columns they are blank... help!

    • Hello Max,

      It is difficult to say what can cause the problem. It may happen if you have several folders with contacts. In this case, please make sure you choose the right one. If it is not the case, you can probably try to find a solution on stackoverflow.com or answers.microsoft.com.

  15. Linda says:

    I use Excel 2013 and Outlook 365. When I export, everything ends up in column A. What am I doing wrong? Also,is it possible to choose a group to export rather than searching for each group member?

  16. Kevin Moss says:

    I have used the export wizard to excel which has worked fine apart from I have % signs appeared in many fields. I am using outlook 13. Any advise.

    Thanks

  17. uday says:

    how we take backup of all suggestions mail id list.

    if we type 'a' letter in To or CC automatically visable mail id list start with letter 'a', so i need how we take backup of all address.

  18. M.Karthikeyan says:

    i want export company andress please sir

  19. Amy says:

    What are those % signs? Why do my email addresses look like this on my Excel spreadsheet: XXXXX@XXXXX.net %SMTP %XXXXX@XXXXX.net
    And when I upload this email only list to constant contact, I get an "errors" message in constant contact. What now? Thanks for your advice.

  20. Pankaj says:

    Thanks, it works..!!
    Great Job.

  21. Michael Hume says:

    Is there a way to "Export" multiple Distribution List and send them to multiple people so they can import into their Office 2007\2013 Outlook Contact List?

  22. Mike says:

    Hi Alexander,

    I have Outlook & Excel 2007. I used your 2nd method (copy and paste) and it worked fine, except for one thing.

    The NAME of my Distribution Lists transferred over (just as all the Individual Contacts did), but the MEMBERS within the Distribution Lists didn't (and I didn't really expect that they would).

    I can get around that by opening each Distribution List up and copying/pasting into Word (or wherever), but is there a way to use either your Method 1 or 2 above to accomplish that?

    Thanks for your time and help - I appreciate it,

    Mike

  23. Patty says:

    This was very helpful. Clear, easy-to-follow directions. Thanks

  24. Bob says:

    I too had an issue with extra % (percentage symbols) appearing in my CSV export. I found that, when exporting, if I went into "Map Custom Fields..." and then clicked "Clear Map" and "Default Map", the export worked again as expected. Something about the Custom export decides to add the %.

    I'm using Windows 8 with Outlook 2013.

  25. David says:

    Hi.

    I would like to export my contacts (Some thousands) from Outlook to CSV, but, the option Export is not availlable (Gray) so ... I have a .ost file of 111Mb but I cannot exctract anything. (I wanted to export it on my gmail)

    If ou can help me or explain why) on that i'll be happy. (I'm using office 365)

  26. Ann says:

    I'm using Outlook 2013 and Word 2013. If I export a contact list from Outlook or use the mail merge wizard in Word I get the same file. But it is NOT the contact list I see in Outlook. Some items that I deleted and no longer see in Outlook are in both the exported and mail merge file. I tried adding a new contact in Outlook. It does not show in Outlook but it is in the other 2 lists. I can manually edit the list but why aren't the results the same as what I see in Outlook? And why aren't new items showing up?

    • Ann says:

      Sorry I didn't also mention if I export a CSV file to Excel I see the same file as I see in Word. Neither are the file I see in Outlook.

  27. Maria says:

    Hello,
    Thanks for the exporting information. I originally imported my email contacts from Hotmail, but am now using Outlook 2013. When exported from Outlook, the names came through with "%" between all the names and email addresses.

    Here's a sample name:
    Mary, %Prendeville %

    And a sample email:
    joanjnsn@gmail.com %SMTP %Joan Johnson (joanjnsn@gmail.com)

    Any suggestions?

    • Alexander says:

      Hello Maria,

      We have never encountered this problem on our side. However you are the second person who mentions % in the separator.
      If it is not difficult for you, please contact us at support@ablebits.com and describe in detail how you exported. We will look into the issue.

  28. Vincent says:

    Hi Sir Alexander,

    My problem is the following, i want to send mail to all my contacts.But my 'contacts'
    is when i reply theme, i always use the first letter of the name of the recipient, then it shows the contact. i enter and email is there to send.

    My question is how can i import these contacts without typing all of them please.

    Thanks.
    Vincent.

  29. Sjappie says:

    Hi everyone,

    First of all, great explananation!Nevertheless I have an issue when copy/pasting mij contacts to excel. When I changed my current view by selecting all the columns I want, there is a problem with the column "adress for adress list". When I use this column and copy all contacts to Excel, this information is placed in a different row (unerneath column A), this means that I have street name in one row, postal code and city in another. I added an screenshot (see link below). This result is very inconvenient while using it for lists etc. I really want to use the column "address for adress list" because I want one column with the adresses which are mostly used for sending stuff by mail. Some people have 3 addresses, one for work, one visiting address and one private address.

    [IMG]http://i60.tinypic.com/28ivyug.png[/IMG]

    The issue is that in the contactperson itself, the address has a automatic enter, while copying it to Excel it seems that this enter is copied. See image

    How can I solve this?

    (p.s. I am Dutch, so maybe I didn't use the common words for explaining my problem).

    • YumiZ says:

      I have the same problem... Well bit different. I need to export huge amount of contact (Outlook 2013) for my boss to Excel 2013 spreadsheet...
      I went for with "Copy/Paste" method.
      I added extra columns to divide the address as "Street", "City", "Country/Region" and "Postal Code".
      As quite lots of the addresses have SECOND LINE in the address section:
      i.e. 123 E. Rose St
      Suite 456
      Phoenix, AZ 85789
      The SECOND Line and the rest of the addresses ended up in Column A, which is the next row... Also there were some with another line like the name of the building, which created another row... So, one contact info was in THREE ROWS.
      I have too many to fix each one of them!
      How can I get ALL the Street address, Suite No. Building name/No. in ONE CELL???
      Please HELP!

  30. Nancy Fay says:

    Your instruction was perfect... my problem is that the CONTACTS folder in the Outlook Data File does not contain my contacts. Through a series of computer issues, my contacts have moved to other "Contacts files in other *.PST files. Is there any way I can point the export to one of these files?

  31. AnneH says:

    I followed your great instructions using the help of the wizard. However a significant amount of contacts were not exported. Did it twice, don't understand what I am doing wrong. I have outlook 2010.

  32. Sue says:

    I would have liked to see a finished sample of your excel spreadsheet after the export.

  33. Jan Kommer says:

    I use Outlook 2013 and I agree that MS is trying to make things more difficult in every new release. They started on this unholy path with that terrible ribbon where I as a so called welltrained and heavy user after all these years regularly stumbles on functions I cannot find. It frustrates and slows down my use of Excel but I know of no alternative.
    Now this issue. Because all phone producers use different syntaxises with which they store telephone numbers I have to edit my telephone numbers before exporting them to my Siemens and to edit them another way for my Samsung. I call this consumer harassment. I used to export my Contacts to csv. Edited it in Excel and imported it again in Outlook. A fast and easy procedure.
    But why keep a winning horse if you can make life miserable. Oulook 2013 generates a csv file with of all digits a simple KOMMA!. Do these people ever think or test there makings. Everywhere in a file there are komma's which now will be seen as field seperators and when you import this file again then you would get very funny results. I say "would" because now comes the worst part: You won't get anything at all. The file contains just one column where all the contents of a row are gathered in one field seperated by this notorious komma. Good importsoftware reconizes this and that system will work also. Of course a clever software maker would let you choose your own seperator (best is a exotic digit that is not otherwise present in your file. I usely choose a #). Anyhow when importing Outlook does not knwow what to do with the file and you cannot import it.

  34. Andreea Timis says:

    Hi,

    Some of the people I e-mail with are not saved in my outlook contacts. Is there an easy way of exporting these e-mail addresses apart from going thorough each one manually and saving them as contacts?

    Thank you,
    Andreea

  35. Ron Harvey See says:

    Hi Sir/MAdam ,

    Good Day!

    I would like to request support in my ms outlook 2013 . My problem is i want to import contacts "First Name","Lastname","Email Address","Full Name","Job Title" and Department i've tried to imported the CSV but only first name , last name , and email address appearing in the contacts the others column is missing?

    regards,

  36. Josephine Deelman says:

    Question 1: I have used both methods to export contacts - the EXPORT, and copying and pasting from an open VIEW.
    However in both cases, the address field ends up crossing over more than one Excel ROW, even when I use .csv
    Is it a problem in how my address field is entered?

    Which raises Question 2: on the default OUTLOOK entry form Address is just a 'free-form' block. But in reality there are individual Address fields behind it and it seems to decide ARBITRARILY which words/numbers go into which field. Can I change the TEXT BLOCK in that default form to show indiv addr fields? Thank you

  37. Tracey says:

    Thank you for your help. Everything worked great. You saved me heaps of time :)

  38. Ned says:

    THANK YOU SO MUCH! Super helpful!

  39. Janette says:

    Dear Sir/Madam,

    Managed to export contact list to excel with your fantastic screenshots and simple explanations.

    By the way, I would like to have a "search feature" where eg. If I type "Jenny" and only her detail contact will appear, instead of having to run thru the whole list. How do I do it? Kindly advise.

    Also, I would like to share my excel contact list with another person having another computer. Is there a way to do it?

    Thank you very much!

  40. Leo says:

    Hello,

    can I use hyperlinking in 2010 excel to my 2010 outlook contacts ? I need to get, if I click the link, it needs to open the contact details in outlook.

    I tried the following but it does not working.

    example..... outlook:contacts/~John

  41. Karolina says:

    Hi.

    Great tutorial. My question would be following:

    Is it possible to export all Contact Groups at once or it needs to be done one by one.

  42. Sadi says:

    Very useful, thanks a lot. however, when I imported my contact to outlook the plus sign was removed and all he contact starts with number directly. (originally each contact was like +1 23233535 now it shows the number as 1 23233353) which make the dialing not possible. Any help .

  43. Mairi says:

    My Boss is leaving the company and holds a lot of contact information that I will need. Is there a way to export someone elses contacts from my Outlook, if we share ontacts right now?

  44. Mairi says:

    Or even transfer their contacts into mine?

  45. Amrit says:

    Hi All,

    Can you please tell me how can I export some outlook properties like- email, department, title, company etc. of all contacts in an email group at once. I have not all the group members added into my contact list.

  46. Clint Jones says:

    Hi, I am using the "Export to .pst" function on an entire .ost mailbox(incl. subfolders) in order to backup the mail.

    Question:
    Does this create a backup, or will this move all the mail from the server to the pst file?

    I am only trying to create a backup, not move the mailbox offline!

    Thanks
    :-)

  47. Max says:

    I'm with Sadi on this one, same problem as in comment 42. Any wise internet wizard got an answer for us? :)

  48. Eli says:

    Thank you so much! You saved me at work today!

  49. Lisa says:

    Thank you so much for this! I need to add all my contcats to MailChimp and didnt know how and this is just amazing! :) x

  50. Lilie says:

    I tried doing this and not only does this not save as a .xlsx or .xls file but it doesn´t even open to show a correct visual of the contats. it´s all in code! I am trying to save into an excel not the .CSV file as is the only option...Constant contact does not recognize this file type. I don´t know what to do and I really don´t want to copy and paste every contact i have. please help!!!!

  51. LaDonna Connors says:

    Hello, I am having the same problem with %smpt% being added to my exports. I am using Office 2011. did you ever get a fix for this problem?

    thanks,

    LaDonna

  52. Frank says:

    Hello:

    I am using Outlook 2013. I am changing computers. I would like to be able to be able to autofill in the people that I have previously replied in an email. How do I make that happen after moving the PST file to the new computer ?

    Is there a certain step that I need to go through using an export process on the old computer ??

    Thank you
    Frank

  53. Adithya says:

    Can we schedule the export activity , on a daily basis?

  54. Ian says:

    With all the advances that have been made in hardware and software WHY IS IT SO HARD to copy and paste the info from my Outlook address book to Excell? Why can't we just highlight, copy and paste? Is there no one out there in cyber space who is smart enough to write such a simple programme? Just look at all the previous comments, someone has got to come up with a simpler and/or better way of doing this.

  55. Andrew says:

    Nice one. Solved a big problem. Thankyou

  56. Piyush says:

    Thanks for this tutorial

  57. Tina says:

    Your "tutorial" was useless. I don't have the same tabs in my Outlook 2013. Thanks for nothing.

  58. Tammy says:

    Tutorial was simple and easy to follow. I have Outlook 2010 and used Export Wizard instructions. My map is simple. Just name, email, work phone, and mobile. Many contacts didn't come over at all with only one element.
    Many were missing email even though that info is in my Outlook contact in proper position/field. I've tried process twice now with same result. What do I need to do differently?
    At bare minimum, I need name and email.
    Thanks!

  59. Paul says:

    I am in Ireland. All national area codes begin with zero [0],and all international are entered with either OR zero zero [00]. When the exported CSV file is opened in Excel all these numbers get corrupted. Can this be prevented, I have over 1,500 contacts and need to export. In other words how do I preserve the leading zeros AND +'s

  60. James says:

    I have several folders to separate all of my outlook contacts. How can I export all of them into a csv? As is currently stands right now, it will only export the column titles of the mapped fields.

  61. sheley fields says:

    Savvy article . Speaking of which , if your company is searching for a NJ DoT MFA-1 , my company used a template form here https://goo.gl/EvXKwW.

  62. Megan says:

    Hello,

    I follow the instructions to export email addresses from Outlook 2013 contact group. However, the CVS file is empty.

    Thank you.

  63. OneWithWood says:

    Why does microsoft have to make each new version of it's s/w & OS harder to find things in?

  64. Piper210 says:

    When I export my contacts to a csv file I cannot export all the information in the NOTE column due to the limitations on the amount of characters allowed in a cell in excel

  65. Louise says:

    Hi and thank you for this tutorial.

    I exported the whole of my COntacts into Excel and it worked perfectly. I then repeated the process but this time, I specified which fields I wanted to export using the Field Chooser. Again, it did work, however, in the Excel file, it shows "&" signs everywhere, where I have used spaces but in the first one I created, it didn't. What's happened?

    Thank you.
    Louise

  66. Pam Duncan says:

    Hi there. I;m using Windows 2007 and have followed your instructions for exporting Outlook contacts to Excel. However, when I get to the screen where I'm supposed to be able to choose the folder to export from, there is no folder list. How do I get the folder list to show up there?

  67. TanyaRenee Usher says:

    This information has been EXTREMELY helpful!! Thank you!

  68. Kamil says:

    Hi,

    What if i have already contact list in excel, but i need job positions for these contacts and other info from global contact book..? is there a way (vba incl.) to do that..?

    Cheers!
    kamil

  69. Sadiq says:

    Hi There,

    When exporting data, will the data then be deleted form the outlook?

    Cheers
    Sadiq

  70. Sadiq says:

    Hi There,

    When exporting data, will the data then be deleted from outlook?

    Cheers
    Sadiq

  71. Jodie says:

    Hi Sadiq

    When exporting data, the data WILL NOT then be deleted from Outlook. It is merely copying it over.

    Hope this helps.

  72. David says:

    Outlook 2013 & Windows 10 - After cleaning up and deleting some of my Address Book entries I have repeatedly exported to a .csv file however all the deleted address book entries come as well. Is there a step I am missing where I need to delete the deleted items from a cash somewhere.

  73. Srinivas B says:

    is it possible to contacts saved automatically in outlook
    Pls me on this and i am using window 8

  74. Srinivas B says:

    is it possible to contacts saved automatically in outlook??
    Pls help me on this and i am using window 8

  75. Shanna White-Warren says:

    Thanks for the help

  76. emmelie says:

    Dear

    Trying to export the contacts from Outlook to Excel (via file, import/export and I've followed all steps for 2013. However the results is I get everything in cell/line (even it was indicated "comma separated values" and the file looks completely messed up. Any help for this?

    Thanks!

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard