Magento 2 Import & Export Customers: The Ultimate Guide

Drive 20-40% of your revenue with
email, SMS marketing

If you have a customer list that you want to use in Magento 2, you can add them to your store automatically. This article will show you how to import new customers to your website by using CSV files.

Follow this guidances to complete tasks

Step 1: Access to Configuration

From to Admin sidebar, select System then click Export

Export

Step 2: Download Customer Mail File

In the Entity Type field, select Customers Mail File

Entity Tyle

You can choose the fields that you want to deport from the file by checking the box beside each field. You can also choose your parts according to other standards: date of birth, date of purchase and so on.
Then select Continue and save the file on your computer
After opening the file, the result is as follow:

Customers Mail File

In case the results are not in the usual format as above. You can set up by selecting the first column then click Data then choose Text to Columns. Next, click Delimited > Next. After that, choose the Comma box and don’t choose other boxes. Finally, click Next again and Done.

Step 3: Enter your file with your data

If you want to build accounts for your present clients at the website that you just built, you need to enter emails in the email column, and enter your website’s appellation in the website column.
These are obligatory fields and other fields depend on you to enter.

Customers Mail

Step 4: Save to complete

After your file is accomplished, remember to save it in Unicode(UTF-8). To work so in Excel, click Save As and in the Service button, choose Web document settings and find Coding section in there. After that, choose Unicode(UTF-8) then click OK and Save your file

When exporting file successfully, we proceed to importing the file

To import customers in Magento 2

Step 1: Access to Configuration
Step 2: Import the file
Step 3: Save the changes

Step 1: Access to Configuration

From to Admin sidebar, select System then click Import

Import

Step 2: Import the file

In the Entity Type field, choose type of data that you would like to import.

Choose type of data

In the Imports Behavior field:
- Choose Add/Update Complex Data if you would like to add new clients
- Choose Delete Entities if you would like to replace your customer database by another.
In the File to Import field, select the file to import from your computer.

Import file