How to Clean an Email List Before Importing It Into Mautic or Listmonk
To clean an email list before importing it into Mautic or Listmonk, remove duplicates, verify every address, and import only the valid rows. Self-hosted tools send from your own server and domain, so a high bounce rate is your reputation, not a shared pool.
The steps below work the same for either tool because the import is a CSV in both.
What changes when you self-host
On a hosted newsletter service, a provider watches bounce rates and may pause you, but it also absorbs some of the damage across thousands of senders. Self-hosted tools send through your SMTP relay or server. If a campaign bounces badly, the relay or the mailbox providers react to your domain and IP directly. That is why the first import deserves a check.
Step 1: Prepare the CSV
- Open the file and keep: email, first name, and any attributes you want as merge fields.
- Trim spaces and lower-case the email column. The email list formatter does this.
- Remove duplicates with remove duplicate emails.
- Delete role addresses you do not want in a newsletter with the role-based email filter.
Step 2: Verify
Upload the file on the verify page. The result splits valid, risky and invalid rows into files.
| Result | Import? |
|---|---|
| Valid | Yes, in the first import |
| Catch-all | Later, as a separate small import |
| Unknown | Re-check first |
| Invalid | Never; keep in a suppression file |
| Disposable | Never |
For how catch-all addresses behave, see what is a catch-all domain.
Step 3: Import the valid file
In both tools, the import screen maps CSV columns to fields. Map email and name, add a list or segment so you can find this batch later, and run the import. Menu labels and options change between versions, so follow the tool's current documentation.
Step 4: Keep a suppression file
Save the invalid and disposable rows in a CSV called something like do-not-import.csv. If someone later exports the old list from a spreadsheet and imports it again, you can compare against this file with compare email lists or suppression list merger before importing.
Step 5: Start small and watch bounces
Send the first campaign to a small segment, a few hundred valid addresses, and check bounces. Self-hosted tools show bounce processing differently, so check how yours records them. Many senders aim to keep bounces well under 2%; see bounce rate thresholds by platform. If the first small send is clean, send the rest.
Checklist
- CSV formatted, deduplicated and trimmed
- Every address verified
- Only valid rows imported, with a batch segment
- Invalid and disposable rows saved as a suppression file
- First send small, bounces checked
Verify the whole file
Upload the cleaned CSV on the verify page. You get 100 free email checks when you sign in with Google, no card, which is enough to test a sample. For a full list, Pro is $39 a month with unlimited email verification*, and the other columns stay attached so each person keeps their context next to the result.
*Fair use: the first 100,000 checks a month run at full speed, then slower, never cut off. See pricing.
Common questions
Why does list cleaning matter more on Mautic or Listmonk?
You usually send through your own SMTP server or a relay under your own domain, so every bounce counts against your reputation and nobody else absorbs it. A hosted platform may rate-limit or suspend you; here the damage is to your domain.
What columns does the import CSV need?
At minimum an email column. Both tools let you map columns during import, so add first name and any attributes you want to use as personalization fields. Check the tool's import screen for the current options.
Should I import risky addresses?
Not in the first campaign. Import valid rows, send, check bounces, then add catch-all rows as a second small import if you want them.
Can I verify the list after it is already imported?
Yes. Export the subscribers, verify the file, then delete or blocklist the invalid rows in the tool.
Check your list before you send
Real mailbox checks over SMTP, and nothing is sent to the address. Sign in with Google and your first 100 email checks are free, no card. Plans for bigger lists are on the pricing page.