📧 Email List Cleaner Pro

A simple and powerful Python tool to clean email lists by removing bounced or invalid emails using Excel files.

---

🚀 Introduction

Email List Cleaner Pro helps you maintain a high-quality email list by removing unwanted or invalid email addresses.

It compares:

• Your main email list
• A bounced/invalid email list

And automatically generates a cleaned dataset ready for campaigns.

---

⚙️ How It Works

1. Loads input email list from Excel
2. Loads bounced email list
3. Detects email columns automatically
4. Cleans and normalizes email data
5. Removes matching (bounced) emails
6. Saves a new cleaned Excel file
7. Displays summary in terminal

---

✨ Features

• 📂 Excel-based input & output
• 🔍 Automatic email column detection
• 🧹 Removes bounced/invalid emails
• 🔤 Case-insensitive matching
• ⚡ Fast processing
• 📊 Summary output (removed vs remaining)
• 🧠 Smart column normalization
• 🛠 Handles messy data formats

---

📦 Technologies Used

• Python → Core language
• pandas → Data processing
• openpyxl → Excel file handling

---

📥 Input Files

1. input_emails.xlsx

main email list

Required:

Email

---

2. Bounced_Highlighted.xlsx

Contains emails to remove

Required:

Email

---

🛠 Installation

1. Clone Repository

git clone https://github.com/yourusername/Email-List-Cleaner-Pro.git
cd Email-List-Cleaner-Pro

2. Install Dependencies

pip install pandas openpyxl

▶️ Usage

Run the script:

python EmailListCleanerPro.py

📊 Output

📁 Cleaned File

input_emails_cleaned.xlsx

🧠 Smart Features

🔍 Automatic Column Detection

The tool can detect email columns even if named like:

• email
• email address
• mail
• e-mail
• email_id

🧹 Data Cleaning

• Removes extra spaces
• Converts to lowercase
• Handles missing or invalid values

💡 Use Cases

• Clean email lists before campaigns
• Remove bounced emails
• Improve deliverability
• Prepare data for marketing tools
• Maintain CRM quality

🎯 Benefits

• Reduce bounce rate
• Improve email success rate
• Save time (no manual filtering)
• Increase campaign performance

⚠️ Limitations

• Requires Excel files
• No real-time validation
• Only removes existing bounced emails

🔒 Best Practices

• Always clean lists before sending campaigns
• Combine with bounce detection tools
• Keep backup of original data
• Regularly update bounced list

👨‍💻 Author

Malki

⭐ Support

If you find this project useful, give it a star ⭐

📜 Disclaimer

This tool is intended for data cleaning purposes only. Users are responsible for how they use their email data.

---