Exporting Shopify products

Mixtable is the easiest way to export your Shopify products’ data to Excel, with the product data you want.

Sync the Shopify product data you want to export

• First, set up a worksheet that syncs data to your Shopify products or variants, depending on which data you want to export.

• You can map product data onto a variants worksheet and vice versa. As you add columns for the data you want, Mixtable will automatically populate them with any existing data. When this population is done, which should take a minute if you have a lot of data, you can trigger the export.

Note: The data in your Mixtable product/variant worksheets will keep itself up-to-date as changes are made in Shopify. So, if you want to export the same product/variant data in the future, with the latest data, you can skip straight to the export step.

Export Shopify product data to .xlsx

• Now open the workbook menu using the button on the very top-right of the screen. Select the Export to .xlsx option. You’ll be immediately prompted with the location where to save the Excel file on your computer. And that’s it!

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:

• How to export Shopify products with metafields
• How to export products with collections
• How to export pages into CSV or Excel
• How to export Shopify blog posts into CSV or Excel