How to import a Substack writer export into Obsidian

As of October 2026, Obsidian's official Importer supports HTML files and folders. Extract post HTML for that route, or use Substack Export Import to join the writer ZIP's CSV fields to matching bodies.

Background

A writer export separates publication fields from post bodies. Substack Export Import joins complete post IDs and reports rows without HTML instead of creating empty post notes.

2 ways to do it

  1. Import extracted HTML with the official Importer

    Extract the ZIP locally and select its post HTML files or folder in Importer. Choose HTML as the file format, review the template and examples, then import the files.

    limits
    This is an HTML import route inferred from Obsidian's documentation. It does not establish a CSV join or preserve fields found only in posts.csv.
  2. Substack Export Import from this site

    Select a writer ZIP with root posts.csv and matching posts/<post_id>.html bodies. Preview matched records and missing bodies, then create Markdown posts with publication properties in a new folder.

    limits
    Subscriber files are ignored, and media are not downloaded. Rendering retained remote images can disclose your network address to their original hosts.
    A podcast post keeps publication fields as note properties.
    Open larger

    MIT · no telemetry · core features free

    All features of Substack Export Import

Check and import a writer ZIP

  1. Keep the original ZIP and run Import writer export.

  2. Enter a new output folder; a nested path needs an existing parent.

  3. Select the local export and read its preview and report.

  4. Select Create import folder, then inspect the new notes and report.

Common questions

Can a numeric prefix match a longer post ID?

No. The complete CSV ID must match the HTML filename, including any slug suffix.

Can I import an export wrapped in another folder?

No. The ZIP needs posts.csv at its root and direct HTML files inside posts.

Sources

Photo of Michael LipYou can now import a Substack writer export.

Obsidian rewards people who share. NoteMods is just me and a lot of coffee. If this guide saved you a fight with the syntax, buy me a cup.