+92-301-1000201 [email protected]
23 views

Having a list of customers plays huge importance for managing customers and for marketing purposes as well.

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.

Moreover, if you wish to create an excel file that includes the list of customers, you can simply export the file.

The default Magento 2 allows the merchant to import and export customers.

Steps to Import and Export Customer Data in Magento 2

First, let us understand how to export customers.

How to Export Customer Data in Magento 2

How to Import and Export Customer Data in Magento 2

  1. Log in to Magento 2 admin panel
  2. Navigate to System > Data Transfer > Export
  3. Under Export Settings, select Customers Main File in Entity Type
  4. The Export File Format is CSV by default
  5. In Entity Attribute, select choose the attribute that you want to exclude from CSV file
  6. Click ContinueHow to Import and Export Customer Data in Magento 2 - CSV file
  7. Here is CSV file having customer data.

How to Import Customer Data in Magento 2

How to Import and Export Customer Data in Magento 2 - CSV file

Now, let us add customer data in the CSV list and import the file.

  1. Log in to Magento 2 admin panel
  2. Navigate to System > Data Transfer > Import
  3. In Entity Type, select Customer Main FileHow to Import Customer Data in Magento 2
  4. Select the Add/Update Complex Data in Import Behavior
  5. Go to Choose File in Select File to ImportHow to Import Customer Data in Magento 2
  6. Click Check Data 

That’s it. The customer data is imported.

If you need more help regarding this blog, feel comfortable for asking in the Comment section below.

I would be happy to solve your queries.

Please do consider sharing this blog with Magento Community via social media.

Thank you.

Share This

Share this post with your friends!