Export Shopify Pages to CSV or Excel

To export your Shopify pages, use Mixtable Export: Excel & CSV. Create a Pages spreadsheet, choose the page fields you need, and download an Excel or CSV file.

Export your Shopify pages

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 Pages 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. Open the Pages worksheet and check the columns you want in the file, such as page title, handle, content, published status, and SEO fields. Add or remove columns as needed
4. Shopify doesn't send changes to pages 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 Pages.
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

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 page data to include

The Pages worksheet has a row for each Shopify page and starts with columns linked to page data. You can keep the fields you need, remove columns you do not need, or add fields before exporting. To add a field, 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 Shopify page field you want, such as Excerpt or SEO description, and click Save Column.

If you already have a Mixtable spreadsheet

You can add a Pages worksheet to an existing spreadsheet instead of creating a new one:

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 Pages. 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 Pages, so the file includes recent changes.

Export only certain pages

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

If a page 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 Pages, then choose Import & Export > Export to CSV when you want a single table of pages.

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