How to download customers from Shopify

Follow the steps in

Part 1: Export customers as CSV
Part 2: Prepare the CSV File


Part 1: Export customers as CSV

  1. Click "Customers"
    Exporting Customer Data from Shopify - Step 1
  2. Click "Export"
    Exporting Customer Data from Shopify - Step 2
  3. Click "Export Customers"
    Exporting Customer Data from Shopify - Step 7

Part 2: Prepare the CSV file

  1. Open https://sheets.google.com
  2. Click "Blank spreadsheet"
    Importing CSV Data Into Google Sheets - Step 1 (1)
  3. Click "File"
    Importing CSV Data Into Google Sheets - Step 3
  4. Click "Import"
    Importing CSV Data Into Google Sheets - Step 4
  5. Click "Upload"
    Importing CSV Data Into Google Sheets - Step 5
  6. Click "Browse"
    Importing CSV Data Into Google Sheets - Step 6
  7. Select the file exported from Shopify and click "Import data"
    Importing CSV Data Into Google Sheets - Step 7
  8. Rename the "Email" column to "email"
    Importing CSV Data Into Google Sheets - Step 8
    Importing CSV Data Into Google Sheets - Step 9 (6)
  9. Delete all other columns.
    Importing CSV Data Into Google Sheets - Step 13 (1)
    Importing CSV Data Into Google Sheets - Step 17 (1)
  10. Click File > Download > Comma separated values (.csv)
    Importing CSV Data Into Google Sheets - Step 20
  11. Upload the file in ProfitMetrics > Customers