Export Shopify Pages

Mixtable is a powerful spreadsheet tool designed to make managing your Shopify store easier. One of its many features is the ability to export 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.

Setting up a Pages worksheet

Step 1: Create a workbook

First, open Mixtable and click on the “Add Workbook” button. This will create a workbook that syncs data with your Shopify store. If you’ve already installed the Mixtable app from the Shopify App Store, Mixtable will have initiated a download of your Shopify Pages.

Step 2: Create a new Pages worksheet

After your workbook is set up, click the [+] button in the workbook toolbar 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 additional 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.

Optional Step 3: Configure worksheet sync filter

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

Exporting Shopify Pages

Step 1: Verify that you have the data you want

Before starting the export process, make sure 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: Trigger an export to an Excel file (XLSX)

To begin the export, click the “Export” menu option at the top of the screen. 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: Trigger an export to a CSV file

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