How to import and organize your customer list

Your email list is your most valuable marketing asset. But if it’s disorganized, outdated, or poorly structured, you’re leaving money on the table. A well-organized contact list lets you send targeted messages that get better results.

This guide walks you through everything you need to know about importing and organizing your customer list, from gathering contacts to creating useful segments.

How to import and organize your customer list

Before you import: Gather your contacts

Before importing anything, collect all your customer contact information from different sources. You might have customers in:

  • Spreadsheets and CSV files
  • Your e-commerce platform (Shopify, WooCommerce, etc.)
  • Your POS system
  • Previous email marketing tools
  • CRM software
  • Manual sign-up sheets or business cards
  • Social media followers who gave you their email

Important: Only import people who gave you permission to email them. Buying email lists is illegal in many countries and will damage your sender reputation. Never import contacts from sources where people didn’t opt in.

Preparing your contact file

Most email platforms, including Minutemailer, accept CSV (comma-separated values) files. Here’s how to prepare your file:

Required information

At minimum, your file needs:

  • Email address (required)
  • First name (highly recommended for personalization)

Optional but useful information

Include these fields if you have them:

  • Last name
  • Phone number
  • Company name
  • Location (city, country)
  • Customer type (new, returning, VIP)
  • Purchase history
  • Signup source
  • Interests or preferences

Clean your data first

Before importing, clean your list:

Remove duplicates: Having the same email twice causes problems. Most spreadsheet programs can find duplicates automatically.

Fix formatting: Make sure email addresses look correct (no spaces, proper @ symbol, valid domain).

Standardize data: Be consistent with capitalization. “New York,” “new york,” and “NEW YORK” should all match.

Remove invalid emails: Delete obviously fake emails like “test@test.com” or “noemail@none.com.”

Fill in missing names: If you don’t have names, leave the field blank rather than using “Friend” or “Customer.” Real names work better than placeholders.

Format your CSV file correctly

Your CSV file should have one row for each contact, with column headers in the first row.

Example format:

email,first_name,last_name,city,customer_type
sarah@example.com,Sarah,Johnson,Seattle,returning
michael@example.com,Michael,Chen,Portland,new
emma@example.com,Emma,Garcia,Vancouver,vip

Common formatting mistakes to avoid

Don’t use commas in your data: Since CSV uses commas to separate fields, commas in your data (like “Portland, OR”) can cause problems. Use semicolons instead or put the data in quotes.

Avoid special characters: Stick to standard letters, numbers, and basic punctuation.

Use UTF-8 encoding: This ensures special characters (like é, ñ, or ö) display correctly.

One email per row: Don’t put multiple emails in one cell.

Match date formats: If including dates, use a consistent format like YYYY-MM-DD.

Importing your list to Minutemailer

Once your CSV file is ready, importing is straightforward:

  1. Log in to your Minutemailer account
  2. Go to “Contacts” or “Subscribers”
  3. Click “Import Contacts”
  4. Upload your CSV file
  5. Map your columns to the correct fields
  6. Confirm the import

Mapping fields

When you import, you’ll need to tell Minutemailer which column in your file matches which field in their system. For example:

  • Your “email” column goes to “Email Address”
  • Your “first_name” column goes to “First Name”
  • Your “city” column goes to “City”

Most platforms auto-detect common field names, but always double-check the mapping before confirming.

Import settings

During import, you’ll typically choose:

What to do with duplicates: Usually best to skip duplicates rather than overwrite existing contacts (unless you’re specifically updating information).

Subscribe status: Choose whether imported contacts are automatically subscribed or need to confirm (more on this below).

Tags or segments: Add tags during import to identify where contacts came from.

This is critical: you must have permission to email people on your list.

Explicit opt-in

The safest approach. People actively signed up to receive your emails. This includes:

  • Website signup forms
  • In-store sign-ups where people entered their own email
  • Event registrations where email marketing was mentioned
  • Download gates where terms clearly stated email updates

You have an existing business relationship. This might include:

  • Recent customers (purchased in last 2 years)
  • Active clients or members
  • Business contacts you’ve emailed previously

Check your local laws. Europe’s GDPR is stricter than US CAN-SPAM, and Canada’s CASL has its own requirements.

When in doubt, get permission

If you’re unsure whether you can email someone, send a permission pass campaign first. Email once asking if they’d like to stay on your list. Only keep people who respond positively or click a confirmation link.

This cleans your list and ensures you’re only emailing engaged, interested people.

Organizing contacts with tags and custom fields

Raw imported contacts aren’t very useful until you organize them. Use tags and custom fields to add structure.

Tags

Tags are labels you add to contacts for organization. They’re flexible and you can add multiple tags to one contact.

Good tag examples:

  • Source: “website_signup,” “in_store,” “trade_show,” “referral”
  • Interests: “coffee,” “tea,” “equipment,” “recipes”
  • Customer stage: “prospect,” “customer,” “repeat_buyer,” “inactive”
  • Engagement: “highly_engaged,” “occasional_opener,” “rarely_clicks”
  • Location: “seattle,” “portland,” “vancouver”

Tags make it easy to send targeted emails. Want to email all Seattle customers who like coffee? Filter by those tags.

Custom fields

Custom fields store specific information about contacts. Unlike tags, each contact has only one value per field.

Useful custom fields:

  • Purchase frequency
  • Total spent
  • Last purchase date
  • Customer since date
  • Birthday or anniversary
  • Preferred contact method
  • VIP status
  • Account type

Custom fields enable powerful personalization. You can reference fields in your emails: “Happy birthday, Sarah!” or “You’ve been with us since 2019.”

Creating useful segments

Segments are filtered groups of contacts based on tags, custom fields, or behavior. They update automatically as contacts meet the criteria.

Basic segments to create

New subscribers: People who joined in the last 30 days. Send them a special welcome series.

Engaged subscribers: People who opened or clicked emails in the last 60 days. These are your most valuable contacts.

Inactive subscribers: Haven’t opened anything in 120+ days. Target them with win-back campaigns.

Recent customers: Purchased in the last 30 days. Perfect for follow-up, reviews, or related product suggestions.

VIP customers: Your best customers based on purchase frequency or total spend. Give them exclusive offers and early access.

Local subscribers: People in specific cities or regions. Send them info about local events, store hours, or region-specific offers.

Advanced segmentation strategies

Behavioral segments: Based on what people actually do, not just who they are.

  • Clicked specific links
  • Viewed specific products
  • Downloaded resources
  • Attended events

Predictive segments: Use purchase history to predict future behavior.

  • About to need a refill or replacement
  • Ready to upgrade
  • At risk of churning

Engagement scoring: Assign points for positive actions (opens, clicks, purchases) and create segments by score level.

Best practices for list organization

Use consistent naming conventions

Decide on a naming system and stick to it:

  • Tags: lowercase with underscores (“coffee_lover” not “Coffee Lover”)
  • Segments: descriptive names (“Active customers - Last 90 days”)
  • Custom fields: clear, obvious names (“Total_Purchase_Amount” not “TPA”)

Consistency makes everything easier to find and use.

Start simple, add complexity gradually

Don’t create 50 tags and 20 segments on day one. Start with:

  • 3-5 basic tags (source, customer type)
  • 1-2 custom fields (name, customer since)
  • 2-3 segments (engaged, inactive, recent customers)

Add more as you discover what you actually need.

Document your system

Keep a simple document explaining your tags, fields, and segments. What does “tag_a” mean? When someone should be in the “VIP” segment? Future you (and your team) will thank you.

Audit regularly

Every few months, review your organization system:

  • Are you using all these tags? Delete unused ones.
  • Do segment criteria still make sense?
  • Are there new segments you should create?
  • Is your data still clean and accurate?

Cleaning and maintaining your list

List hygiene isn’t a one-time thing. Regular maintenance keeps your list healthy.

Remove bounces

Hard bounces (email doesn’t exist) should be removed immediately. Most platforms do this automatically.

Soft bounces (temporary problems) can stay, but if an email soft bounces repeatedly, remove it.

Handle unsubscribes properly

When someone unsubscribes, remove them immediately. It’s not just polite, it’s legally required in most places.

Don’t take unsubscribes personally. A clean, engaged list performs better than a large, uninterested one.

Suppress complaints

If someone marks your email as spam, never email them again. Add them to your suppression list.

Re-engagement campaigns

Before removing inactive subscribers, try to win them back. Send a re-engagement campaign offering value or asking if they want to stay subscribed.

Remove anyone who doesn’t respond to the final re-engagement email.

Monitor engagement metrics

Watch these numbers:

  • Open rates (should be 15-25%+)
  • Click rates (should be 2-5%+)
  • Bounce rate (should be under 2%)
  • Complaint rate (should be under 0.1%)
  • Unsubscribe rate (should be under 0.5%)

If metrics decline, it’s time to clean your list or improve your emails.

Importing from specific platforms

Here’s how to export contacts from common platforms:

Shopify

  1. Go to Customers
  2. Click Export
  3. Choose “Current page” or “All customers”
  4. Select “Plain CSV file”
  5. Click Export Customers

WooCommerce

  1. Go to WooCommerce → Customers
  2. Click Export
  3. Choose which fields to include
  4. Generate CSV

MailChimp

  1. Go to Audience → All contacts
  2. Click the dropdown next to “Add contacts”
  3. Select “Export audience”
  4. Choose “Export as CSV”

Excel/Google Sheets

  1. Open your file
  2. Click File → Save As (or Download)
  3. Choose CSV format
  4. Save

Common importing mistakes and how to fix them

Mistake: Importing without permission

Fix: Only import people who explicitly opted in. When in doubt, send a permission pass campaign first.

Mistake: Not cleaning data first

Fix: Always review and clean your list before importing. Remove duplicates, fix formatting, delete invalid emails.

Mistake: Forgetting to tag imports

Fix: Always tag imported contacts with their source. You’ll want to know later where they came from.

Mistake: Ignoring duplicates

Fix: Configure your import to handle duplicates properly (usually skip them). Then manually review any duplicates that get flagged.

Mistake: Importing too much information

Fix: Start with just email and name. You can always add more fields later. Too much data upfront is overwhelming.

Mistake: Not testing the import

Fix: Do a test import with 5-10 contacts first. Make sure everything maps correctly before importing thousands.

Data privacy and compliance

GDPR (Europe)

If you have European subscribers:

  • Only email people who explicitly opted in
  • Store consent records (when, where, how they subscribed)
  • Make it easy to unsubscribe
  • Allow people to request their data or deletion
  • Have a privacy policy explaining data use

CAN-SPAM (United States)

  • Include your physical address in emails
  • Make unsubscribe links clear and functional
  • Honor opt-out requests within 10 days
  • Don’t use misleading subject lines
  • Identify emails as advertisements (if applicable)

CASL (Canada)

  • Get express consent before emailing
  • Clearly identify yourself in emails
  • Include working unsubscribe mechanism
  • Keep records of consent

Other countries

Check local requirements. Many countries have their own email marketing laws.

Starting fresh vs importing existing lists

If you’re moving from another platform or just starting email marketing, consider:

When to import your full list:

  • Everyone explicitly opted in
  • You’ve emailed them recently (within 6 months)
  • The list is clean and engaged
  • You have good records of consent

When to start fresh:

  • You haven’t emailed the list in over a year
  • You bought or scraped the contacts
  • You’re not sure about permission
  • The list has poor engagement

Sometimes starting fresh with a small, engaged list beats importing a large, inactive one.

Next steps after importing

Once your contacts are imported and organized:

  1. Send a welcome campaign: Remind people who you are and what to expect
  2. Set up automation: Welcome series for new subscribers, abandoned cart reminders, post-purchase follow-ups
  3. Plan your first regular campaign: Newsletter, promotion, or helpful content
  4. Monitor engagement: Watch how your segments perform
  5. Refine your organization: Adjust tags and segments based on what you learn

Conclusion

Properly importing and organizing your email list takes time upfront, but it pays off in better results. A well-structured list makes it easy to send the right message to the right people at the right time.

Start with the basics: clean data, clear organization, and proper segmentation. You can always add complexity as you grow.

Most importantly, respect your subscribers. Only email people who want to hear from you, make it easy to unsubscribe, and provide value in every message. That’s the foundation of successful email marketing.

Pro tip: Set a recurring calendar reminder every quarter to audit your list. Regular maintenance keeps everything running smoothly and your metrics high.