Pay
Pick the size that fits your list and check out on Stripe. Quick Clean is $25 for up to 200 rows.
Email audience export cleanup for Mailchimp, Constant Contact and Brevo
Exported your audience from Mailchimp, Constant Contact or Brevo and want one clean file before you re-import it or switch platforms? Send the export as a CSV or Excel (.xlsx) file: same-email duplicates are merged, opt-in and consent conflicts are flagged needs_review instead of guessed, and every edited cell is listed in a change log, back in 24 hours on Quick Clean (up to 200 rows). We don't verify emails or do deliverability work.
Rather not do it by hand? Skip to done-for-you cleanup, from $25.
How to export your audience: Mailchimp, Constant Contact and Brevo
Each platform exports a file with its own column names. Below: how each one exports, in its own words, and which columns you can expect. Keep the original exports as your backup.
- Mailchimp. Open the audience and "Click Export audience." "Your export may include a ZIP file that contains separate CSV files for each type of email contact (subscribed, unsubscribed, non-subscribed, and cleaned)." "Export files contain your audience fields along with contact data that Mailchimp collects." Mailchimp's export article lists columns such as MEMBER_RATING, OPTIN_TIME ("The time a contact accessed your signup form."), OPTIN_IP, CONFIRM_TIME, CONFIRM_IP, LAST_CHANGED, LEID and EUID, NOTES and TAGS. Engagement isn't in the file: the article lists "Email engagement metrics, like opens and clicks" under what's not included. (Mailchimp Help: View or Export Your Contacts)
- Constant Contact. On the Contacts page, select the contacts, then "Click Actions > Export selection." "From the Export overlay, select all the contact information you want to include in your exported file." "When your export is complete, you can find your exported CSV or Excel file and download it by viewing your import/export activity and then clicking the "Download CSV" or "Download Excel" link." Either file works with us. Permission status needs a setting first: "The exported spreadsheet doesn't include the permission status unless the permissions are enabled." (Constant Contact Knowledge Base: Export your email or SMS contacts into a spreadsheet) Constant Contact's developer docs show an export with the headers "First name,Last name,Email address - other,Updated At" (Constant Contact developer docs: Export Contacts to a CSV File).
- Brevo. "With Brevo, you can export your contacts and their contact attributes (such as email address, phone number, creation date, etc.) as a CSV file." Select the contacts on the Contacts page, then "Click More actions > Export." "The EMAIL, LAST CHANGED, and CREATION DATE attributes are selected by default." "Select the CSV field separator you want to use: semicolon (;) or comma (,)." Either separator works with us. (Brevo Help Center: Export your contacts from Brevo) Default attributes include CONTACT_ID, EMAIL, FIRSTNAME, LASTNAME, SMS ("Stores the phone number of your contacts used for SMS and phone calls."), OPT_IN and DOUBLE_OPT-IN ("Stores whether your contacts have confirmed their subscription through a double opt-in process."). "The name of the default attributes may vary based on the account language you selected when you created your Brevo account." (Brevo Help Center: About contact attributes)
- One file per job. Several exports from the same platform can be stacked into one file (same columns, one header row). Exports from different platforms have different columns: line them up under one header row first, or send them as separate jobs.
- Re-import yourself. Import the cleaned file into your platform, or the one you're moving to, and test a small file first. If your platform imports one subscription status at a time, split the cleaned file by status first.
Merging two Mailchimp audiences? See how to merge audiences in Mailchimp. One Mailchimp or Klaviyo audience: Mailchimp / Klaviyo audience CSV cleanup. Duplicates inside one platform: Constant Contact, Brevo.
Caution: what this cleanup doesn't do
- No email verification. We don't check mailboxes, contact mail servers, test deliverability, or predict bounces or inbox placement. Our email checks are a syntax check (an address that isn't shaped like an email is flagged invalid, a blank one missing) and a personal-email flag (for example Gmail or Yahoo). Nothing is deleted for failing a check.
- No status changes. We don't remove unsubscribed or cleaned contacts or change anyone's subscription status. When two same-email rows disagree in an opt-in or consent column, the row is flagged needs_review with both values listed in qa_notes, and you decide.
- Mailchimp splits statuses into separate files. Before stacking them, add a "Status" column to each file (subscribed, unsubscribed, non-subscribed or cleaned, from the file name). It comes back as status_src, because the cleaned file has its own status column.
- Brevo's SMS column is kept as you sent it: we only reformat the phone column. Test a small file in your platform before a full import.
We only clean the exported file. We never log in to or touch your Mailchimp, Constant Contact or Brevo account. Every column in your export is kept (extra spaces trimmed). When two rows share an email, blank cells on the kept row can be filled from the duplicate row, and every fill is listed in the change log. When both rows have different values, the first row's value is kept and the other is listed in the change log. If they disagree in a consent-type column we recognise by header name (for example Mailchimp's OPTIN_TIME, Brevo's OPT_IN and DOUBLE_OPT-IN, or a Status column you add), the row is also flagged needs_review with both values listed in qa_notes. You run the import and choose each status yourself.
Or let us clean the export before you re-import it or switch platforms
- You send one export as a CSV or Excel (.xlsx) file. With Excel, we clean the first sheet of the workbook, and the file comes back as a cleaned CSV plus a change log. We don't take old Excel .xls files; save them as .xlsx or CSV first. Brevo's semicolon-separated files are fine. Several exports from one platform can be stacked into one file (same columns, one header row); we clean one file per job.
- Rows with the same email (ignoring capitalization and spaces at the start or end) are merged into one row: the first row is kept and its blank fields are filled from the later rows. Where both rows have different values, the first row's value is kept and the other is listed in the change log; tag values aren't combined. Every merge and every fill is listed in the change log.
- Opt-in and consent conflicts are flagged, not guessed: if two same-email rows disagree in a consent-type column (for example OPTIN_TIME, OPT_IN or a Status column you add), the row is marked needs_review with both values listed in qa_notes. We never pick a subscription status for you.
- Rows with the same full name and the same company, where both are present, but a different or missing email are flagged, not merged, with a note naming the row they may match. Misspelled names aren't caught. Audience exports often have no company column, so this flag rarely applies, and every row without a company gets a "missing company" note and is marked needs_review.
- Invalid, missing and personal (for example Gmail or Yahoo) emails are flagged in qa_notes. We don't fix or verify mailboxes. The email check is a syntax check plus a personal-email flag only.
- Names in ALL CAPS or all lowercase are re-cased. US phone numbers are formatted +1-XXX-XXX-XXXX. Numbers with a non-US country code (starting with + or 00) are kept as you sent them (extra spaces trimmed only). Numbers with no country code and 10 digits are treated as US. Placeholder phones like N/A are blanked and logged. Anything we can't read is kept as-is, with a note in qa_notes. Line breaks inside cells are turned into spaces (except in the email column, where a broken email is flagged invalid instead), and the CSV is saved as UTF-8.
- You get back the cleaned CSV (with status, qa_notes and source_row columns), a change log with every merge, every fill from a duplicate, every email and possible-duplicate flag, and every edited cell listed by row, with its old and new value, a QA report with counts (rows in and out, duplicates merged, possible duplicates flagged, emails flagged and cells edited), and your original file, unchanged.
- What we don't do: we don't verify emails, check mailboxes or do any deliverability work (no bounce prediction, inbox placement or sender reputation). We don't remove unsubscribes, change subscription statuses, run the import or log in to your platform. We don't find, buy or add contacts, and we don't merge rows that only might be the same person.
Clean my audience export · $25 (up to 200 rows, back in 24h)
Bigger list? Intro $99 for up to 500 rows (48h) · Growth $299 for 501 to 2,000 rows (72h) · Bulk $499 for 2,001 to 5,000 rows (5 business days) · over 5,000 rows, custom quote. See all sizes.
What you get back
- Every change is logged with its original row number.
- Possible duplicates are flagged for your review, never blind-merged; same-email duplicates are merged and listed in the change log.
- Your original file is returned alongside the cleaned one.
See a free before-and-after sample · sample files you can download
Check your CSV free first
Check your export for exact-email duplicates and formatting problems free in your browser before you re-import it. Your file never leaves your computer.
How it works
Email us your CSV (reply to your receipt or send it to slrescue@mail.grokbot.com)
No email-platform login, no call, no upload form.
Get it back: 24h (Quick Clean, up to 200 rows), 48h (Intro), 72h (Growth), 5 business days (Bulk)
A clean CSV plus a change log. Over 5,000 rows, the turnaround is scoped in your custom quote.
Flat pricing
- Quick Clean, up to 200 rows, back within 24h, $25 (credits toward a larger pack within 14 days)
- Intro, up to 500 rows, back within 48h, $99
- Growth, 501 to 2,000 rows, back within 72h, $299
- Bulk, 2,001 to 5,000 rows, 5 business days, $499
- Over 5,000 rows: email us for a custom quote
Your $25 Quick Clean counts toward any bigger cleanup within 14 days.
Quick Clean, Intro, Growth and Bulk: If the file isn't what we promised, we fix it once for free within 48 hours. If it still isn't right, you get your money back for the part we couldn't deliver. If we're late, you choose a full refund or a free rush job.
Not sure how messy it is? CRM Hygiene Scorecard (written diagnosis), $29 · DIY HubSpot and Salesforce import checklist, $9. Agencies: white-label batches.
Questions
Do you verify email addresses?
No. We don't verify emails, check mailboxes or do deliverability work. The email check is a syntax check only: an address that isn't shaped like an email is flagged invalid and a blank one is flagged missing. Personal addresses (for example Gmail or Yahoo) get a personal email flag. Nothing is deleted for failing a check.
Will you remove unsubscribed or bounced contacts?
No. We don't drop rows by status. If same-email rows disagree in an opt-in or consent column, the row is flagged needs_review with both values listed, and the first value is kept. Mailchimp puts each status in its own file: "Your export may include a ZIP file that contains separate CSV files for each type of email contact (subscribed, unsubscribed, non-subscribed, and cleaned)." (Mailchimp Help) Add a Status column to each before stacking, so you can see conflicts.
Which files do you take?
A CSV or Excel (.xlsx) export from Mailchimp, Constant Contact or Brevo, or any other platform. Constant Contact offers both: "you can find your exported CSV or Excel file" (Constant Contact Knowledge Base). Brevo files with a semicolon or comma separator both work. With Excel, we clean the first sheet only. We don't take old Excel .xls files.
Will you log in to or change anything in my account?
No. We clean the exported file only. Same-email rows are merged in the file, with each merge and fill logged. You run the import and any clean-up in Mailchimp, Constant Contact or Brevo yourself.
What comes back, and how do I import it?
A UTF-8 CSV, also when you send Excel (.xlsx), plus a change log. Headers come back in lowercase with underscores (for example, OPTIN_TIME becomes optin_time and DOUBLE_OPT-IN becomes double_optin), and the email column (Email Address, Email address - other or EMAIL) comes back as email. Our standard columns come first (full_name, then first_name and last_name when your export has them, then email, phone, company, title, website and linkedin; some may be blank), then status and qa_notes, then the rest of your columns and source_row. Leave status, qa_notes and source_row unmapped when you import. We don't run or guarantee the import.
Do you need access to my email platform account?
No. You export a file and email it. We only clean the exported file and never log in to or touch your email platform account.
How fast is delivery?
From when we receive your file: Quick Clean (up to 200 rows) within 24 hours, Intro within 48 hours, Growth within 72 hours, Bulk within 5 business days. Over 5,000 rows is scoped in your quote.
What if the cleaned file isn't right?
If the file isn't what we promised, we fix it once for free within 48 hours. If it still isn't right, you get your money back for the part we couldn't deliver. If we're late, you choose a full refund or a free rush job.
What happens to my data?
Your file is used only for your job and deleted after delivery on request (see Anonymous aggregate statistics). We never log in to your CRM, and we never invent, buy, or append emails.
Anonymous aggregate statistics. After a cleanup we keep a small record of counts about your file: rows in and out, duplicates merged, rows flagged for review, which fields were present, and the CRM you told us it's for. This record contains no contact data, names, emails, company names, domains, file names or cell values, and it isn't deleted when your file is deleted. We only publish these counts combined with at least 19 other lists (and at least 5 different customers), so no single customer can be identified. To opt out, reply 'opt out' to your delivery email and we'll delete your record.
Try the free in-browser CSV dedupe teaser (data never leaves your browser). Freelancers: see the referral kit.
Not affiliated with Mailchimp, Constant Contact or Brevo. Quotes are from their public help and developer docs.