How to Import and Export Customers in Magento 2

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 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 Customers in Magento 2:

First, let us understand how to export customers.

Method to Export Customers 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 Continue
7. Here is CSV file having customer data.

Import Customers in Magento 2:

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 File
4. Select the Add/Update Complex Data in Import Behavior
5. Go to Choose File in Select File to Import
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 Comments section below.

I would be happy to solve your queries.

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

Thank you.