Back to Help Center

CSV Troubleshooting

6 min read

CSV Import Overview

CSV (Comma-Separated Values) files are the fastest way to import large lists of attendees into Reminder Flow. This guide covers common issues and how to resolve them.

CSV File Format Requirements

Your CSV file must include these columns:

  • email (required): Valid email address
  • name (required): Attendee full name
  • phone (optional): Phone number
  • company (optional): Organization name
  • title (optional): Job title

Example CSV structure:

email,name,phone,company,title john@example.com,John Doe,555-0100,Acme Corp,Manager jane@example.com,Jane Smith,555-0101,Tech Inc,Director

Common Import Issues

❌ "Invalid CSV Format" Error

Cause: Missing required columns or incorrect formatting

Solution:

  • Verify your CSV has "email" and "name" columns
  • Check that column headers are lowercase
  • Ensure the file is saved as .csv format (not Excel .xlsx)

❌ "Invalid Email Address" Error

Cause: One or more rows contain invalid email addresses

Solution:

  • Check for typos in email addresses
  • Ensure emails have @ symbol and domain
  • Remove any spaces before or after email addresses
  • Use Excel's Find & Replace to fix common errors

❌ "Duplicate Email Detected" Error

Cause: The same email appears twice in your CSV or already exists in the event

Solution:

  • Use Excel's Data → Remove Duplicates feature
  • Sort by email and check for duplicates manually
  • Check if attendees are already added to the event

❌ "File Too Large" Error

Cause: CSV file exceeds size limits

Solution:

  • Split large files (max 10,000 attendees per file)
  • Import in batches
  • Remove unnecessary columns

❌ "Encoding Error" Error

Cause: CSV file is not UTF-8 encoded (often occurs with non-English characters)

Solution:

  • Open CSV in Notepad or a text editor
  • Go to File → Save As
  • Change encoding to UTF-8
  • Save and try importing again

Tips for Clean Data

  • Remove leading/trailing spaces: Use Excel's TRIM function
  • Standardize names: Use PROPER function to capitalize properly
  • Text to lowercase: Use LOWER function for consistency
  • Remove special characters: Replace unusual characters
  • Validate emails: Use data validation before exporting

Excel Preparation Guide

  1. Open your attendee list in Excel
  2. Ensure columns are named: email, name, phone, company, title
  3. Use Data → Remove Duplicates to clean your list
  4. Apply conditional formatting to find invalid emails
  5. Save As → CSV (Comma delimited) with UTF-8 encoding
  6. Upload to Reminder Flow

💡 Pro Tip

Test with a small CSV file (5-10 attendees) first to verify your format is correct before importing thousands of records.

Verifying Imported Attendees

After successful import:

  1. Go to your event's Attendees tab
  2. Verify the count matches your expected number
  3. Check a few random attendees to ensure data is correct
  4. Look for any data that got cut off or corrupted

✅ Ready to Go!

Once attendees are imported, you can set up reminders and start sending emails automatically.