This script helps you clean and prepare email lists for importing into ConvertKit. It validates emails, extracts clean first names, and outputs a properly formatted CSV.
- Reads an input CSV file with email addresses
- Validates email format using regex
- Extracts a first name from the email address (e.g.
john.doe@example.comβJohn) - Removes duplicates
- Outputs a clean CSV with just
EmailandFirst Namecolumns
This script requires pandas:
pip install pandas