The Scenario
You are a newsletter operator. You just made the call to leave Mailchimp. The export came back with 5,000 subscribers in an Excel workbook: email, first name, last name, and the tags each person picked at signup. They need to land in your new Mailcoach list before your next send goes out in four days.
The workbook is open. Column A is email, B is first name, C is last name, D is tags. The list UUID you need to import into is in cell F1.
The bad version of this migration:
- You save the workbook as CSV, upload it through the Mailcoach dashboard
- Mailcoach's CSV import does not handle your tag values cleanly
- You spend an hour remapping columns in the UI
- Some rows fail silently because an email has a trailing space
- You get a summary count but no row-level feedback, so you cannot tell which 47 subscribers did not make it
- You go into your first send with a list you cannot fully trust.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your subscriber data and calls the Mailcoach import API directly, so you do not need to leave the workbook.
Open the SheetXAI sidebar and type:
Import all rows from this workbook into Mailcoach email list using the UUID in cell F1. Email is in column A, first name in column B, last name in column C, tags in column D. Write QUEUED or ERROR into column E for each subscriber row.
SheetXAI reads the rows, trims whitespace, formats the payload, calls the Mailcoach import API with the correct list UUID, starts the import job, and writes per-row status back into column E. You can see exactly which rows succeeded and which need attention.
What You Get
A completed Mailcoach import with per-row accountability:
- Column E status — QUEUED for rows accepted by the API, ERROR with a reason for rows rejected
- Import started — the job is running in Mailcoach, no dashboard visit required
- Tag assignment — each subscriber's tags from column D are included in the import payload
- Zero silent failures — anything that did not queue shows up as an ERROR you can filter and fix
5,000 rows is not a constraint. SheetXAI batches the import automatically. You do not need to split the workbook, upload in chunks, or babysit the progress.
What If the Data Is Not Quite Ready
Most migrated subscriber files are not export-clean. SheetXAI handles normalization and the import in the same prompt.
When tag values are inconsistent
Your old platform capitalized tags differently — "newsletter," "Newsletter," "NEWSLETTER" all coexist in column D.
Normalize all tag values in column D to lowercase. Then run the Mailcoach import for the list UUID in cell F1 and write QUEUED or ERROR into column E.
When some rows have no email
A handful of rows have a name but an empty column A.
Skip any row where column A is blank. Write SKIPPED into column E for those rows. For the rest, run the Mailcoach import and write QUEUED or ERROR.
When you only want active subscribers
The export includes unsubscribed contacts from a previous cleanup.
Filter to rows where column F is "subscribed." Import only those rows into the Mailcoach list UUID in cell F1. For rows excluded by the filter, write EXCLUDED in column E.
When the workbook has duplicate emails and inconsistent names
The export has 5,000 rows but 400 are duplicates from a data merge. Some first names have trailing punctuation.
Deduplicate by email in column A, keeping the first occurrence. Trim and clean the first name in column B. Then run the Mailcoach import for the list UUID in cell F1. Write QUEUED or ERROR into column E for each processed row.
The pattern: instead of cleaning the workbook before the import, you clean and import in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any subscriber workbook, then ask it to run the Mailcoach import. The Mailcoach integration is included in every SheetXAI plan. For the next step after importing, see how to apply tags to Mailcoach subscribers from a workbook or the Mailcoach in Excel overview.