{"id":8599,"date":"2019-12-03T09:52:10","date_gmt":"2019-12-03T04:22:10","guid":{"rendered":"https:\/\/www.hiddentechies.com\/blog\/?p=8599"},"modified":"2020-10-09T19:08:59","modified_gmt":"2020-10-09T13:38:59","slug":"magento-2-export-customer-address-csv","status":"publish","type":"post","link":"https:\/\/www.hiddentechies.com\/blog\/magento\/magento-2-export-customer-address-csv\/","title":{"rendered":"How to Export Customer Address to CSV in Magento 2"},"content":{"rendered":"<p>In this article we&#8217;ll show you, how to Export Customer Address to CSV in Magento 2. Follow this simple guideline&#8230;<\/p>\n<p><strong>Step 1: Get Started<\/strong><\/p>\n<p>Login into Magento Admin Panel and from sidebar go to, System &gt; Data Transfer &gt; Export.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-8600\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-1-65-1024x480.png\" alt=\"How to Export Customer Address to CSV in Magento 2\" width=\"676\" height=\"317\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-1-65-1024x480.png 1024w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-1-65-300x141.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-1-65-768x360.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-1-65-800x375.png 800w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-1-65.png 1348w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/p>\n<p><strong>Step 2: Export Customer Address to CSV<\/strong><\/p>\n<p>Here in Export Settings, set Entity Type to Customer Address. Accept the default Export File Format of CSV. If you want to enclose any special characters that might be found in the data as an escape sequence, select the Fields Enclosure checkbox.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8601\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-2-63.png\" alt=\"How to Export Customer Address to CSV in Magento 2\" width=\"873\" height=\"245\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-2-63.png 873w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-2-63-300x84.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-2-63-768x216.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-2-63-800x225.png 800w\" sizes=\"(max-width: 873px) 100vw, 873px\" \/><\/p>\n<p>To omit an attribute from the export, select the Exclude checkbox at the beginning of the row. The column appears in the export file, but without any values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-8602\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-3-61-1024x308.png\" alt=\"How to Export Customer Address to CSV in Magento 2\" width=\"676\" height=\"203\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-3-61-1024x308.png 1024w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-3-61-300x90.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-3-61-768x231.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-3-61-800x241.png 800w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-3-61.png 1245w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/p>\n<p>Scroll down and click Continue in the lower-right corner of the page. Upon completion of the task, look for the file in the download location for your web browser.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-8603\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-4-56-1024x154.png\" alt=\"How to Export Customer Address to CSV in Magento 2\" width=\"676\" height=\"102\" srcset=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-4-56-1024x154.png 1024w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-4-56-300x45.png 300w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-4-56-768x115.png 768w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-4-56-800x120.png 800w, https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/2019\/11\/Step-4-56.png 1244w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/p>\n<p>Yeah Done! Let us know in the comment section below if you have any question. We are happy \ud83d\ude42 to help you!<\/p>\n<div class=\"angwp_12010 _ning_cont _ning_hidden _ning_outer _align_center responsive\" data-size=\"custom\" data-bid=\"12010\" data-aid=\"0\" style=\"max-width:800px; width:100%;height:inherit;\"><div class=\"_ning_label _left\" style=\"\"><\/div><div class=\"_ning_inner\" style=\"\"><a href=\"https:\/\/www.hiddentechies.com\/blog?_dnlink=12010&t=1779332732\" class=\"strack_cli _ning_link\" target=\"_blank\">&nbsp;<\/a><div class=\"_ning_elmt\"><img decoding=\"async\" src=\"https:\/\/www.hiddentechies.com\/blog\/wp-content\/uploads\/angwp\/items\/12010\/Banner-2.png\" \/><\/div><\/div><\/div><div class=\"clear\"><\/div>","protected":false},"excerpt":{"rendered":"<p>In this article we&#8217;ll show you, how to Export Customer Address to CSV in Magento 2. Follow this simple guideline&#8230; Step 1: Get Started Login into Magento Admin Panel and from sidebar go to, System &gt; Data Transfer &gt; Export. Step 2: Export Customer Address to CSV Here in Export Settings, set Entity Type to&#8230; <\/p>\n<div class=\"actions\"><a href=\"https:\/\/www.hiddentechies.com\/blog\/magento\/magento-2-export-customer-address-csv\/\">Continue Reading<\/a><\/div>\n","protected":false},"author":1,"featured_media":8660,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,181,59,2138],"tags":[729,9,10],"_links":{"self":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/8599"}],"collection":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/comments?post=8599"}],"version-history":[{"count":1,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/8599\/revisions"}],"predecessor-version":[{"id":8604,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/posts\/8599\/revisions\/8604"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media\/8660"}],"wp:attachment":[{"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/media?parent=8599"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/categories?post=8599"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hiddentechies.com\/blog\/wp-json\/wp\/v2\/tags?post=8599"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}