How to turn a newsletter archive into a book
Export your archive, then treat it as raw material: pick one theme, drop the issues tied to their week, and group what’s left into chapters with new writing between them. Exports come in different forms (a zip from Substack, a CSV from beehiiv, JSON from Ghost), so plan on moving the chosen issues into a document or working from their web pages.
Get the archive out
Every platform does this differently. These are the steps as each platform’s help pages gave them when we checked on 30 October 2026.
| Platform | Where to find it | What you get |
|---|---|---|
| Substack | Settings, Exports, “Create new export” | A zip file of your publication’s data, including posts |
| beehiiv | Settings, Export Data, Export Posts, “Export All Posts” | A CSV of all posts, including archived and draft ones, by an email link valid for 24 hours |
| Ghost | Settings, Advanced, Import/Export, Export tab, “All data” | A zip with your posts in JSON and a CSV of per-post sends, opens and clicks |
On another platform, look in its help pages for an export of posts or campaigns. If there isn’t one, your public archive page still lists what you have sent, and you can work from that.
Check who owns the words, too. Substack’s terms say “you own what you create”, and Ghost describes “full ownership of your content and data”. On another platform, read its terms. Pieces by guest writers are a separate matter, so ask them before you include them.
Why an archive isn’t a book yet
A newsletter is written for one week. It assumes the reader saw last week’s issue, cares about this week’s news, and will be back next week. A book has none of that. Its reader arrives once, knows none of your running jokes, and has to get everything from the page.
So the issues that made your newsletter feel alive are often the first to go: the news reaction, the link roundup, the reply to a reader’s email. What survives is the part that would still be true for someone who found it in three years.
Choose a shape
- A book on one theme. Chapters built around an argument, with issues merged and rewritten to serve it. This is the most work and usually the most useful to a stranger.
- A selection with notes. Your best pieces largely as written, each with a short new note on why it’s there and what you think now. It’s quicker and suits a writer whose voice is the attraction.
- A chronicle. Issues in date order, when the passing of time is the story: a year building a company, or a season of a project. It’s rarer, and it only works if something changes along the way.
Whatever the shape, use your numbers as a clue, not a verdict. An issue with a high open rate may have had a good subject line and nothing lasting in it. Ghost’s export includes per-post opens and clicks, and a spreadsheet of your issues with a keep, rewrite or drop column is often all the planning tool you need.
If some issues were paid
Paying subscribers bought access to those issues, so tell them before they see the book on sale. Giving them an early or free copy is a simple way to thank them. If paid issues are going into the book, say what’s new in it, so that nobody feels sold the same thing twice.
If you plan to enroll the ebook in KDP Select, read its terms first: the ebook “must also be exclusive to the Kindle Store” during the 90-day enrollment, and it “can only be distributed through KDP and public libraries.” KDP’s pages don’t mention newsletters or web archives, so ask KDP if the same text stays online.
Where Chapbook fits
Chapbook’s “I have a draft” doesn’t read a platform’s export file directly. It takes Word, Markdown or plain-text files, up to 10 at a time, or up to 20 links, each of which becomes a chapter word for word, as text only. Links are read without signing in, so use public pages: a paywalled issue gives only what a stranger would see. Put selected issues into a document, or paste the links of the ones you kept, then merge, split and leave out chapters before the book is created. Importing is free, and any AI action on the book afterwards costs credits.
Choose the kind that matches the result: a nonfiction book for a themed book, or a lead magnet for a short selection to welcome new subscribers. On a paid plan, a book can have its own page where readers sign up. The sample on this page is not an imported archive. It is a guide on newsletter welcome sequences, generated from one brief, and it shows what a short book for a newsletter’s readers looks like when it’s typeset.
What to do
-
Export everything first
Get a full copy before you decide anything. It is your backup and your working list, and reading the titles in one place shows you what you have actually been writing about.
-
Find the book’s one theme
Look for what you keep coming back to. If one subject runs through many issues, that’s the book. Say in a sentence what a new reader will get from it.
-
Sort issues into keep, rewrite and drop
Keep what still holds up, rewrite what has a good idea in a dated wrapper, and drop link roundups, news reactions and announcements. Most archives shrink a lot at this step.
-
Group the keepers into chapters
A chapter may be several issues merged, not one issue each. Order the chapters as a new reader needs them, not by the dates you sent them.
-
Strip the email out of it
Remove greetings, sponsor messages, referral asks, shout-outs and “see you next week”. Keep the voice, which is what your readers came for.
-
Offer it to your subscribers first
They read these issues before anyone else, and some may have paid for them. Tell them what the book is and what is new in it before you announce it elsewhere.
