
{"id":3659,"date":"2019-06-18T12:23:30","date_gmt":"2019-06-18T12:23:30","guid":{"rendered":"https:\/\/www.kerneldatarecovery.com\/blog\/?p=3659"},"modified":"2021-03-10T11:06:00","modified_gmt":"2021-03-10T11:06:00","slug":"export-outlook-contacts-to-excel-2016-2013","status":"publish","type":"post","link":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/","title":{"rendered":"Export Outlook Contacts to Excel Sheet"},"content":{"rendered":"<p>Contacts in MS Outlook are very important for us, and they make our Outlook experience even better. It is important to keep them updated, well maintained, and away from any sort of corruption. There are many occasions when you would want to export your MS Outlook contacts to Excel, for example, to maintain a detailed and well-described sheet for future use. So, this blog is going to help you with the whole manual process you need to go through to do so. Let\u2019s get started:<\/p>\n<ol>\n<li>Start with opening the MS Outlook and click on the <strong>File<\/strong> button.<\/li>\n<li>Select <strong>Open &amp; Export<\/strong> category and click on <strong>Import\/Export<\/strong>.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3660\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E1.png\" alt=\"click on Import\/Export\" width=\"670\" height=\"431\" srcset=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E1.png 670w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E1-300x193.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/li>\n<li>Here, select <strong>Export to a File<\/strong> and click on <strong>Next<\/strong>.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3661\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E2.png\" alt=\"click on Next.\" width=\"451\" height=\"344\" srcset=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E2.png 451w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E2-300x229.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/li>\n<li>In the next step, select the option \u2018<strong>Comma Separated Values<\/strong>\u2019 and click on <strong>Next<\/strong> to proceed.<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3662\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E3.png\" alt=\"click on Next to proceed\" width=\"451\" height=\"344\" srcset=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E3.png 451w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E3-300x229.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/li>\n<li>Select the Contact folder (from which you want to Export contacts) from the list.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3663\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E4.png\" alt=\"Select the Contact folder\" width=\"451\" height=\"344\" srcset=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E4.png 451w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E4-300x229.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/li>\n<li>Provide a destination and name to the CSV file. Click on <strong>Next<\/strong> to proceed.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3664\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E5.png\" alt=\"Click on Next to proceed.\" width=\"451\" height=\"344\" srcset=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E5.png 451w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E5-300x229.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/li>\n<li>Select <strong>Export \u201cEmail messages\u201d from folder: Contacts<\/strong>. Click on <strong>Finish<\/strong> to proceed.<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3665\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E6.png\" alt=\"Click on Finish to proceed\" width=\"451\" height=\"344\" srcset=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E6.png 451w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/E6-300x229.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/li>\n<li>After the export, you can open the newly created CSV in any version of MS Excel. You can even change its extension to make it an Excel file.<img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-3669\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/CSV-FILE.png\" alt=\"Click on Finish to proceed\" width=\"755\" height=\"566\" srcset=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/CSV-FILE.png 755w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/CSV-FILE-300x225.png 300w, https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/CSV-FILE-320x240.png 320w\" sizes=\"(max-width: 755px) 100vw, 755px\" \/><\/li>\n<\/ol>\n<p>So, this how you can export contacts from MS Outlook to Excel. The process which we followed here was quite easy to perform; all you need to have is MS Outlook and follow these simple above-mentioned steps.<\/p>\n<h4>How to export contacts from corrupt PST files?<\/h4>\n<p>While performing the export, if you cannot access the contacts of a particular PST, this could be due to the corruption in PST. If there is a corruption in PST, then you cannot proceed with adding contacts. So, to add contacts from such a PST, you first need to fix it. The best way to fix a corrupt PST file is to fix it with an automated tool like <a href=\"https:\/\/www.kerneldatarecovery.com\/pst-recovery.html\">Outlook PST Recovery<\/a>.<\/p>\n<h4>Outlook PST Recovery<\/h4>\n<p>It is a PST repair tool, designed to repair, restore and recover damaged, broken or corrupt PST files. This tool is capable of repairing a file of any size, no matter small or large, and any number of files in one cycle. Apart from this the tool can be used if you are facing error notifications like, \u2018<a href=\"https:\/\/www.kerneldatarecovery.com\/blog\/how-to-resolve-outlook-error-code-20\/\">Outlook is unable to connect to the proxy server (error code 20)<\/a>,\u2019 \u2018<a href=\"https:\/\/www.kerneldatarecovery.com\/blog\/how-to-fix-microsoft-outlook-has-encountered-a-problem\/\">Microsoft Office Outlook has Encountered a Problem<\/a> and Needs to Close,\u2019 \u2018the file. The most amazing feature of the tool is that you can save a recovered PST in not just PST format, but in many other formats also, like DBX, MBOX, MSG, EML, TXT, RTF, HTML, etc. And not only this, but you can also migrate or save files to other email clients and servers. To know more about the tool, you can try its trial version, which is totally free and equipped with all features available in the full version.<\/p>\n<p align=\"center\"><a class=\"dl\" href=\"https:\/\/www.kerneldatarecovery.com\/dl\/dl.php?id=75\" onclick=\"dataLayer.push({'event': 'TrackEvent', 'eventCategory': 'Download', 'eventAction': 'PSTRecovery', 'eventLabel': 'BlogDLid=75'});\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-1659 noshadow\" src=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2018\/06\/dl-btn-new.png\" alt=\"Download Now\" width=\"160\" height=\"49\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contacts in MS Outlook are very important for us, and they make our Outlook experience even better. It is important to keep them updated, well maintained, and away from any sort of corruption. There are many occasions when you would want to export your MS Outlook contacts to Excel, for example, to maintain a detailed [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":3670,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_stopmodifiedupdate":true,"_modified_date":""},"categories":[3],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.10 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Export Outlook Contacts to Excel Sheet<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export Outlook Contacts to Excel Sheet\" \/>\n<meta property=\"og:description\" content=\"Contacts in MS Outlook are very important for us, and they make our Outlook experience even better. It is important to keep them updated, well maintained, and away from any sort of corruption. There are many occasions when you would want to export your MS Outlook contacts to Excel, for example, to maintain a detailed [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/\" \/>\n<meta property=\"og:site_name\" content=\"Data Recovery Blog - KDR Tools\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-18T12:23:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-10T11:06:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/export-outlook-contacts-to-excel-2016-2013.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"739\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Manisha Rawat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Manisha Rawat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Export Outlook Contacts to Excel Sheet","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/","og_locale":"en_US","og_type":"article","og_title":"Export Outlook Contacts to Excel Sheet","og_description":"Contacts in MS Outlook are very important for us, and they make our Outlook experience even better. It is important to keep them updated, well maintained, and away from any sort of corruption. There are many occasions when you would want to export your MS Outlook contacts to Excel, for example, to maintain a detailed [&hellip;]","og_url":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/","og_site_name":"Data Recovery Blog - KDR Tools","article_published_time":"2019-06-18T12:23:30+00:00","article_modified_time":"2021-03-10T11:06:00+00:00","og_image":[{"width":1600,"height":739,"url":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/06\/export-outlook-contacts-to-excel-2016-2013.jpg","type":"image\/jpeg"}],"author":"Manisha Rawat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Manisha Rawat","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/#article","isPartOf":{"@id":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/"},"author":{"name":"Manisha Rawat","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#\/schema\/person\/36178d8a894c4f5b68ce416088beba49"},"headline":"Export Outlook Contacts to Excel Sheet","datePublished":"2019-06-18T12:23:30+00:00","dateModified":"2021-03-10T11:06:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/"},"wordCount":488,"commentCount":0,"publisher":{"@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#organization"},"articleSection":["Email Conversion"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/","url":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/","name":"Export Outlook Contacts to Excel Sheet","isPartOf":{"@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#website"},"datePublished":"2019-06-18T12:23:30+00:00","dateModified":"2021-03-10T11:06:00+00:00","breadcrumb":{"@id":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/export-outlook-contacts-to-excel-2016-2013\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.kerneldatarecovery.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Export Outlook Contacts to Excel Sheet"}]},{"@type":"WebSite","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#website","url":"https:\/\/www.kerneldatarecovery.com\/blog\/","name":"Data Recovery Blog - KDR Tools","description":"Data Recovery Blog - KDR Tools","publisher":{"@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.kerneldatarecovery.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#organization","name":"Data Recovery Blog - KDR Tools","url":"https:\/\/www.kerneldatarecovery.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/04\/logo.png","contentUrl":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2019\/04\/logo.png","width":161,"height":47,"caption":"Data Recovery Blog - KDR Tools"},"image":{"@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#\/schema\/person\/36178d8a894c4f5b68ce416088beba49","name":"Manisha Rawat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kerneldatarecovery.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/11\/Manisha.jpg","contentUrl":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-content\/uploads\/2021\/11\/Manisha.jpg","caption":"Manisha Rawat"},"url":"https:\/\/www.kerneldatarecovery.com\/blog\/author\/manisharawat\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/posts\/3659"}],"collection":[{"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/comments?post=3659"}],"version-history":[{"count":13,"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/posts\/3659\/revisions"}],"predecessor-version":[{"id":8385,"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/posts\/3659\/revisions\/8385"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/media\/3670"}],"wp:attachment":[{"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/media?parent=3659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/categories?post=3659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kerneldatarecovery.com\/blog\/wp-json\/wp\/v2\/tags?post=3659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}