Export Shopify Pages

To export Shopify pages and/or blog posts, you need an app like Mixtable Spreadsheet Editor (Shopify does not provide this functionality).

Mixtable is a powerful spreadsheet tool that makes managing your Shopify store easier. One of its many features is exporting Shopify Pages to Excel or CSV files. This guide will walk you through the steps to set up Mixtable and use it to export your Shopify Pages.

Shopify Pages in a Spreadsheet

Step 1: Create a spreadsheet with Shopify Pages

After installing the Mixtable Spreadsheet Editor, open the app and choose Pages from the Create Spreadsheet section. This will create a spreadsheet that syncs Pages’ data with your Shopify store.

Step 2: Add Shopify Pages to an existing worksheet

In an existing Mixtable spreadsheet, click the (+) button to add a new worksheet.

When prompted, choose to create a worksheet that syncs your Shopify store’s Pages. The worksheet will be created with a set of default columns mapped to data. You can add columns for any other Page data you want to include.

Mixtable will automatically populate these columns with existing data from your Shopify store.

Note: Shopify does not notify Mixtable when Pages are created or updated. To sync new or updated Pages from Shopify to Mixtable, click the “Sync Page data from Shopify” button in your Pages worksheet.

Step 3 (Optional): Configure a Conditional Worksheet

If you want to export only specific Pages or a range of Pages, you can set up a Conditional Worksheet. This feature allows you to specify the criteria for the Pages that should be included in the worksheet you plan on exporting.

If a Page later stops matching the Conditional Worksheet criteria, its row may become empty. To clean up those empty rows before exporting, click the Worksheet menu and select Remove Empty Rows.

Export Shopify Pages in .XLSX or .CSV

Step 1: Verify that you have the data you want

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

Step 2: Export to an Excel file (XLSX)

To begin the export, click Import & Export in the top toolbar. From the dropdown menu, select Export to Excel. You will then be prompted to choose the location where you’d like to save the Excel file on your computer.

Step 3: Export to a CSV file

Alternatively, you can export the data to a CSV file. Select Export to CSV from the Import & Export menu to do this. Just like with the Excel export, you’ll be prompted to choose a save location for the CSV file.

Keep exploring your Shopify data

Mixtable Explore & Export puts supported Shopify data into an Excel-like spreadsheet that runs in your browser. Choose the fields you need, then export the full spreadsheet to Excel or the active worksheet to CSV.

• Compare all the main approaches in the Shopify to Excel guide
• Export Shopify products, collections, products with metafields, or products with collections
• Export Shopify orders or orders with metafields
• Export Shopify blog posts or Shopify pages

For data types that use manual downloads, refresh the relevant Shopify data before exporting so the file contains the latest available records.