Why Are My Outlook Contacts Read Only

98 comments to "How to export Outlook contacts to Excel"

emmelie says:

Dear

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

Thanks!
Shanna White-Warren says:

Thanks for the aid
Srinivas B says:

is information technology possible to contacts saved automatically in outlook??
Pls help me on this and i am using window viii
Srinivas B says:

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

Outlook 2013 & Windows ten - After cleaning upward and deleting some of my Address Volume entries I have repeatedly exported to a .csv file still 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.
Jodie says:

Hi Sadiq

When exporting data, the data WILL Non so be deleted from Outlook. It is only copying it over.

Hope this helps.
Sadiq says:

Hi There,

When exporting data, volition the data and then be deleted from outlook?

Cheers
Sadiq
Sadiq says:

Hi At that place,

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

Cheers
Sadiq
Kamil says:

Hi,

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

Cheers!
kamil
TanyaRenee Usher says:

This data has been EXTREMELY helpful!! Thanks!
Pam Duncan says:

How-do-you-do at that place. I;grand using Windows 2007 and accept followed your instructions for exporting Outlook contacts to Excel. However, when I get to the screen where I'chiliad supposed to exist able to cull the folder to export from, there is no folder list. How do I become the folder list to show upwards there?
Louise says:

Hullo and give thanks you for this tutorial.

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

Thank yous.
Louise
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 immune in a cell in excel
- Sadiq says:
  
  Hi There,
  
  Did you get an answer to your question above?
  
  Cheers
  Sadiq
OneWithWood says:

Why does microsoft accept to brand each new version of it's s/due west & OS harder to find things in?
Megan says:

Hello,

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

Cheers.
sheley fields says:

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

I accept several folders to separate all of my outlook contacts. How tin I consign all of them into a csv? As is currently stands correct now, it will but export the column titles of the mapped fields.
Paul says:

I am in Ireland. All national area codes begin with zero [0],and all international are entered with either OR null zero [00]. When the exported CSV file is opened in Excel all these numbers become corrupted. Can this exist prevented, I take over 1,500 contacts and demand to consign. In other words how practise I preserve the leading zeros AND +'s
Tammy says:

Tutorial was simple and easy to follow. I have Outlook 2010 and used Export Wizard instructions. My map is simple. Just proper noun, email, work phone, and mobile. Many contacts didn't come up over at all with only ane element.
Many were missing electronic mail fifty-fifty though that info is in my Outlook contact in proper position/field. I've tried process twice at present with same effect. What do I demand to do differently?
At bare minimum, I need name and email.
Thank you!
Tina says:

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

Thanks for this tutorial
Andrew says:

Nice one. Solved a big problem. Thankyou
Ian says:

With all the advances that have been fabricated in hardware and software WHY IS It Then Hard to copy and paste the info from my Outlook address book to Excell? Why tin't we only highlight, re-create and paste? Is at that place no one out in that location in cyber space who is smart plenty to write such a simple programme? Only wait at all the previous comments, someone has got to come upwardly with a simpler and/or better style of doing this.
Adithya says:

Tin we schedule the consign activity , on a daily basis?
Frank says:

Hullo:

I am using Outlook 2013. I am changing computers. I would similar to exist 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 in that location a certain step that I demand to go through using an consign process on the erstwhile computer ??

Give thanks you lot
Frank
LaDonna Connors says:

Hullo, I am having the aforementioned problem with %smpt% being added to my exports. I am using Part 2011. did you ever get a gear up for this problem?

thanks,

LaDonna
- Testing says:
  
  At that place is a trivial + beside "E-mail", then but pick email and drag it to the correct box.
Lilie says:

I tried doing this and not just does this non save as a .xlsx or .xls file but it doesn´t fifty-fifty open to prove a correct visual of the contats. information technology´due south all in code! I am trying to save into an excel not the .CSV file every bit is the but pick...Constant contact does not recognize this file type. I don´t know what to practise and I really don´t want to copy and paste every contact i accept. delight help!!!!
Lisa says:

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

Cheers so much! Y'all saved me at piece of work today!
Max says:

I'thou with Sadi on this one, same problem as in annotate 42. Any wise cyberspace wizard got an answer for us? :)
Clint Jones says:

Hi, I am using the "Export to .pst" role on an entire .ost mailbox(incl. subfolders) in guild to backup the post.

Question:
Does this create a fill-in, or will this move all the postal service from the server to the pst file?

I am just trying to create a backup, not motility the mailbox offline!

Cheers
:-)
Amrit says:

Hi All,

Can yous please tell me how can I export some outlook backdrop like- email, department, championship, company etc. of all contacts in an electronic mail grouping at once. I have not all the group members added into my contact list.
Mairi says:

Or even transfer their contacts into mine?
Mairi says:

My Boss is leaving the company and holds a lot of contact information that I will need. Is at that place a mode to export someone elses contacts from my Outlook, if nosotros share ontacts right at present?
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 information technology shows the number as 1 23233353) which make the dialing not possible. Whatever help .
Karolina says:

Hi.

Great tutorial. My question would be post-obit:

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

Hello,

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

I tried the post-obit only it does non working.

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

Dear Sir/Madam,

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

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

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

Give thanks you very much!
Ned says:

Thank you SO MUCH! Super helpful!
Tracey says:

Cheers for your help. Everything worked keen. You lot saved me heaps of time :)
Josephine Deelman says:

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

Which raises Question 2: on the default OUTLOOK entry grade Address is merely a 'free-form' block. But in reality there are individual Address fields behind it and information technology seems to make up one's mind ARBITRARILY which words/numbers go into which field. Can I change the TEXT BLOCK in that default class to show indiv addr fields? Thank you
Ron Harvey See says:

Hello Sir/MAdam ,

Good Twenty-four hours!

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

regards,
Andreea Timis says:

Hi,

Some of the people I electronic mail with are not saved in my outlook contacts. Is at that place an easy mode of exporting these east-mail service addresses apart from going thorough each one manually and saving them as contacts?

Thank y'all,
Andreea
Jan Kommer says:

I use Outlook 2013 and I concord 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 afterward all these years regularly stumbles on functions I cannot find. It frustrates and slows down my employ of Excel only I know of no alternative.
At present this effect. Because all phone producers apply unlike syntaxises with which they store telephone numbers I have to edit my telephone numbers before exporting them to my Siemens and to edit them some other way for my Samsung. I call this consumer harassment. I used to export my Contacts to csv. Edited information technology in Excel and imported it again in Outlook. A fast and easy procedure.
But why keep a winning equus caballus if you can make life miserable. Oulook 2013 generates a csv file with of all digits a simple KOMMA!. Do these people e'er remember 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 y'all would go very funny results. I say "would" because now comes the worst office: Yous won't get annihilation at all. The file contains just one column where all the contents of a row are gathered in ane field seperated by this notorious komma. Good importsoftware reconizes this and that system will work also. Of course a clever software maker would allow you choose your ain seperator (best is a exotic digit that is not otherwise nowadays 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.
Sue says:

I would have liked to see a finished sample of your excel spreadsheet afterwards the export.
AnneH says:

I followed your groovy instructions using the help of the magician. Nevertheless a significant amount of contacts were not exported. Did it twice, don't sympathize what I am doing wrong. I take outlook 2010.
Nancy Fay says:

Your instruction was perfect... my problem is that the CONTACTS folder in the Outlook Information File does not contain my contacts. Through a series of computer issues, my contacts accept moved to other "Contacts files in other *.PST files. Is there any fashion I tin indicate the export to 1 of these files?
Sjappie says:

Hello everyone,

First of all, bang-up explananation!Nevertheless I accept 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 listing". When I utilise this cavalcade and copy all contacts to Excel, this information is placed in a different row (unerneath cavalcade A), this means that I have street name in ane row, postal code and city in another. I added an screenshot (run into link below). This issue is very inconvenient while using it for lists etc. I really want to use the column "address for adress list" because I want one cavalcade with the adresses which are mostly used for sending stuff past post. Some people have 3 addresses, one for piece of work, one visiting address and ane 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 information technology to Excel it seems that this enter is copied. Meet epitome

How can I solve this?

(p.s. I am Dutch, so mayhap I didn't use the common words for explaining my problem).
- YumiZ says:
  
  I accept the same problem... Well chip different. I need to export huge amount of contact (Outlook 2013) for my dominate to Excel 2013 spreadsheet...
  I went for with "Copy/Paste" method.
  I added actress columns to dissever the address as "Street", "Metropolis", "Country/Region" and "Postal Code".
  Every bit quite lots of the addresses have Second LINE in the accost section:
  i.e. 123 E. Rose St
  Suite 456
  Phoenix, AZ 85789
  The 2d Line and the rest of the addresses ended upwards in Column A, which is the next row... Also there were some with some other line similar the name of the building, which created another row... So, one contact info was in Iii ROWS.
  I take likewise many to fix each one of them!
  How can I go ALL the Street address, Suite No. Building name/No. in One CELL???
  Please HELP!
Vincent says:

Howdy Sir Alexander,

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

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

Thanks.
Vincent.
- Vincent says:
  
  Correction : My question is how tin can i export these contacts without typing all of them please ?
  
  Thank you.
Maria says:

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

Here'due south a sample proper noun:
Mary, %Prendeville %

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

Any suggestions?
- Hello Maria,
  
  We accept never encountered this problem on our side. Nonetheless you lot 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 yous exported. Nosotros will await into the consequence.
  - Robin says:
    
    Hi Alexander,
    
    Did yous discover a solution to this trouble? Happens to me as well.
    
    Thanks.
    
    Robin
Ann says:

I'm using Outlook 2013 and Discussion 2013. If I consign a contact list from Outlook or use the mail merge wizard in Word I get the same file. But it is Non the contact list I come across in Outlook. Some items that I deleted and no longer see in Outlook are in both the exported and postal service 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 listing just why aren't the results the same every bit what I encounter 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 encounter in Outlook.
David says:

Hi.

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

If ou tin can help me or explicate why) on that i'll be happy. (I'm using office 365)
Bob says:

I too had an issue with actress % (pct 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 consign worked again equally expected. Something near the Custom consign decides to add the %.

I'yard using Windows 8 with Outlook 2013.
- Hello Bob,
  Thanks for the information. Nosotros accept never encountered this trouble. I'll try to investigate it.
Patty says:

This was very helpful. Articulate, piece of cake-to-follow directions. Thanks
Mike says:

Hi Alexander,

I take Outlook & Excel 2007. I used your 2nd method (copy and paste) and it worked fine, except for i matter.

The Proper noun of my Distribution Lists transferred over (just equally all the Private Contacts did), but the MEMBERS within the Distribution Lists didn't (and I didn't actually expect that they would).

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

Thanks for your time and assist - I capeesh information technology,

Mike
Michael Hume says:

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

Cheers, it works..!!
Great Chore.
Amy says:

What are those % signs? Why exercise my electronic mail 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 become an "errors" bulletin in constant contact. What now? Cheers for your advice.
- Amy says:
  
  Using Outlook 2013, Windows 8.
- Hullo Amy,
  
  It looks strange. Please send your sample workbook to support@ablebits.com and we'll try to help.
K.Karthikeyan says:

i want export company andress please sir
uday says:

how we accept backup of all suggestions mail service id list.

if we type 'a' letter in To or CC automatically visable mail id list outset with letter 'a', and then i need how we have backup of all accost.
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. Whatever advise.

Thanks
Linda says:

I use Excel 2013 and Outlook 365. When I export, everything ends up in column A. What am I doing incorrect? Also,is it possible to cull a group to consign rather than searching for each grouping fellow member?
- Hullo Linda,
  
  Most probable, the delimiter in your CSV file is dissimilar from the symbol that Excel uses to separate fields when importing the data (regional settings). Please look at this web log postal service how to cope with this problem:
  https://www.ablebits.com/function-addins-blog/convert-csv-excel/
  
  Equally for your second question, I am sorry I tin can't suggest you lot annihilation.
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 alter the view to phone and add together the columns they are blank... help!
- Howdy Max,
  
  Information technology is hard to say what can cause the trouble. Information technology may happen if you take several folders with contacts. In this example, please make sure you choose the correct one. If it is not the case, y'all can probably try to discover a solution on stackoverflow.com or answers.microsoft.com.
Simon says:

Thanks for this commodity information technology was very useful, exporting every bit a CSV file has helped. However n the electronic mail extraction column it displays the e-mail as

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

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

Please please help !!!
- - Linda says:
    
    I'm having the same trouble as Simon. I followed the steps to remove hyperlinks in Excel but how exercise you remove them from the source workbook?
    I'1000 exporting them from my outlook contacts. I'm using Microsoft Office 2013. This is how the data looks when I export it:
    Proper noun Field:
    lastname%,Firstname%
    E-mail Field:
    email@abc.com%FirstnameLastname(email@abc.com)
Dyan Nill says:

Sorry, using a CSV file and Outlook 2010. Thx again.
Dyan Nill says:

I have exported my DL and am trying to reimport it. When I get to "select destination folder", in that location are no folders for me to pick and the "adjacent" push is greyed out. My but selection is to become back or abolish. How do I go a destination folder listed in that location? Thx.
Luz A. Rodriguez says:

All-time e'er teaching.
Thank you
Bonster says:

How-do-you-do, I take followed these management but my fields will non paste in a single row, they insist on stacking similar this.
Full Name Mobile Phone E-mail Categories Home Address Home Address City
Marisela and Alfred Nuno Market place Clients ii 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?
- Hello Bonster,
  
  How exactly did you lot copy the contacts – via a csv file or clipboard? What is your Windows version, Office version and localization?
- Joseph Lyons says:
  
  Information technology'due south probably onetime news by now, but the solution is to choose the "Home Address Street" column, not the "Home Address" cavalcade. The latter cavalcade is the standard Outlook column, and it includes that carriage return in the formatting behind the scenes.
  
  There is no "Mailing Accost Street" column, unfortunately.
Denise says:

Will the contacts still exist available in outlook if I use the import/export method you suggest? Which method is best for copying Distribution Lists, non individual contacts?
- Hello Denise,
  
  Of course, the contacts will still be available in Outlook. Equally for copying the distribution lists, both methods will work, and so y'all tin cull the i you similar ameliorate.
Byron says:

I exported the pst file. I have inverse my listen and practice not want practise do this equally a back up. Every time I open outlook (20130) I get pop up windows saying that outlook tin can non locate the pst file. I have to abolish the windows so outlook will go ahead and open. How tin I tell outlook to stop trying to export anything?

Thanks,

Byron
EricH says:

Hey Alexander,

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

But load your table with your existing contacts in Excel and click on "ContactXPorter" - the residuum is super piece of cake.
More details here:
http://www.h-d-c.de/php/services_software_contactxporter_en.php

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

Best,
Eric
David says:

How-do-you-do Alexander,
I have the same trouble as Matt. Is at that place an easy fix ?
Thank you
- Hello David,
  
  Lamentable, I do not have a prepare at the moment. I will do some enquiry afterwards this calendar week and and so report yous the results. Please allow me know what your default browser is and if you accept all the latest updates installed.
Matt says:

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

First
"Name Terminal"
"Name Company Street"
"Address Metropolis State ZIP/Postal"
Code
- Hello Matt,
  This is a very strange issue, I have non heard most anything like this before. Could you lot send me a screenshot of what you lot see in Excel at alexander.frolov@ablebits.com?
Kayla says:

What about the information under "All Fields",how to export that to excel?
- Hi Kayla,
  Use the second way described in the commodity (past copying / pasting).
  In step 3, select all the contact fields in the right pane and click Remove, to avert duplicates. Select 'All fields' under "Select bachelor columns from" on the left, select all fields under "Available columns", and then click the Add button.
Kari says:

re Outlook 10 For me the File menu to options to advanced to export does non piece of work because information technology does non allow me to cull the category in contacts that I desire to export to excel.
I used to do this all the fourth dimension in the past simply 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 non available.
I take used outlook for years and years and all of a sudden it is more hard.
What am I doing wrong??
- Hi Kari,
  
  Regrettably, it is not possible to export contacts in the selected categories when using Outlook's Import/Consign function. Every bit an alternative, you can choose "Category" in the "Evidence Columns"" dialog (it is step 3 of the first solution explained in this commodity), then export all
  contacts to Excel, and then filter or sort past the needed category.
  
  Some other solution is to export contacts manually past copy/pasting and copy only the contacts in the needed category in the custom Outlook view.
Jeff Jones says:

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

Thank you
- Hi Jeff,
  
  Thank y'all for your question. For me to be able to give you the most accurate and correct reply, please let me know your Outlook version and how exactly y'all grouped the contacts by categories. Did y'all simply assign a category via the "Categorize" context menu, or did you create an Additional Address volume for each category, or several distribution lists?
  
  If you used the Categorize option, so yous tin can use the 2nd approach described in the article - Export contacts from Outlook by copying / pasting.
  
  Earlier y'all perform step 4, sort your contacts list past the "Categories" cavalcade, simply past clicking information technology. Usually this column comes concluding in the list, in the correct hand part of the screen. Select simply contacts of the business category and then copy/paste.
  
  Alternatively, you can export all contacts to Excel, and then sort past the "Categories" cavalcade. This seems to be an easier way.