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,DirectorCommon 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
- Open your attendee list in Excel
- Ensure columns are named: email, name, phone, company, title
- Use Data → Remove Duplicates to clean your list
- Apply conditional formatting to find invalid emails
- Save As → CSV (Comma delimited) with UTF-8 encoding
- 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:
- Go to your event's Attendees tab
- Verify the count matches your expected number
- Check a few random attendees to ensure data is correct
- 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.
