Home > Shopify Tutorials > Import Existing Customers

How to Import Existing Customers Using the Customer CSV on Shopify

Last updated: September 01, 2024
Written and researched by experts at AvadaLearn more about our methodology

By Sam Nguyen

CEO Avada Commerce

With Shopify, you are able to import existing customers information by using customer CSV file. In computing, CSV stands for Comma-separated Values. The CSV file is a delimited text file that allows data to be saved in a table-structured format. Each line is a data record in which each value is separated by commas.

how import existing customers using customer csv shopify

In order to import your database from other platforms like Google Sheet or Microsoft Excel to Shopify admin account, you need to export it to .csv format first. Currently, Shopify only supports UTF-8 encoding. Therefore, in order to avoid some incorrect characters appeared in your data from transporting between platforms, we suggest you should remember to transform your data to the proper format (.csv with UTF-8 encoding) before importing to Shopify.

how import existing customers using customer csv shopify

You can refer Shopify’s template of customer CSV file in this link.

How to import existing customers using the customer CSV

Step 1: Go to Customers

After logging in and accessing Shopify admin interface, take a look at the menu list on the left side of the screen. At there, you will have to click Customers.

Step 2: Click Import customers

By clicking Customers, a section will appear with a list of your customers. In this section, you have to click on Import customers line at the top left corner of the list, beneath the Customers title.

how import existing customers using customer csv shopify

Step 3: Upload your customer CSV file

The Import customers by CSV window will appear right after. In the window, click Choose File to browse the CSV file in your device. If you want to update new information for existing customers, you can put a tick to Overwrite existing customers that have the same email or phone.

how import existing customers using customer csv shopify

Step 4: Confirm your import

After uploading the CSV file from your device, please click on Import customers button to confirm your sequence.

And there we go, customers’ information has been updated successfully!

Summary

The customer CSV file seems to be complicated at the first look. However, once you get used to the format, it will become very handy in the future. By using CSV file, you are not only able to upload, update customers’ information, but this format also works with data of orders, products, inventory, etc.

Related Posts:


Sam Nguyen is the CEO and founder of Avada Commerce, an e-commerce solution provider headquartered in Singapore. He is an expert on the Shopify e-commerce platform for online stores and retail point-of-sale systems. Sam loves talking about e-commerce and he aims to help over a million online businesses grow and thrive.

People also searched for