Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Import / Export Customers Data
Customers Import/Export

Import / Export Customers Data

How to import and export customers in bulk with CSV and XLSX files.
6 min read Updated 14 October 2026 Applies to Migrato on all plans

Migrato allows you to import and export Shopify customers data using CSV or XLSX files. You can select the customers fields you need, export existing customers information, prepare customers data for import, and use filters to export only the customers that match specific conditions.

You can use customers import/export to bulk manage, update, migrate, and maintain customers data without having to process customers individually through Shopify Admin.

Migrato also supports importing customers data from a publicly accessible file URL, making it possible to work with customers files hosted on external systems.

Customers Import Video Demonstration
Customers Import Video Demonstration
★
Before importing or exporting customers

We recommend reviewing the Customers Template Documentation and downloading the Customers Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.

Import Customers

Migrato allows you to bulk import Shopify customer data using CSV or XLSX files.

You can upload a customer file directly to Migrato or provide a publicly accessible URL to the file.

Step 1: Open Customer Import

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Import section.
  3. Select Customers as the entity you want to import.
  4. Add the customer file you want to import.
Customer Import
Customer Import

Step 2: Upload or Provide the Customer File

Migrato provides two ways to provide the customer file.

Option 1: Upload a File

Upload or drag and drop your prepared customer file into the upload area.

Migrato supports:

  • CSV
  • XLSX
Upload Customer File
Upload Customer File

Option 2: Import from a Public URL

Instead of uploading the file manually, you can provide the full publicly accessible URL of the customer file.

For example:

Example
https://example.com/customers.csv

Enter the URL and select Upload from URL.

Import Customers from URL
Import Customers from URL
i
Note

The file URL must be accessible to Migrato. Make sure the file does not require authentication or a login to access it.

Step 3: Review the Import Details

After the file is uploaded or retrieved from the provided URL, Migrato creates an import job and displays the available import details.

The import details can include:

  • Import ID
  • Import state
  • File format
  • Selected entity
  • Uploaded file
  • Import information
Customer Import Details
Customer Import Details

Review the displayed information before continuing.

Step 4: Review the Customer Sheet

Migrato identifies the customer data contained in the uploaded file and displays it under the Sheets section.

Review the detected customer sheet before selecting the import operation.

Customer Import Sheet
Customer Import Sheet

Step 5: Select an Import Operation

Migrato allows you to select the operation to perform on the customer data.

Depending on the supported customer operations, the available options can include:

  • Merge – Updates matching customers and creates new customers.
  • Create only – Creates new customers and skips customers that already exist.
  • Update only – Updates existing customers and skips records that cannot be matched.
  • Replace – Replaces the matching customer data with the imported data.
  • Delete – Deletes matching customer records where supported.
Customer Import Operations
Customer Import Operations

The selected operation determines how Migrato handles existing and new customer records.

!
Important

Carefully review the selected operation before starting an import, particularly when using Replace or Delete.

Step 6: Configure Import Options

Open the Options section to configure the additional settings available for the customer import.

Depending on the Migrato customer import configuration, available options may include scheduling and result-file settings.

Customer Import Options
Customer Import Options

Step 7: Schedule the Customer Import

Migrato can schedule an import job when scheduling is enabled.

You can configure options such as:

  • Schedule date
  • Schedule time
  • Repeat interval
  • Number of repetitions or run until cancelled

Scheduled imports can be useful when customer information needs to be repeatedly synchronized from an external source.

Schedule Customer Import
Schedule Customer Import

Step 8: Start the Customer Import

After reviewing the file and selecting the required operation:

  1. Review the import details.
  2. Confirm the selected operation.
  3. Review the available options.
  4. Click Import.
Import Customers Button
Import Customers Button

Migrato will begin processing the customer import.

Step 9: Monitor the Import

Migrato processes the customer import as a job and displays its current processing status.

Customer Import in Progress
Customer Import in Progress

Use the job information to monitor the import while it is being processed.

Step 10: Review Import Results

After processing is completed, review the import results.

The result information can include:

  • Import status
  • Total records
  • Successfully processed records
  • Failed records
  • Skipped records
  • Processing duration
  • Error information
Customer Import Results
Customer Import Results

If any customer records fail, review the reported errors, correct the source file where required, and run the import again.

Export Customers

Migrato allows you to export Shopify customer data into a CSV or XLSX file.

Customer exports can be useful for:

  • Customer data analysis
  • Reporting
  • Data backup
  • Store migration
  • Customer data management
  • External system integration
  • Record keeping

Step 1: Open Customer Export

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Export section.
  3. Select Customers.
Select Customers for Export
Select Customers for Export

Step 2: Select Customer Fields

Select the customer fields you want to include in the export.

Customer information is organized into different field groups, including:

  • Basic Columns
  • First and Last Order
  • Addresses
  • Activation URLs
  • Metafields
Customer Export Fields
Customer Export Fields

Select only the fields required for your export to keep the resulting file focused and easier to manage.

Step 3: Apply Customer Filters

If you need to export only specific customers, use the Filters section to narrow down the export.

Migrato supports filters based on fields such as:

  • Customer ID
  • Email
  • Created At
  • Updated At
  • Tags
  • Address: Country
  • Email Marketing: Status
  • Tax Exempt
Customer Export Filters
Customer Export Filters

For complete information about available filters and conditions, see 7.3 Filter Customers.

Step 4: Start the Export

After selecting the required customer fields and filters:

  1. Review the selected fields.
  2. Review the applied filters.
  3. Confirm the export settings.
  4. Start the export.
Start Customer Export
Start Customer Export

Migrato processes the selected customer data and creates the export file.

Step 5: Review the Export Result

After the export is completed, Migrato displays the export result.

The result may include information such as:

  • Export status
  • Exported file name
  • File format
  • Number of records exported
  • Processing duration
  • Selected customer fields
  • Applied filters
Customer Export Completed
Customer Export Completed

You can download the generated CSV/XLSX file from the completed export screen.

Supported Customer Data

Migrato's Customer import/export functionality supports the following customer data groups and fields.

Group Number of Columns Description
Basic Columns 24 Contains the primary customer information, marketing preferences, account information, tags, order totals, and other customer attributes.
First and Last Order 8 Contains information about the customer's first and last orders. These fields are available for export.
Addresses 16 Contains customer address information, including name, company, address, country, province, ZIP code, and default address status.
Activation URLs 1 Contains the customer account activation URL.
Metafields 1 Contains supported customer metafield information.
Total 50 Total supported Customer template columns.

Ready to run this on your own store?

Migrato's free plan handles 25 items per job - enough to follow any page in these docs end to end before you pay anything.

Free plan forever No credit card 2-minute setup Uninstall anytime