Export Shopify Blog Posts to CSV or Excel

To export your Shopify blog posts, use Mixtable Export: Excel & CSV. The Blogs and Blog Posts template puts your posts in a worksheet where you can choose the fields to include and download an Excel or CSV file.

Export your Shopify blog posts

1. Install and open Mixtable Export: Excel & CSV
2. Open your Mixtable dashboard and click Create spreadsheet at the top of the page. If you haven't created a spreadsheet yet, click Browse all templates below the starting-point cards instead. In the Create spreadsheet window, find Blogs and Blog Posts under Content, or type its name in the search box, and click it. Mixtable creates the spreadsheet and fills it with data from your Shopify store.
3. Select the worksheet containing your blog posts. Check the columns you want in the file, such as title, handle, content, author, and tags. Add or remove columns as needed
4. Shopify doesn't send changes to blog posts on its own, so download them when you need the latest. Click Download latest in the sync control at the top right of the spreadsheet (or choose Shopify Sync > Sync with Shopify…) to open the sync card. Under Download latest from Shopify, click Download next to Blog posts.
5. Once the download finishes, click Import & Export in the menu bar. Choose Export to Excel for an .xlsx file or Export to CSV for a .csv file

On your first visit, the Export blog posts card on the dashboard creates the same spreadsheet in one click. If you have more than one Shopify store connected, choose the store at the top of the Create spreadsheet window before you click the template.

Choose the blog post data to include

The template shows your Shopify blog posts as rows. The fields you can include in the export include:

• Title
• Handle
• Content
• Author
• Tags
• Shopify ID
• Blog ID

You can add more blog post fields before exporting. Click ＋ Shopify data in the header row of an empty column, or choose Column > Add Shopify data… from the menu bar. The field picker opens and asks What should column E show?, with your column’s letter in place of E. Type the field’s name in the search box, or click a section on the left, such as Content or Search engine listing. Then click the blog post field you want, such as Excerpt, and click Save Column.

If you already have a Mixtable spreadsheet

You can add a blog posts worksheet to an existing spreadsheet instead of starting with the template:

In an existing Mixtable spreadsheet, click the + button at the end of the worksheet tabs, at the bottom of the screen, to add a new worksheet.

Choose Shopify data worksheet, click Continue, and then choose Blog Posts. Pick the columns you want, click Continue, and then click Create Worksheet. Before you export, click Download latest in the sync control at the top right and then Download next to Blog posts, so the file includes recent changes.

Export only certain blog posts

If you need a subset of posts, create a conditional blog posts worksheet and set the criteria for the posts you want. Export that worksheet to CSV, or export the whole spreadsheet to Excel if you also need its other worksheets.

If a post stops matching the conditions, its row may become empty. To remove those rows before exporting, open Worksheet and select Remove Empty Rows.

Choose Excel or CSV

Excel (.xlsx) exports the entire Mixtable spreadsheet, including any other worksheets you added. Choose Import & Export > Export to Excel when you want those worksheets together in one file.

CSV (.csv) exports only the active worksheet. Select the blog posts worksheet, then choose Import & Export > Export to CSV when you want a single table of posts.

Your browser downloads the file after you choose the export format.