That's it.Īfter those 7 steps, you can import your vCard contacts from Outlook 2010 to Excel worksheet. After that, drag the " E-mail Address", " Email Type" and " Email Display Name" and more content you want it to be listed in your excel and click " OK". Then, click " Clear Map" at the below screenshot to empty the content in the right panel. To solve this, you can go to " Export to a File" and click " Map Custom Fields…" and then finish. If you stop in this step, all the contacts field, the useless info will be all scanned out and you have to find the useful data out from the sea of different data.
And then choose the file to store it on your Windows Explorer.īefore you successfully save them on your computer, click " Browse" on the interface and their will pop up a Windows Explorer for you to save the. Choose " Contacts" as you want to import contacts to excel. Choose Contacts Folder to Save on PCĪfter that, you will be see all the folders stored under outlook. Note: In Outlook 2013, you are only provided " Comma Separated Values (Windows)" for option. Then, choose the file type, " Comma Separated Values(Windows)" to import. Go to " File" > " Options" > " Advanced" on Outlook 2010 as we mentioned above.Īfter the " Import and Export Wizard" screen pops up, you can choose the second option " Export to a file" and simply click " Next". Now let's start the easy process to import vCard contacts from Outlook 2010 to Excel worksheet. Choose " Import a VCARD file(.vcf)" as shown below and click " Next" to add vCard file to the Contacts folder.Īfter that, the vCard file will be named contacts.vcf and you can choose the path to save it on your computer. Today, I will show you the easy way to import vCard contacts from Outlook to Excel.įirstly, I will show you how to find the import/export option on different Outlook version.įor Outlook 2013, you can find it on " File" > " Open & Export" > " Import/Export"įor Outlook 2010, click " File" > " Options" > " Advanced" > " Export".įor Outlook 2007 and Outlook 2003, you can click " File" > " Import and Export".Īfter that, you will be shown the below " Import and Export Wizard".
There are lots of problems on forums asking the same question: They want to output their outlook contacts so as to save them for later use.
0 kommentar(er)
