{"id":1355,"date":"2020-11-09T16:07:21","date_gmt":"2020-11-09T16:07:21","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/2020\/11\/09\/import-and-export-customers-in-magento-2\/"},"modified":"2025-06-16T11:29:22","modified_gmt":"2025-06-16T05:59:22","slug":"import-and-export-customers-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/import-and-export-customers-in-magento-2\/","title":{"rendered":"How to Import and Export Customers in Magento 2"},"content":{"rendered":"\n

Customer data management is crucial for marketing, administration, as well as order management in a business.<\/p>\n\n\n\n

For instance, if you are shifting business from offline to online and you have collected all the details of your regular customers, you can simply import the CSV file having a list of customers to Magento 2 store.<\/p>\n\n\n\n

Moreover, if you wish to create an excel file that includes the list of customers, you can simply export the file.<\/p>\n\n\n\n

The default\u00a0Magento 2<\/a>\u00a0allows the merchant to import and export customers. It also allows to extract Postback Data in Magento 2<\/a><\/p>\n\n\n\n

Steps to Import and Export Customers in Magento 2:<\/h2>\n\n\n\n

First, let us understand how to export customers.<\/p>\n\n\n\n

Method to Export Customers in Magento 2:<\/h3>\n\n\n
\n
\"How<\/figure>\n<\/div>\n\n\n

1. Log in to Magento 2 admin panel<\/p>\n\n\n\n

2. Navigate to System > Data Transfer > Export<\/strong><\/p>\n\n\n\n

3. Under Export Settings<\/strong>, select Customers Main File<\/strong> in Entity Type<\/strong><\/p>\n\n\n\n

4. The Export File Format is CSV by default<\/p>\n\n\n\n

5. In Entity Attribute<\/strong>, select choose the attribute that you want to exclude from CSV file<\/p>\n\n\n\n

6. Click Continue<\/strong><\/p>\n\n\n\n

\"How<\/figure>\n\n\n\n

7. Here is CSV file having customer data.<\/p>\n\n\n\n

Import Customers in Magento 2:<\/h3>\n\n\n\n
\"How<\/figure>\n\n\n\n

Now, let us add customer data in the CSV list and import the file.<\/p>\n\n\n\n

1. Log in to Magento 2 admin panel<\/p>\n\n\n\n

2. Navigate to System > Data Transfer > Import<\/strong><\/p>\n\n\n\n

3. In Entity Type<\/strong>, select Customer Main File<\/strong><\/p>\n\n\n

\n
\"How<\/figure>\n<\/div>\n\n\n

4. Select the Add\/Update Complex Data<\/strong> in Import Behavior<\/strong><\/p>\n\n\n\n

5. Go to Choose File<\/strong> in Select File to Import<\/strong><\/p>\n\n\n\n

\"How<\/figure>\n\n\n\n

6. Click Check Data<\/strong><\/p>\n\n\n\n

That\u2019s it. The customer data is imported. Apart from this Magento 2 also empowers businesses with robust tools providing facilities of importing and exporting orders in Magetno 2<\/a>.<\/p>\n\n\n\n

Please do consider sharing this blog with Magento Community via social media.<\/p>\n\n\n\n

Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"

Customer data management is crucial for marketing, administration, as well as order management in a business. For instance, if you are shifting business from offline…<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1355","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1355"}],"version-history":[{"count":3,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1355\/revisions"}],"predecessor-version":[{"id":16796,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1355\/revisions\/16796"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}