Exporting Blog Posts
Export your Shopify blog posts — the individual articles inside your blogs — to a CSV or Excel file, across every connected store at once. For the blogs that contain them, see Exporting Blogs.
For the wizard itself — picking columns, formats, destinations, and schedules — see the exporting overview.
What you can export
In Simple mode you pick from a curated list of the fields merchants use most. The key ones:
| Field | What it is |
|---|---|
| ID | The article's unique id in the index. |
| Title | The article title. |
| Blog | The title of the parent blog the article belongs to. |
| Author | Display name of the article's author. |
| Published | Whether the article is published on the storefront. |
| Published At | When the article was published. |
| Handle | URL-friendly slug used in the article's storefront URL. |
| Body HTML | The full HTML body of the article. |
| Summary HTML | The article's short summary/excerpt. |
| Image Src | URL of the article's featured image. |
| Tags | The article's tags, comma-separated. |
| Created At / Updated At | When the article was created and last changed. |
| Store | The store the article belongs to (name, domain, or email). |
Switch an article to Template (Advanced) mode for the full column tree, including the denormalized parent-blog fields, per-comment, per-metafield, and timeline event columns, and renamed headers.
One row per article
By default each article is a single row. If you add per-comment,
per-metafield, or per-event columns, the export expands to one row per
comment, metafield, or event, repeating the article's ID on each
continuation row. To keep one row per article, use the compact summary columns
instead — Comments, Metafields, and Events each have a count and a summary
column that fit the whole set into one cell.
Filtering what you export
Narrow the export to the slice you want. The available filters are:
- Store — one or more connected stores.
- Blog — by blog id or blog handle, to export just one blog's articles.
- Published — published or unpublished articles only.
- Author — contains-match on the author name.
- Title and Handle — contains-match on the article's title or slug.
- Tags — contains-match on the article's tags.
- Template suffix — the Liquid template used.
- Published / Created / Updated date — a date range or a shorthand like the last 7, 30, or 90 days.
The wizard's search box matches the article title. The filter you set here is part of the export and is independent of whatever filter you last used on the Blog Posts dashboard.
Exporting from the dashboard vs the wizard
The Blog Posts dashboard has an Export button (the Export Builder) for a quick, single-entity export scoped to what you're viewing — Current page, Filtered, Selected, or All blog posts. Use the Export Wizard when you want articles alongside other entities or on a recurring schedule.
Scheduling
Any blog posts export can run automatically on a daily, weekly, or monthly schedule — each run rebuilds from live data and delivers to your destination. See the exporting overview for how schedules work.
Tutorial: export one blog's published articles
- Go to Exports → New export (
/exports/new). - In Step 1, tick Blog Posts and click Next.
- In Step 2, keep Simple columns (Title, Blog, Author, Published, Published At, Store are on by default), and add Body HTML if you want the content.
- Add a Blog filter (by blog handle) to scope it to one blog, and a Published filter set to published.
- In Step 3, choose Excel and set the destination to Email.
- In Step 4, name it "Published articles" and click Run now.
- The file is delivered to your inbox; larger exports are queued with an in-app notification when they're ready.
Permissions
- View Exports — build and run blog post exports.
- Download Exports — download the finished files.
Account owners have both. Grant them to team members from their permissions.
FAQ
Can I export Shopify blog posts to Excel? Yes — choose Excel (.xlsx) or CSV
in Step 3. A combined multi-entity workbook is always Excel.
Does the export include the article body? Yes — add the Body HTML column for the full HTML, or Summary HTML for just the excerpt.
Can I export just one blog's articles? Yes — add a Blog filter (by blog handle or id) to scope the export to a single blog.
Can I export only published articles? Yes — add a Published filter set to published (or unpublished).
Can I include article comments? Yes — add the comment columns. Per-comment columns expand the export to one row per comment; the summary column keeps it to one row per article.
Can blog post exports run on a schedule? Yes — save the export as a daily, weekly, or monthly schedule and each run rebuilds from live data.