search

Export Shopify Blog Posts

Managing Shopify blog posts in bulk (changing titles, meta descriptions, mass edits of content and HTML, tags, and author info, etc.) is a hassle unless you use the Mixtable spreadsheet tool, which is designed to simplify the management of your Shopify store. While it’s commonly used for tasks like exporting orders or inventory management, it can also be used to export blog posts.

This guide will walk you through the steps to set up Mixtable and use it to export your Shopify blog posts.

Use the Blogs and Blog Posts template

Step 1: Load the Blogs and Blog Post template

Once you open the Mixtable Excel and CSV Export application, you will see the pre-built workbook templates you can use. Choose the Blogs and Blog Posts one:

Blogs and blog posts spreadsheet template

The template contains the following columns:

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

Step 2: Add extra data columns if necessary

Use the Link button from the column header to add extra data to the spreadsheet:

Add additional data columns

Here, you can select additional data to include to the spreadsheet:

blog posts additional fields shopify spreadsheet

Note: Unlike for other data, Shopify API does not notify Mixtable when blog posts are created or updated in Shopify. So, if any blog posts have been created or updated via the Shopify admin interface, then they won’t automatically be download to your Mixtable worksheet. To sync the new/updated blog posts from Shopify to Mixtable please click the “Sync blog post data from Shopify” button that you can see when working with your blog posts worksheet.

Set up a blog posts worksheet

You can add blog posts as an additional worksheet if you already have a Mixtable workbook. Here are the steps to do this:

Step 1: Create a workbook (optional)

Before diving into worksheets, you’ll need to create a workbook that syncs data with your Shopify store. To do this, open Mixtable and click on the Add Workbook button. When you initially installed the Mixtable app from the Shopify App Store to your store, Mixtable started an initial download of your Shopify blog posts.

Sync Shopify blog posts to a Mixtable worksheet

Step 2: Create a new worksheet with blog posts

Once your workbook is set up, click the [+] button in the workbook toolbar to add a new worksheet. When prompted, select to create a worksheet that syncs your Shopify store’s blog posts. When the worksheet is created, it will have a set of default columns mapped to data, but feel free to add columns for any other blog post data you want. Mixtable will automatically populate these columns with the existing data from your Shopify store.

Note: Unlike for other Shopify data, Shopify does not notify Mixtable when blog posts are created or updated in Shopify. So, if any blog posts have been created or updated in Shopify, via the Shopify admin interface, then they won’t automatically download to your Mixtable worksheet. To sync the new/updated blog posts from Shopify to Mixtable please click the “Sync blog post data from Shopify” button that you can see when looking at your blog posts worksheet.

Step 3 (Optional): Configure a Conditional Worksheet

If you wish to export only specific blog posts or a range of posts, you can set up a Conditional Worksheet. This feature allows you to specify the criteria for the blog posts that should be included in the export.

Exporting Shopify blog posts

Step 1: Verify that you have the data you want

Before initiating the export process, ensure that all the data you wish to export is correctly populated in the worksheet. This includes the blog post title, content, tags, and any other metadata you want to include.

Step 2: Trigger an export to an Excel file (XLSX)

To start the export, click the Export menu option at the top of the screen to show the Export menu. From the dropdown menu, select the Export to Excel option. You will then be prompted to choose the location where you’d like to save the Excel file on your computer.

Step 3: Trigger an export to a CSV file

Alternatively, you can also export the data to a CSV file. To do this, select the Export to CSV option from the workbook Export menu. Just like with the Excel export, you’ll be prompted to choose a save location for the CSV file.

Export Shopify blog posts to Excel and CSV

Well done!

Mixtable Spreadsheet Editor is an Excel-like app that is built to sync data with Shopify. With it, you can bulk edit products, metafields, inventory, categories, and more. Find here:

Mixtable is an online spreadsheet, designed from the ground up to bulk edit and analyze Shopify data.

Got a question? We're here to help! Reach out at [email protected], and we'll get back to you promptly.