>How to Import and Export Customer Data in Magento 2

How to Import and Export Customer Data in Magento 2

Manually creating a new customer in admin takes too much time, especially when you have to finish adding a large number of customers. This blog will instruct you to import and export customer data and speed up the process using CSV file.

Please note that to import customer file successfully, you need to use the right CSV file structure so let’s go through the tutorial to export file first.

How to Export Customer Data

Go to System ⇒ Export ⇒ Export Settings.

How to Export Customer Data

Entity Type: Choose Customers Main File.

Export File Format: Choose CSV.

To exclude any information from the file, tick the checkbox of attribute below. But you should keep all the fields to preserve the structure of the CSV file.

Note: you can filter the information to export, such as gender, group, age (date of birth)…

Then click the Continue button.

Export Customer Data successfully

How to Import Customer Data

Using the export file, you can now fill it with your data and save the file.

Go to System ⇒ Import. 

How to Import Customer Data

Entity Type: Choose Customers Main File.

Import Behavior: Choose Add/Update Complex Data.

Then Select a file to import and click Check Data button.

Here is the tutorial video on How to import and export customer in Magento 2 for you:

 

I hope that the tutorial is helpful to you. Please stay tuned for other blogs at BSSCommerce.

Other blogs within the series of Customer and Customer Group knowledge base you might be interested:

How to Manage Customer in Magento 2

A Brief Guide on Customer Configuration in Magento 2

magento 2 hide price call for price extension

MAGENTO 1 EXTENSION | MAGENTO 2 EXTENSION | WEBSITE DEVELOPMENT SERVICE

Besides, to import data into Magento 2 websites, there are some suggestions for you to take into consideration: