Export Shopify data to Excel or CSV

This article covers the download itself: how to set up a worksheet, pick your columns, and save the file. For a wider look at the options for getting Shopify data into Excel, Google Sheets, or a BI tool, see Shopify to Excel.

Shopify admin does not export .xlsx files. It exports CSV, and only for certain record types. Excel opens a CSV, but you lose formatting, multiple worksheets, and any field Shopify left out of its fixed column list.

Step 1: Start with a spreadsheet template

After you install the Mixtable Spreadsheet Editor you can build your own spreadsheet from scratch, but the easiest way to start is with one of our pre-made templates. In this example we want to export our product information. So we’ll start with the Full Product Info template. To use it click on Create Spreadsheet and select it from the template list. Mixtable will create the spreadsheet and automatically populate it with your Shopify store product data.

Note: Export to Excel and CSV are included in the free Mixtable app plan.

Step 2: Customize the data you wish to export

Add / Delete columns

The templates are loaded with columns for the information that our users use the most. You can customize the columns in your worksheet to suit your needs, by adding and removing them.

To load new Shopify data, start by selecting an empty column, meaning any column with a non-green header. A green header means the column is already linked to Shopify data. Then click the button in the column header to open the selection window and choose the data you want to pull in.

You can choose to add a variety of Shopify data, from Shopify data fields to metafields, inventory, and related data columns. If you have our Mixtable Analytics app installed you can also add columns that show analytical information for your products and store.

Add more Shopify worksheets

You can also add other worksheets with a different dataset, such as Orders (no line items) or Customers. With Mixtable export to Excel, you will get a single .xlsx file containing all worksheets in your spreadsheet, and the data will be kept up to date for future exports.

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

Choose from a list of existing sheets or build a custom one.

Step 3: Export to an Excel .xlsx file

Once the spreadsheet is set up, click Import & Export in the top toolbar and choose the Export to Excel option. A prompt will then guide you to select a save location for your file.

Your raw values, formulas, images, and formatting are all retained in the transition from Mixtable to Excel, and every worksheet in the spreadsheet lands in the same file.

Export a single worksheet to CSV instead

CSV files cannot hold multiple tabs, so a CSV export covers the worksheet you are currently on. To export a complete spreadsheet as CSV, export each worksheet separately.

1. Click Import & Export in the top toolbar
2. Choose the Export to CSV option
3. A prompt will then guide you to select a save location for your file

Export guides for specific Shopify data

The steps above work for any worksheet. These articles cover the details for each record type:

• Export Shopify products
• Export Shopify collections
• Export Shopify products with collections
• Export Shopify products with metafields
• Export Shopify orders and line items
• Export Shopify order metafields
• Export Shopify customers
• Export Shopify blog posts
• Export Shopify pages
• Export Shopify refunds

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.