{"id":2088,"date":"2010-03-27T02:18:59","date_gmt":"2010-03-26T20:48:59","guid":{"rendered":"http:\/\/windowsvj.com\/wpblog\/2010\/03\/import-phone-contacts-from-excel-to-office-outlook-2010\/"},"modified":"2010-03-27T02:18:59","modified_gmt":"2010-03-26T20:48:59","slug":"import-phone-contacts-from-excel-to-office-outlook-2010","status":"publish","type":"post","link":"http:\/\/windowsvj.com\/wpblog\/2010\/03\/import-phone-contacts-from-excel-to-office-outlook-2010\/","title":{"rendered":"Import Phone Contacts from Excel to Office Outlook 2010"},"content":{"rendered":"<p>Many of Phone manufacturers provides an option to save mobile phone contacts in a CSV (comma separated value) format or an excel sheet. If you are moving to a Windows phone you may have all your contacts in outlook. So here is a guide how to convert your mobile phone contacts from an excel and finally move them to Outlook.<\/p>\n<p>1. Open the Excel File and save it as a CSV file. If it is CSV file already you may move to step 2.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/1.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"1\" border=\"0\" alt=\"1\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/1_thumb.png\" width=\"548\" height=\"435\" \/><\/a><\/p>\n<p>2. Now that you have converted the file in CSV , move to next part and open Outlook.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/2.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"2\" border=\"0\" alt=\"2\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/2_thumb.png\" width=\"665\" height=\"401\" \/><\/a><\/p>\n<p>3. To import contacts from the CSV file go to File menu and select open submenu in the backstage view to bring options to \u201copen calendar\u201d \u201copen outlook data file \u201c and \u201cImport\u201d. Select Import option here. This option has gone in the backstage view as compared with Office 2010.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/3.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"3\" border=\"0\" alt=\"3\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/3_thumb.png\" width=\"726\" height=\"371\" \/><\/a><\/p>\n<p>4. This will pop up Import &amp; Export wizard. Select the option \u201cImport from another program or file\u201d<\/p>\n<p align=\"center\"><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/4.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px 20px; display: inline; border-top: 0px; border-right: 0px\" title=\"4\" border=\"0\" alt=\"4\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/4_thumb.png\" width=\"519\" height=\"399\" \/><\/a><\/p>\n<p align=\"center\">&#160;<\/p>\n<p>5. Select file type to import from as \u201cComma Separated Values (Windows)\u201d.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/5.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"5\" border=\"0\" alt=\"5\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/5_thumb.png\" width=\"547\" height=\"418\" \/><\/a><\/p>\n<p>6. At the next screen browse the CSV file we created in the first step and let the option in the radio box \u201cAllow duplicates to be created\u201d selected.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/6.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"6\" border=\"0\" alt=\"6\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/6_thumb.png\" width=\"557\" height=\"428\" \/><\/a><\/p>\n<p>7. Destination folder where all imported valued would be saved can be selected on next screen, preferably the Contacts folder.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/7.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"7\" border=\"0\" alt=\"7\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/7_thumb.png\" width=\"566\" height=\"433\" \/><\/a><\/p>\n<p>8. Next screen would list the actions to be performed. Here you need to Map Custom fields if you wish to map a particular columns of CSV into specific Titles in outlook.<a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/8.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"8\" border=\"0\" alt=\"8\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/8_thumb.png\" width=\"548\" height=\"419\" \/><\/a><\/p>\n<p>9. Mapping of values from the CSV to the fields in Office Outlook can be done here. By default only Name mapping was done. And the CSV&#160; had 3 fields Name, mobile &amp; Home . To onclude other two you can drag and drop them next to a relevant field in the Office Outlook contacts.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/9.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"9\" border=\"0\" alt=\"9\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/9_thumb.png\" width=\"672\" height=\"488\" \/><\/a><\/p>\n<p>10. After Mapping custom fields, you may proceed further.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/10.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"10\" border=\"0\" alt=\"10\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/10_thumb.png\" width=\"509\" height=\"393\" \/><\/a><\/p>\n<p>11. Navigate to Contacts and you may find all of your contacts are imported to outlook. Here they can be sorted, edited, deleted etc.<\/p>\n<p><a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/11.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"11\" border=\"0\" alt=\"11\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/11_thumb.png\" width=\"598\" height=\"303\" \/><\/a><\/p>\n<p>    <\/p>\n<p>12. Finally, if you wish to have these contacts in your Windows Phone, simply connect your WinMo with your computer and Synchronize it. <\/p>\n<p> <a href=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/12.png\"><img loading=\"lazy\" decoding=\"async\" style=\"border-bottom: 0px; border-left: 0px; margin: 0px auto; display: block; float: none; border-top: 0px; border-right: 0px\" title=\"12\" border=\"0\" alt=\"12\" src=\"http:\/\/windowsvj.com\/wpblog\/wp-content\/uploads\/2010\/03\/12_thumb.png\" width=\"609\" height=\"460\" \/><\/a>  <\/p>\n<p>It took me 2-3 Hours to figure out the correct way to do this, but it just took 10 minutes to transfer all my Phone contacts in my Phone from Computer which were in some other format.<\/p>\n<p>Note : The following software products have been used while performing this Tutorial. <\/p>\n<p>Microsoft Office 2010 Excel Beta<\/p>\n<p>Microsoft Office 2010 Outlook Beta<\/p>\n<p>Windows Mobile Device center for Windows Mobile 6.1<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Many of Phone manufacturers provides an option to save mobile phone contacts in a CSV (comma separated value) format or an excel sheet. If you are moving to a Windows phone you may have all your contacts in outlook. So here is a guide how to convert your mobile phone [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27,8,170],"tags":[92,54,190,171],"class_list":["post-2088","post","type-post","status-publish","format-standard","hentry","category-office-2010","category-tips-n-trix","category-winmo","tag-excel","tag-office","tag-outlook","tag-windows-mobile-61"],"_links":{"self":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/2088","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/comments?post=2088"}],"version-history":[{"count":0,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/posts\/2088\/revisions"}],"wp:attachment":[{"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/media?parent=2088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/categories?post=2088"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/windowsvj.com\/wpblog\/wp-json\/wp\/v2\/tags?post=2088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}