How to Export iPhone Contacts [Windows 7]

If you are going to change your iPhone or just want to take backup of your iPhone contacts, here is a simple way to export your iPhone contacts as csv file in Windows 7 and you can open this csv file in Excel. You just need your iPhone and iTunes running in Windows7. Windows XP users here.

Export iPhone contacts as CSV file or to Excel

Download and install iTunes, after installation Run iTunes.

Connect your iPhone with computer using data cable. In iTunes if sidebar is not showing, press Ctrl + S to view the iTunes sidebar.


On the safe side BACKUP YOUR DEVICE FIRST , Right-click on your device and select “Back Up” (in-case of any problem with iPhone Contacts you can restore your contacts from backup later).

See also: Make free ringtones in iTunes

Connected iPhone device

When iTunes finish the back up process, Click on “Info” tab

iTunes info tab

Click on “Sync Contacts with” check box, select “Windows Contacts” from drop down menu and click “Apply” or “Sync” button

sync contacts with windows

Press “Windows + R” keys form keyboard to open “Run” window and type “wab” in “Open” filed and hit OK

type wab command in run

Click on tiny arrow and select “Export” as shown below

all contacts

Select “CSV (Comma Separated Values)” option and click “Export” button

export csv

Click on “Browse” button, choose location to save iPhone contacts as csv file

csv export

Select iPhone contacts fields that you want to export and hit “Finish” button

Field to export in csv

You will see this message if iPhone contacts exported as csv file successfully, hit “OK” button.

Windows Contacts

Now you can use this csv file to import iPhone contacts in any other application or device or you can open this file in Excel to view all iPhone contacts.

See this guide if you want to Sync iPhone contacts with Gmail

188 comments… add one
technicia June 2, 2010, 8:51 am

Great information to export iPhone contacts, I’ve been looking for something like this for a while now. Thanks!

Anika June 9, 2010, 5:49 pm

thanks for writing this guide about iPhone contact syncing to computer.

Sean Brown June 20, 2010, 2:04 am

You rock! I had no clue about “wab” or the Contacts folder in Win7. I was hitting brick walls with the very frustrating Apple philosophy of making things exceptionally challenging to convert to and from “the Guild.” Not only did you nail exactly what we needed to do, you did so in a very simple, step-by-step manner. Thank you for taking the time to post this!


trickYguY June 20, 2010, 6:07 am

Thanks Sean.

Jay July 4, 2010, 4:19 pm

I follow you instruction, sync via iTune to Windows Contact. But after I run “wab” the folder show up and show only 1 contact (mine). What should I do?

Jay July 4, 2010, 4:53 pm

Oh ok, after I sync it the second time it appears 😉

eyePH0NE July 1, 2011, 12:06 pm

I’m in the same boat – when I run “wab” it just opens up an Explorer window with on *.contact file.
I synced a second time, but this did not help.

gsraj May 21, 2012, 11:00 am

i had the same problems at first and when i checked again by disconnecting my phone and connecting it again, i noticed it had sync’d the contacts with Outlook instead of Windows although I am pretty sure I had selected Windows Contacts. I selected Windows Contacts again, clicked Merge contacts when prompted and it worked! Thanks for this post ! Saved my day!

sMan August 3, 2010, 5:09 am

This post really helps me to save iphone contacts, Thanks.

soulwave August 15, 2010, 9:48 pm

I’ve been trying to get this damn thing done for quite a while now and i was about to throw this damn iPhone away.


Mike August 25, 2010, 2:03 am

is it for sure that this will not sync it other way around? so it doesn’t wipe out the contacts in iPhone? cheers

Kevin September 14, 2010, 11:39 pm

Thank you! Worked like a charm.

yomi September 24, 2010, 11:38 pm

this is great, good info that works. I have been trying to do this for hours after trying all sorts of things from advices from people that should know – telephone sales people. Thanks it really works like a charm. God bless

Tippy October 1, 2010, 5:58 am

Perfect! Thanks!

khan October 10, 2010, 2:05 am

this works for newer Nokia phones contacts too, if u sincronise it with ovi and back up your contacts into your computer, after doing that, folow the same steps begining with Run->wab, the rest is the same. worked with windows7, probably vista is the same. hope this helps

ji October 22, 2010, 7:26 pm

You ROCK!!! Thank you so much!!!!!!

Haniya October 30, 2010, 12:42 pm

your guide to sync iPhone contacts to system works perfect. I just tried it thanks for all these iphone tips.

BigRed November 8, 2010, 1:20 pm

You are brilliant! A bigger genius than those ‘Geniuses’ at Apple support. All they could recommended was the Mobile Me program, which is okay if you have everything ‘Mac’. It is such a pain losing one’s contact list! And now I feel secure it won’t happen again with this back-up system. Honestly, if I wasn’t married, I’d marry you! Thanks for all your help.

Now, hopefully, if ever the day comes, it will be easy to restore the backed up contact list into the iPhone from Windows 7? Would you kindly point me in the right direction on how to do this if you haven’t covered it before. Thanks again.

Jonathan Trac November 19, 2010, 6:22 am

Thank you very much for the information. It really helps me a lot backing up my contacts.

Jo November 30, 2010, 5:41 am

I was backingup/synching into my google account but it has stopped doing that so I would like to follow these instruction via Windows 7 to create a csv file but I’m also concerned (as in POINT 7)that it will work the other way around and wipe my current iphone contacts. Please could you let me know before I do it? Thank you

trickYguY November 30, 2010, 6:32 am

If you are syncing with Windows 7 first time then you don’t need to worry about it. Anyway If you afraid of losing your contacts, you can backup the device using iTunes. Connect your device with computer, and from left pane of iTunes Right-Click on your device and select “Back Up” option. You can restore your device from the same menu in-case of lose.

Now you are safe, Export your iPhone contacts as CSV file using above guide.

ppj February 3, 2011, 4:19 pm

Thanks for helping me.Your instrution of how transfer iphone contact to window is very clear in step by step.
thanks a lot

Moovintarget February 4, 2011, 3:52 am

I tried this and it wiped out all of the contacts and left me with one contact labeled with my name.

It did not backup my contacts. It deleted them.

trickYguY February 4, 2011, 4:02 am

You can restore your contacts if you have backed up as mentioned above in then step after downloading and installing iTunes.

Moovintarget February 4, 2011, 4:37 am

I selected restore device in iTunes. It began restoring. the phone then rebooted. iTunes automatically performed a sync when it rebooted. Now my .csv file and my iphone have lost all contacts.

I had a blackberry before the iPhone. I wanted a bigger screen and a touch screen. Man do regret my decision to buy this thing. It seems to be geared toward children who play games, listen to music and mess around with goofy apps. My iphone left seqential backup files on my CPU. I could restore any one of them including the firmware at will.

Sync is a rotten way to do anything. It sells a bunch of worthess apps and services as business people live in fear of losing their information. Trust me. I know. I have over 1500 contacts that get entered into my phone while I am on the road. I live in constant fear of losing them, as I have now.

Any idea what to do now.

capyates December 8, 2012, 5:40 am

Spring for DrFone. It works. I just recovered all my contacts, notes, emails, pictures, etc off a totally broken phone. Hint: install the “free” app, then uninstall it. When you do that the price drops by $40!

skiier February 28, 2011, 10:46 pm

Have tried several times, but only get 8 of my contacts to sink (several hundred missing). Any ideas? I’m desperate. Thanks.

Big Dave March 6, 2011, 4:49 am

Hey there.
I have ttried all of the export suggestions and I have had no luck.
I have gone as far as exporting all my contacts from both Outlook and my GMail so that there is a clean slate, the bloody phone won’t export all of the contacts. Am I missing something? the phone is a 3GS with the latest software.

It’s driving me mad……. thanks for the other tips, love your work.

amol r April 27, 2011, 3:48 pm

I used this to copy the contacts from the iphone and it worked sucessfully.
I searched the net for a long time and was about to give up and i got this link…..
thanks a ton

EagleBrewing May 12, 2011, 8:33 am

I don’t get it.
It doesn’t work for me.
I get one record and it just has the name of my iPhone (I think).
Along with a bunch of commas.
Why do an Export form WAB?
I thought the flow of data was from iPhone to WAB.
That would be Import, right?
Anyway, nothing happens.
I wish someone could set me straight.
Thanks for the help.

foxinabox May 13, 2011, 7:49 pm

Don’t forget to click “Apply” after selecting “Windows Contacts” in the Sync Contacts window. Thank you so much for the tip – was able to get all my contacts’ info in 1 minute!

Abdullah May 18, 2011, 10:17 am

Thanks…….you are great…… solved my problem

Anon May 23, 2011, 3:34 am

I followed the instructions and opened it with excel afterwards, it doesn’t show the phone numbers,only the name and last name. is that suppose to happen?

Alon June 14, 2011, 3:26 pm

before you export, make sure you have checked all relevant boxes including mobile number, office etc.

ankits4680 May 30, 2011, 5:24 pm


Gr8 article.
Well is it possible to import in the exact format as iphone
because all the addresses are seperated by the default values of windows contacts.

thankful June 3, 2011, 8:39 am

thank you for putting this together. Just backed up well over 1000 contacts that were locked on my iphone. Very well written guide; simple to use.

thank you. thank you. thank you.

cnote5153 June 6, 2011, 6:22 pm

Great info!! I was struggling with importing my iPhone contacts to Windows 7. This was quick, easy and saved me from purchasing software to do the import. Thanks!

Becstar June 8, 2011, 10:58 am

Hi I have successfully completed exporting my iphone 4 contacts to windows csv file.

However when I tried doing the same process with my partners iphone 3 when it came to syncing and running the wab my contacts from my iphone 4 appears and none of his??? I deleted them all and tried process again but now nothing shows up.

Can someone please help me with this.


bryanvgr July 10, 2011, 11:42 pm

Thanks for the info!!! i was going nuts trying to find out how to do this, and was about to start entering them manually.

the final step was to tell windows live mail to merge duplicate contacts. Finally my mess is almost sorted!

VJ July 19, 2011, 9:23 am

gr8 work… was looking for this since months…. thnx…

xyz123 July 28, 2011, 10:21 pm


I followed the method but i have a problem in that all contacts are transferred but where i have a problem. in some cases where there are more than one phone numbers for contacts, both have transfered but in other cases one number is missing.i am checking in wab folder and in csv file both.

ajzhome July 30, 2011, 8:47 pm

thanks a ton.. all working

MobyDick August 5, 2011, 2:56 pm



mabattag August 20, 2011, 3:52 am

thanks thanks thanks and thanks!!!

bizoonik August 30, 2011, 9:36 pm

useful, thanx, keep making tutorials like this one

addem September 21, 2011, 8:17 pm

when i go to the info page my sync contacts with doesnt have a drop down menu and there are no options. i am unsure why this is.

OmegaRoach December 4, 2012, 9:29 am

Same problem here. No drop down box next to the Synch with option…

JTM January 4, 2013, 9:47 am

I am having same problem. I’m running windows 7. I do not get the drop down menu. I do not have outlook installed. Would that be a reason?

JTM January 4, 2013, 10:10 am

ADDEM, I just figured it out. You must go to settings on your iphone. Click on icloud. Then click off for contacts. You just turned off the synching of contacts with icloud. Now you will see the drop down menu.
Hope this helps.

njcmiller September 30, 2011, 10:35 pm

This didn’t work as expected for me. In fact, I had the same problem as EagleBrewing (see comment, above). I have 85 contacts on my iPhone 4, and only 1 (my own contact record) was transferred to the CSV file using this process.

Steph October 3, 2011, 3:54 pm

I have followed this step by step but then I open the file there are no contacts there and my iphone has been wiped of all my contacts?

What can I do, please help!!

w40dtbl October 16, 2011, 4:34 am

i empathsize with you above, I ‘played’ with it for half a day to become familiar with Itune, ITune is not exactly intuitive. You need to be very careful and read and know exactly what the damn tool is telling you. if you forgot to review the Advanced section near the bottom of the Info page, and uncehck ‘replace information on this Ipad/Iphone, whatever is checked will get overlaid. if you had replaced the contact on your computer (messed up to only 1 entry left) then your iphone will get sync over with one entry left – the only remedy is if you had backed up step performed before so you can go back and restore from backup.

with Win 7, it accesses the contact info already synced by the itune ‘apply’ step hence you only need to ‘export’ and not import. into the CSV format. Also, you need to check the ‘mobile’ fields, etc in order for the data to show up. I have some fields came from Ipad and they did not have the corresponding field names and the values did not get carried over into CSV fields

ericdrobertson October 6, 2011, 3:15 am

how do i import them back to my iphone?

w40dtbl October 16, 2011, 5:45 am

you can easily google how to setup your iphone to receive the contacts back from either yahoo, gmail account, assuming you had performed the step to get the iphone contacts sync up to your email account first.
see example on how to with Yahoo

israr October 8, 2011, 11:40 pm

thanks so much you solve my problem..thanks once again its work..

PER October 11, 2011, 4:17 pm

Good, but a problem: The field “other” (DK version “andet”)- do NOT apepar in the export, how can i get this included?

eyePH0NE October 17, 2011, 7:34 pm

Maybe this time it’s allowed to say that there is an app that makes it as easy as can be: My Contacts Backup

Pierluigi Vernetto October 19, 2011, 1:42 am

thanks a lot, it solved my problem.
Anyway ITunes and IPhone sucks, big time.
The morning I have decided to buy an IPhone I wish
I had broken my leg instead, it would have been less painful

tetaime November 4, 2011, 6:55 pm

This is wonderful, but do you have any way to do this if I don’t have my iPhone? my iPhone was stolen and I still have all my backup on iTunes/ iCloud, and now have a Droid… any way to export my contacts to it?
Thank you!!

Terry November 9, 2011, 11:16 am

Simply Beautiful… Thanks

tony November 19, 2011, 11:51 pm

Only the contacts from my windows contacts were transfered to my iphone, not the other way around. Im using iphone 4 running on firmware 5.0 and I have the latest itunes installed.

m rahman November 28, 2011, 6:24 am

Worked well, thank you very much.

Goldenlady November 29, 2011, 1:08 am

Thx for this; it’s been a great help!
One question: I need to transfer my iPhone contacts onto a sim card – any suggestions?

dilip patel December 7, 2011, 11:23 am

pls iPhone backup transfer to mobile to PC & PC to mobile .

chaz December 12, 2011, 10:45 am

it works perfectly fine. thanks a ton.

Vdj December 18, 2011, 10:11 am

Thanks for the info – very easy – BUT – when I exported the numbers, after I checked ALL options, all ‘other’ phone numbers are missing in the excel file; only ‘mobile’ numbers transferred. There is no ‘other’ option (I have a 3G iphone, and only a few phone numbers that are entered as ‘mobile’, as I didn’t really pay attention and/or put effort to mark them as ‘mobile’). Does anyone know how this could be fixed? I believe this happened as there is no ‘other’ option (among many others) to be checked off.
Thanks in advance for all your help.

Sheila January 6, 2012, 7:37 pm

Thank you for posting this information. I followed all the steps and it worked very well.

Deepak January 14, 2012, 9:54 pm

Thanks you … you are the best

Aekapol January 15, 2012, 2:54 pm

I think ,that iOS Devices when I sync with empty library or empty contact. My contact in iOS Devices is gone.
I first try by your blog post. contact in my iOS Devices isn’t lost. and added in my windows contact.
Thank you for this article.

zalastar January 18, 2012, 10:43 pm

Thank you so much! Really clear and easy to follow instructions, worked first time.
Apple couldn’t help me, TMobile couldn’t help me, so it’s a good job for us technophobes that there are clever folks like you around!

Ripan Arora January 25, 2012, 10:09 pm

its working ….

stallionbambi January 27, 2012, 2:01 am

Hi, this was great thanks. Just another tip, make sure you turn off Icloud or it won’t pick up your contacts.

tararez January 31, 2012, 7:11 pm

thank u – this really helped me – shockign that itune and apple support is so unhelpful

jeevi09 February 5, 2012, 8:27 pm

Great information. I did not know about wab. very much pleased to know it. Thanks a lot

NoUsername February 6, 2012, 12:55 am

I just wanted to add that if someone had other labels for phone numbers than the standard ones, they will not get synced using this method. So for example, if you have a contact that has a “Skype” phone number or a “Mobile2” phone number or “G-Number”, etc…. none of these numbers will get saved. Windows Address Book will only copy the standard labels for phone numbers, such as, Mobile Phone, Business Phone, etc….

raheeltariq February 7, 2012, 9:20 pm

Brilliant! I was looking to backup my contacts since many days, now my issue resolved, you are real champ and you rock

Raheel Tariq

jon February 19, 2012, 6:59 pm

I’m using the iPhone 4s and Windows 7. After following the exact steps, this method is not working.

The problem is that my Windows Address Book (“wab”) is blank, even after clicking “Apply” and then “Sync” on iTunes.

trickYguY has a screenshot of his Windows Address Book (“wab”) with ALL his contacts from his iPhone. My Windows Address Book shows zero contacts, so clearly they aren’t being synced onto the computer. Thus when I export the contacts I get an empty .CSV file.

Any thoughts?

melindambradl June 2, 2012, 11:05 pm

I am having the same exact problem. Did you ever get it fixed?

shanaw October 29, 2012, 8:41 am

I’m having the same problem! I cannot get this to work!

Username February 20, 2012, 9:26 pm

Use free app “My Contacts Backup” from the App Store, works like a charm.

eric February 26, 2012, 1:16 am

Hi all – thanks for the post – I’ve done this numerous time successfully without issue – only problem is that even after I sync / update the contacts / many thousand – it seems to lag behind a few weeks – meaning the recent contacts from iPhone are not merged into Windows Contacts (or Outlook) – IDEAS? thx in adv

Maya March 7, 2012, 8:03 pm

I didn’t even know that you can manage contacts with Windows. I just tried it out, but honestly it is not very user friendly, especially when it comes to the creation and modification of contacts groups. But, I like the idea to manage contacts directly on the PC and to sync it afterwards with my iPhone. Is Windows contacts the only way to do so, or are there other possibilities?

Shuaibi March 16, 2012, 7:12 am

I have tried several times, but I get only 175 out of more than 1000 contacts. Any ideas? Shall I copy them one by one and throw this damn stupid Iphone4. Thanks.

aroarizona March 16, 2012, 8:21 pm

You rock! This totally did the trick! I was afraid that I was going to lose everything… AGAIN!

vinno May 1, 2012, 3:51 pm

I did everything said here and it didnt work, the contacts was blank. double checked I did it right and still nothing.

Harry May 10, 2012, 2:14 am

Thanks! I was tearing my hair over the lack of a ‘physical’ store of my contacts due to the lack of an address book on Windows 7, and MS’s insistance I use Windows Live, which I dont use and dont want.
This works perfectly!

trickYguY May 10, 2012, 1:24 pm

Great, if you perfectly export iPhone contacts.

Jane May 11, 2012, 3:21 pm

Hi trikYguY. Thanks you for the useful instructions. I feel lost though. I still do not understand why every single piece of information (including my personal contacts) must pass through iTunes first in order to get transferred. I am so frustrated with iTunes now. I wish there was a simple and direct way to back up my iPhone contacts.

J. Aquino May 13, 2012, 5:16 pm

Excellent information, this was what I really was looking for. It works!

Hanne May 25, 2012, 2:24 pm

Will this interfeer with my icloud back up?
I run my backup though icloud and do not want to risk to damage this.

oalexz May 26, 2012, 5:01 pm

I tried and all I got were the headers in an Excell spreadsheet. My iphone 3GS has the latest update 5.1.1 and I am running Windows 7 Ultimate and my iTunes is up to date. I have no clue what went wrong. At the end of the process I was expecting a message saying all cotacts have been exported but did not get that. Thanks for the instructions. This was nice of you to put these instructions up, but it did dnot work for me.

oalexz May 26, 2012, 5:05 pm

I tried again and receive the message that my files have been exported. They were not. Again, only the headers were there 🙁

melindambradl June 2, 2012, 11:01 pm

I went through the whole process. When I open the windows excel doc it only shows 1 contact and thats my computer. I have gone through process like 10 times. Please help!!

Rajender June 7, 2012, 10:59 am

Awesome work. it worked just like magic, thanks a lot

Mubrra June 18, 2012, 11:00 pm

I followed all the instructions given above accurately, but when i opened the MS-excel folder which i named as iPhone contacts it just had the first name, last name etc. Not a single contact of mine. What should I do ?

dihegov June 22, 2012, 8:05 am

Today I needed to do a backup of my contacts and after searching I found this other method. Dont get me wrong this is good.


simirani June 24, 2012, 9:56 pm

hello! 🙂 woahhh i think u had the best answer the icloud thing i just paid attention but do u have to save each one? or is there a way to save all?? thanks 🙂 cheers! 🙂

marieoxford June 24, 2012, 12:57 pm

no success here, pls help….It worked for my duaghters ipod. But when I try to sync my iphone with our new laptop this way it just copies her contacts again, not mine. even though I have created a new folder for my contacts…..very frustrating spent hours trying to get my contacts from my iphone4 to the new laptop- windows live mail….

oalexz June 26, 2012, 8:13 pm

Thank you so much for these wonderful instructions. They worked perfectly the first time, with Windows 7, 64-bit system on my fully updated iPhone 3GS. Now I can change to an extended battery with confidence.

marieoxford June 26, 2012, 11:34 pm

aah I have sussed it now! The problem was my icloud setting was on for “contacts”. I thought this was to backup not to sync to icloud. all the on/off settings under icloud are for synching not backup, in true apple style it doesnt tell you this! you can only sync to one of pc/icloud so I turned icloud contacts off & it synched with imported contacts as above easily! what a waste of several hours, if only this was clearer on apple website/ settings!

dfoxpemb June 28, 2012, 9:40 am

Many many thanks, this is a fabulous help

Emad Fouad July 7, 2012, 8:18 pm

I have followed these steps and I have lost all my contacts. I am sure that I have followed the steps correctly. I am very frustrated and pissed off and i really don’t know what to do

mar February 2, 2013, 8:40 pm

waste of time!

Ahmed July 16, 2012, 12:41 am

Did you follow the first step and backup you device first.

If you did then you no need to worry, you can restore contacts from backup.

Persnickety July 18, 2012, 6:59 am

A MILLION thanks. To those who are only exporting a single contact (their own): go back to step 2 and “Sync contacts with” .

The instructions worked perfectly, what a relief.

iTunes is so un-intuitive, it drives me crazy! Please rewrite ALL the instructions! Thanks again.

Guest July 19, 2012, 12:56 am

Why do I have to turn on sync… and even sync… when I don’t want to “sync” at all?

I want to “Export iPhone Contacts as CSV file”… just like the title of this page says.

shilton July 24, 2012, 1:17 am

Thanks for this, however only 8 of my 200 contacts exported. The 8 were Icloud contacts what ever that means? How di I get every single contact on my phone to export? Thanks alot

shilton July 24, 2012, 1:53 am

I don’t understand this Icould thing. I’ve tried turning it on and off, it doesn’t do anything. All I want is to have all of the exact same contacts on my Iphone as I do in my Outlook, it shouldn’t be so difficult! I have contacts on my phone that are not in my Outlook contacts, how do I get them there? Thank you

jacob July 26, 2012, 11:20 am

it worked! thanks!

Chasmo July 29, 2012, 7:09 am

Awesome, Thank You for the fantastic Info. Great site

shilton August 8, 2012, 5:31 am

this worked with my loast Iphone but not this time. There is only 5 contacts in the export list, but I have a couple hundred. Where have they all gone? Is this to do with Icloud?

jon doe August 23, 2012, 9:40 am

for those of you not seeing the contacts show up in your windows adressbook its possibly due to the fact that you did not disable your icloud storage (general settings > icloud > storage & backup > icloud backup > off)

jon doe is the man November 8, 2012, 10:27 pm

This solved it for me! Thank you thank you!

Brand August 27, 2012, 8:05 pm

It don’t like iTunes and didn’t use it since at least December 2011. Additionally I don’t trust iCloud. As I am certainly not the only person who’s syncing an Apple device without iTunes and I just recently found a solution to sync my contacts directly with my PC. The app is called Copy Trans Contacts and a good alternative to the iTunes/iCloud sync!

Carmello August 28, 2012, 9:20 pm

Brilliant – very easy to follow! I have been looking for some time to back up my Iphone contacts, in some other form than Itunes and I now happily have an excel document with my contacts there! Thank you.

elli August 30, 2012, 2:01 am

And maybe worth to mention for all those people (like me) that don’t use iTunes. There are some tools that allow you to export your iPhone contacts to Windows without iTunes. E.g. my contacts backup and copy trans contacts

Peace September 2, 2012, 7:00 am

Your are really life saver for all of us. I think this Idea work Million Dollar and you should Patent this and sell to Apple to make every one life easier.


darkstrado September 9, 2012, 1:07 am

my 2 cents. This works. To be straight-forward,
If your iPhone is connected to iCould, delete it from the phone.
You must do this on your phone. Also make sure itunes isn’t connected to iCloud either. Comprede?

yaume September 18, 2012, 12:54 am

Hi, when I export my contacts, it only exports the contact I synced with google contact. I don’t have the contacts that were initially entered in the iPhone, i.e. those with phone numbers

Jim September 23, 2012, 1:48 am

Glad I found this site. Thanks for being here.

I have a long story following about my success using your instructions. It’s not bad!!

Fairly easy to get all my contacts downloaded from my iPhone3GS running the new iOS6. I did have to tweak your instructions a bit – possibly due to iOS6. I’m also running Win7, MSOfc2010, iTunes 10.7 [just loaded] on my desktop PC. “Tweaks” follow:
1. I found that in the left column the DEVICES folder with my iPhone did not load at first.
2. I had to press CTRL, then SHIFT, and hold both down as I connected the USB cable to the PC.
3. Your instructions showed backing up the iPhone before getting it loaded. You need to move that line down in the sequence.
4. After that I did click on the INFO tab – then clicked Sync Contacts with – chose “Windows contacts” – then clicked on “Apply”. I did not click the lower Sync because I was just doing a download of my info. Also, the new iOS6 UG, page 14, warns against doing this due to possible duplication of info.
5. Your next direction starting with “Press Windows + R” has a typo using the word “filed” when I think you meant to show “field”.
6. In the “Run” window you show the “wab” already there when something else will show when it opens. I just replaced what was there with the “wab”.
7. The next window shows the list of items in sequence but in my PC all these showed in a “task bar”. It did all work ok.
8. Clicking “CSV”, “Export”, choosing a location on my hard drive, “Next”, selecting the fields [I chose all just to be sure I didn’t miss any info] then “Finish” and all the info came out fine as a CSV file which I saved and later converted and resaved as a MSEXCEL2010 file so I could manipulate it.

Basically – all this worked out just like I wanted.

Thanks for building all this for people like me.

Now – a question – can I make changes in the Excel file, change it back to CSV and load it back into the iPhone?
If you don’t have that program available yet I, for at least one, would like to see if you can do it.

Thanks again.

Jim Lynch, Shorewood, IL

IphoneUSER September 26, 2012, 1:26 am

thanks alot dude..

YEAAHHH ! September 27, 2012, 1:47 am

Super génial!
Thanks a lot man!

paulosw2 October 3, 2012, 12:55 am

Thought this looked like a great plan until I synced to ‘windows contacts’.

This lost all my named phone numbers from my iphone and had hundreds of work email names and emails in there place. Not very helpful.

Mubashir Aziz October 18, 2012, 10:28 am

thanks a lot for this valuable info.

Alan October 30, 2012, 5:53 pm

Try Contacts To Excel and Export My Contacts on the App Store.

john t November 3, 2012, 11:06 pm

Yet another thanks from me.

My phone died yesterday for an hour and I panicked as I thought I lost my contact numbers. Phone came back somehow, but I think it’s on it’s last legs ( 3GS btw).

SO I thought I’d write out my lit of contact numbers, all 145 of them lol.

Sure glad I found your page.

happymind November 16, 2012, 12:07 am


Thanks a ton, my iPhone is losing battery pretty frequently and so if I don’t charge my phone frequently it just dies, which means I am stuck with all my contacts on the phone, even I cant use my land line as my phone is dead and don’t have access to all my numbers. I was desperately looking for a faster way to access my numbers independent of iPhone and I am able to do it successfully now. Thank you.

ntinos November 25, 2012, 12:11 am

Thank you very much! That was the most helpful guide I have come across untill now!

todd December 6, 2012, 4:58 am

heres what i did to export from iphone 5 to windows 7 pc, edit, then import back to iphone:

I was able to export from phone and save to csv using trickyways instructions above.
Then I exported a csv of contacts from windows live mail and combined data from both files into one.
Then I imported the final file back into windows live mail and exported all finalized contacts from windows live mail this time choosing the vcf file type option.
Then I navigated to c/user/contacts and imported these files into this folder (since this is where windows 7 stores contacts and is the location itunes syncs from)
Then I synched the iphone with windows contacts using itunes (info/sync windows contacts)

haymaker55 December 6, 2012, 9:34 pm

HELP!!! I tried this and it eresed all of my contacts off of my phone. The .csv file in my computer is blank except for my own contact info. I had well over 200 contacts and have absolutely no clue where they went. Anyone have some thoughts?

Ahmed December 7, 2012, 5:35 pm

Did you backup your iPhone using iTunes before following this guide?

PeeDee January 30, 2013, 10:04 am

Hi trickYguY.

Love your work!

I have noticed with the newest version of iTunes, I’m no longer presented with a check box at your step —- Click on “Sync Contacts with” check box, select “Windows Contacts” from drop down menu and click “Apply” or “Sync” button —- Maybe this has to do with iCloud ??

Could I ask you please to maybe offer some work around for us less wise? I would really appreciate it. Thx Peedy

Sharon Stryker February 15, 2013, 2:07 am

A friend forwarded the LINK to an app to move Contacts by exporting them from our iPhones. MUST we open it and do FROM the iPhone? Or should we open on PC & download there? It seems to take a PC to make it open, right? Need some help on Exporting Contacts & have an iPad also. Do I need to do on both devices, or will the iPad and iPhone sync?

Khalid February 16, 2013, 2:34 pm

Thanks a lot for info

ModSwitch May 14, 2013, 7:00 pm

Thank you so much for this information! I can relax now that my info is restored.

Ruffian May 21, 2013, 12:56 am

Thanks a lot worked for me.

olivedodson June 6, 2013, 5:17 pm

I never knew

liang August 5, 2013, 9:58 pm

i could not see the export option once synce to windows contact is done.

Rocco August 10, 2013, 9:49 pm

for some reason I didnt get the >> arrows to chose export, I just get Organize, Views and Burn.. 🙁 Is there something Im missing? I could sync all of my contacts though.. at lease I can see them in the folder.

Help me.. cuz it seems like a super easy way to export my contacts. Thanks!!!

Robin August 15, 2013, 10:59 pm

When I open ITunes Idon’t see devices or that menu that is usually down the left hand side (windows 8)

how do you turn that on? I can’t see it in View…rather, I don’t see an option under view from the menu bar.

Robin August 15, 2013, 11:01 pm

ah, show sidebar…dang my bad

manbir August 18, 2013, 2:27 pm

It worked bro!!!
Thanks a lot…


tikylau September 10, 2013, 5:08 pm


Ally October 4, 2013, 11:54 am

After searching all over finally found something that worked really well….!! thanks a lot

ag October 11, 2013, 4:31 pm

Wonderful Advice! Finally transferred the contacts to Excel!!! Thank YOU so much!!!

vinoth November 25, 2013, 9:50 pm

great job, success… thnx…. thnx…..thnx…… love u

Nakul January 20, 2014, 3:07 pm

thank youuuuuu sooo much
its really work

Moe February 1, 2014, 3:21 am

Great Job. After many days and many ways finally I found right solution. Thanks

Liz May 24, 2014, 2:02 am

It worked great until I got to the type Windows+r and then nothing – no run window. Where do you need to type this?

TrickyWays May 26, 2014, 1:31 am

Windows+R keys combination works on all Windows versions to open Run window. Make sure your are pressing Windows key, a key with windows logo on it.

bled May 27, 2014, 8:40 pm

thanks, it helped.

Pradeep Verma July 4, 2014, 10:25 pm

Thanks a ton

SK July 29, 2014, 8:56 pm

its very helpful,thanks buddy

devashish August 1, 2014, 8:41 am

it isnt working for iphone 4s running on iOS 7 the csv file is showing only the top fields ie first name last name etc and no numbers and names are visible please help asap is it something to do with my internal setting of phone?

Dipes August 23, 2014, 11:13 pm

Great Help! It worked like every word you mentioned. Thanks!

LynCat September 12, 2014, 8:06 am

Hello, this works, however, I noticed not all my contacts were copied. Any idea how to get all my contacts from my iphone? thanks!

Coeded_One September 24, 2014, 12:06 am

Awesome! Was trying to find some rubbish freeware to do it, all the while it was literally on my fingertips! 🙂 Cheers!

Mozekial October 16, 2014, 1:45 am

I followed these instructions step by step and it even said that files have been exported to the selected location, but there is nothing there! Please help!!

Sohail December 1, 2014, 6:04 pm

Thanks its really works.

🙂 Thumbs UP.

chirag February 16, 2015, 12:14 am

when i am opening wab only 8 contacts are coming and ihave like 400-500 contacts …. what to do please help !!

Chris Smith February 20, 2015, 1:26 pm

Awesome thank you… one important detail that found me out, don’t forget to scroll down and press ‘apply’ when you change to windows contacts.

Rob June 4, 2015, 2:59 pm

Thank you thank you thank you
This actually works

Cgvmellii June 26, 2015, 1:45 pm

You can try these steps :
Turn on iTunes
Choose your iphone devices.
Find iCloud from itunes
Turn on iCloud
Sync phone
iTunes will sync all iCloud contacts with contact to windows
After sync finishes, turn on iCloud contacts on phone and merge contacts

Rick July 12, 2015, 12:40 am

Thank you for the tutorial on this!

Akash Singh September 6, 2015, 7:39 pm

Absolutely what one requires! No beating around the bush kike other websites and answers like install xyz app, just the right info.

Wendy November 5, 2015, 9:54 am

Thank you!!!!!!
I can’t tell you how happy I am that you supplied this information and that it worked!
I burst into tears earlier because I feared that I had lost my contacts forever, since my iPhone 3 has a white screen and is unusable. To add to the stress I bought an iPhone 5 and went to get a new Sim card. The company cut the card down to fit the iPhone 5 even though I mentioned that I did think it was compatible. The iPhone 5 still does not see the Sim so I was scared that the card was damaged by cutting it and all of my contacts were gone. But I was able to put it back into the iPhone 3 with the new Sim shell they were nice enough to supply. After recharging the phone I wiped away the tears and found your article. After connecting it to iTunes I was able to “merge” the contacts and then I followed your instructions so I am now so Happy to have them back.!

Randy December 9, 2015, 6:19 am

Sorry, this does not export anything but contents of Windows Contacts. I have contacts entered directly on my iPhone that are not in windows contacts, and iTunes Sync only brings contacts from windows contacts and merges with contacts already on my iPhone.

HOW do I export contacts from my iPhone???

jibby December 22, 2015, 10:54 am

When I plug in my iphone and go to the info tab on itunes(, it does not offer me the option you describe. Just tells me my contacts are being synced “over the air” from icloud, and that I can change my “over the air” settings on my iphone, but I can’t find anything on the iphone that would allow me to sync with windows on my pc.

Ranil June 21, 2016, 9:49 am

You jst need to change contacts back up setting in iPnone as not to back to icloud. It means you need to switch off icloud backup for the contact. After that you will find that option. Have a good day. Thanks for the sharing “TrickWays”. I had lot of trouble to back this thing. finally I’ve done my contacts back on my iPhone thanks to you.

Blinka February 8, 2017, 3:39 pm

It is way way simpler, fast and easy to:
Acess iCloud from your browser in PC, Contacts, CTRL + A to select all, Click on the gear and Export vCard.

ganesh October 11, 2017, 12:54 am

I transferred the contacts within 5 minute to the new phone. I was trying many methods for 4 hours. Every time Itunes showed some error like account etc. Thank You Very much

Scott C October 27, 2017, 6:55 pm

Does not work! Don’t have the option to sync with windows contacts in V12.7.

Leave a Comment

Join Our Subscribers

Receive the latest how-to guides, news, and updates from our team.

You have Successfully Subscribed!