1. Home
  2. Free tools
  3. Email list tools
  4. Newsletter subscribers to email list

Newsletter subscribers to email list: Substack, beehiiv, Kit and Ghost exports, ready to import

In short: Reads a subscriber export from Substack, beehiiv, Kit (ConvertKit), Ghost or MailerLite and sorts every row into active, unconfirmed, unsubscribed, bounced or complained from that platform's own status columns. Only active subscribers are kept by default; paid subscribers are marked. Limit: It reads the statuses in the export; platforms that leave unsubscribes out of the export can't show them.

To move newsletter subscribers, export them (Substack: Settings > Export; beehiiv or Kit: Subscribers > Export; Ghost: Members > Export) and upload the CSV here. Each platform's status columns are read, so unsubscribed, bounced, spam-complaint and unconfirmed subscribers are set aside, and the active list downloads ready to import.

Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing

Runs in your browser. Nothing is uploaded.
Options
Sample result from the Newsletter subscribers to email list
Show the sample result as

Sample result

4 of 7 beehiiv subscribers are ready to import; 3 are left behind with the reason.

Import list
4 subscribers
Rows read
7
Paid
2

What this means for you

Each platform's status is read, so unsubscribes and bounces don't move to the new platform.

Next step:Verify the cleaned list
  • Unsubscribed and bounced set aside
  • Unconfirmed held back
  • Paid subscribers marked
  • Strictest status wins on repeats
  • Newsletter
  • Migration
  • CSV

By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us

How do I turn a newsletter export into an import-ready email list?

  1. Export subscribers: Substack (Settings > Export), beehiiv (Audience > Subscribers > Export), Kit (Subscribers > select all > Export), Ghost (Members > Export) or MailerLite (Subscribers > Export).
  2. Upload the CSV here, or paste it.
  3. Choose: keep unconfirmed subscribers, keep Kit's cold subscribers, or keep only paid subscribers.
  4. Download the import list, and the set-aside file with the reason per address.

Example

You enter
A beehiiv subscriber export with 7 rows: 4 active (2 on the premium tier), 1 inactive, 1 validating and 1 invalid.
You get
4 active subscribers ready to import, 2 marked paid; 3 set aside as Unsubscribed, Not confirmed (double opt-in pending) and Bounced or invalid.
Limits
Runs in your browser with no row cap; an uploaded file can be up to 25 MB.

How do I export my subscribers from Substack?

In Substack, go to Settings, find the export section and click Export. You get a .zip by email; the subscriber list is the email_list CSV inside, with email, active_subscription, plan and email_disabled. Upload that CSV here.

email_disabled set to true means the reader turned off emails, so the address is set aside as unsubscribed. active_subscription and plan mark paid subscribers.

Should I import unsubscribed subscribers to my new platform?

No. They asked to stop, and most platforms will either block the import or re-suppress them. The tool reads each platform's way of saying so: beehiiv inactive, Kit cancelled, bounced and complained, Ghost subscribed_to_emails false, MailerLite unsubscribed, bounced and junk. All of them go to the set-aside file with the reason.

Unconfirmed subscribers (beehiiv validating, MailerLite unconfirmed) never clicked the double opt-in link. They are set aside by default; tick the option to keep them if your old platform didn't use double opt-in.

Do paid subscriptions move with the email list?

No. The list carries the addresses; the subscriptions live in Stripe and move through the new platform's own Stripe migration. The paid column marks who pays so you can check them off after the move, or tick Keep only paid subscribers for a paid-only list.

Is this faster than filtering the export in Excel?

This toolExcel or Sheets
Status wording per platformRead for five platformsLearn each one, filter
Substack email_disabledSet aside as unsubscribedEasy to miss
Repeated readersStrictest status winsRemove duplicates keeps the first
Set-aside fileWith a reason per addressCopy out by hand

Who uses this tool, and for what?

Newsletter writers
Move from Substack to beehiiv or Kit without re-adding readers who unsubscribed.
Creators
Pull a paid-only list for a member perk, separate from free readers.
Media teams
Merge exports from two publications and keep the strictest status for each reader.
Agencies
Prepare a client's Ghost or MailerLite list for a platform switch with a reason for every removal.

What can’t this tool tell you?

  • It reads the statuses in the export; platforms that leave unsubscribes out of the export can't show them.
  • Paid status comes from the plan, tier or active_subscription columns; subscriptions themselves don't move.
  • It can't tell which addresses still have a working inbox.
  • Engagement (opens, clicks) is only read through a platform's own status, such as Kit's cold.

Common questions

How do I move from Substack to beehiiv?
Export from Substack, upload the email_list CSV here, download the active list and import it in beehiiv under Audience > Subscribers > Import. Paid subscriptions move separately through Stripe.
Does it work with Kit (ConvertKit)?
Yes. Kit's export has email_address and state; cancelled, bounced and complained are set aside, and cold subscribers are kept unless you untick that option.
What does beehiiv's validating status mean?
beehiiv is still checking the address or waiting for the double opt-in click. Those subscribers are set aside as unconfirmed by default.
Does it work with Ghost and MailerLite?
Yes. Ghost's subscribed_to_emails and tiers columns and MailerLite's status column are read.
Is my subscriber list uploaded?
No. It is read in your browser. Nothing is sent unless you choose to check the addresses afterwards.

Sources

A tidy list can still be full of dead addresses.

Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.

  • Upload the cleaned file as it is: CSVs up to 100,000 rows
  • A real SMTP mailbox check on every row, with catch-all detection
  • Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime

One plan, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.

Clean your next list before it bounces

100 free email checks when you sign in with Google, no card. Then monthly plans from $9, or one flat price with fair use, never cut off.

100 free checks, no card Cancel anytime Secure payment by Stripe