Magento 2 Import & Export Customers: The Ultimate Guide

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
To export customers in Magento 2
- Step 1: Access to Configuration
- Step 2: Download Customer Mail File
- Step 3: Enter your file with your data
- Step 4: Save to complete
Step 1: Access to Configuration
- From to
Admin sidebar
, selectSystem
then clickExport
Step 2: Download Customer Mail File
- In the Entity Type field, select Customers Mail File
- 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:
- 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 chooseText to Columns
. Next, clickDelimited
>Next
. After that, choose theComma
box and don’t choose other boxes. Finally, clickNext
again andDone
.
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.
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 theService
button, chooseWeb document settings
and findCoding
section in there. After that, chooseUnicode(UTF-8)
then clickOK
andSave
your file
When exporting file successfully, we proceed to importing the file
To import customers in Magento 2
Step 1: Access to Configuration
- From to
Admin sidebar
, selectSystem
then clickImport
Step 2: Import the file
- In the Entity Type field, choose type of data that you would like to import.
- 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.
- Choose
- In the File to Import field, select the file to import from your computer.
Step 3: Save to complete
Click Check Data
to complete.
THINGS TO REMEMBER:
- You have to export a file and fill it before import it in Magento.
- Your file must be smaller than 8M
Related posts:
Recent Tutorials

October 28, 2019
Magento 2 get customer address custom attribute value
June 05, 2019
How to Install Magento Extension via Composer
Comments for Export And Import Customers
People also searched for
- magento 2 import customers
- magento 2 customer import
- magento 2 export customers
- magento export customers
- magento 2 import customers programmatically
- magento 2 import customers csv
- magento 2 import customers from magento 1
- magento 2 import customers with password
- magento 2 customer import sample csv
- magento 2 customers import
- magento import customers
- magento customer export
- magento customer import sample csv
- magento clients
- magento import database
- magento 2 customers
- magento 2 import database
- customer data magento 2
Subscribe
Stay in the know
Get special offers on the latest news from Mageplaza.
Earn $10 in reward now!
Earn $10 in reward now!