📊CSV Import Templates

Email Marketing List

Email subscriber list format for marketing platforms (Mailchimp, SendGrid, etc.).

Explanation

Standard format for importing email subscribers with segmentation data.

Examples

Subscriber List CSV

Output

email,firstName,lastName,subscribed,tags,source,subscribeDate
john@example.com,John,Doe,true,"newsletter,vip",website,2024-01-15
jane@example.com,Jane,Smith,true,newsletter,landing-page,2024-02-20
bob@example.com,Bob,Jones,false,,manual,2024-03-10

Code Examples

JavaScript

// Import subscribers with validation
async function importSubscribers(csvData) {
  const subscribers = parseCSV(csvData);
  const results = { imported: 0, skipped: 0, errors: [] };
  
  for (const sub of subscribers) {
    // Validate email
    if (!isValidEmail(sub.email)) {
      results.errors.push({ email: sub.email, reason: 'Invalid email' });
      continue;
    }
    
    // Check if already subscribed
    const exists = await checkSubscriber(sub.email);
    if (exists) {
      results.skipped++;
      continue;
    }
    
    // Add subscriber
    await addSubscriber({
      email: sub.email.toLowerCase(),
      firstName: sub.firstName,
      lastName: sub.lastName,
      tags: sub.tags ? sub.tags.split(',') : [],
      source: sub.source,
      subscribedAt: new Date(sub.subscribeDate || Date.now())
    });
    
    results.imported++;
  }
  
  return results;
}

Try it Now

Open in CSV/JSON Converter

💡 Tips

Always lowercase emails for consistency
Include opt-in source for compliance
Use tags for segmentation
Track subscription date
Include unsubscribe status field
Remove duplicates before import

⚠️ Common Pitfalls

Missing consent date may violate GDPR
Duplicate emails waste credits
Invalid emails cause bounces
Don't import purchased lists
Check double opt-in requirements