Export Shopify Collections to Excel or CSV

Use Mixtable Export: Excel & CSV to download your Shopify collections as an Excel or CSV file. You can export collection titles, handles, Shopify IDs, collection types, metafields, sales-channel fields, product counts, and other collection data without building a Shopify CSV by hand.

This guide exports the collections themselves, with one row per Shopify collection. If you instead need one row per product showing the manual collections it belongs to, see export Shopify products with collections.

Step 1: Create a Collections spreadsheet

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 dashboard's suggestions instead. In the Create spreadsheet window, find Collections under Organization, 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. Wait while Mixtable loads the collection data from Shopify

If more than one Shopify store is connected, choose the store you want to export at the top of the Create spreadsheet window before you click the template.

The template creates two worksheets:

• Collections contains one row per manual or automated Shopify collection
• Product Collections contains one row per product and shows its manual collection memberships

Select the Collections worksheet when you want a list of collection records.

Step 2: Choose the collection fields to export

The Collections worksheet starts with useful identifiers such as Title, Handle, Shopify ID, and Collection Type. Depending on your store, the template can also include collection metafields and sales-channel columns.

You can add other collection fields before exporting:

1. 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
2. Type the field’s name in the search box, or click a section on the left, such as Title & description or Products in the collection
3. Click a field such as Description, Last updated, Sort order, Number of products, or Theme template. The panel on the right explains the field and shows an example from your worksheet
4. Click Save Column

Repeat these steps for every field you want in the export. You can remove unneeded columns, drag columns into a different order, and sort the worksheet before downloading it.

Step 3: Export all collection worksheets to Excel

Choose Excel when you want both collection worksheets in one file or want to keep spreadsheet formatting and multiple tabs.

1. Click Import & Export in the menu bar
2. Select Export to Excel
3. Save the .xlsx file when your browser asks where to download it

Excel export downloads the entire Mixtable spreadsheet. The resulting file therefore includes both Collections and Product Collections, along with any other worksheets you added.

Step 4: Export one Collections worksheet to CSV

Choose CSV when another system expects a plain, single-table file.

1. Select the Collections worksheet
2. Click Import & Export
3. Select Export to CSV
4. Save the downloaded .csv file

A CSV can contain only one worksheet. Mixtable therefore exports whichever worksheet is active when you select Export to CSV. To export Product Collections separately, select that worksheet and repeat the process.

Export products and their collection memberships

The Product Collections worksheet answers a different question: which products belong to which manual collections?

It includes product titles and handles, plus a Product’s Manual Collections column. It also carries Add to Collections and Remove from Collections columns, which are editing tools rather than export data, so you can ignore them when you only want a file.

You can export that worksheet to CSV by selecting it before choosing Export to CSV, or include it alongside the collection list by exporting the full spreadsheet to Excel.

Automated collection membership is controlled by Shopify conditions. The product-membership worksheet lists manual collections, not the results of every automated collection rule.

For a detailed product-level workflow, see export Shopify products with collections.

Common questions

Does the export include manual and automated Shopify collections?

Yes. The Collections worksheet can show both types. Add or keep the Collection Type column so the exported file identifies each collection as manual or smart.

Can I export Shopify collection metafields?

Yes. The Collections template can add collection metafield columns beside the standard collection fields. Keep the metafields you need and remove the others before exporting.

Can I open the export in Google Sheets?

Yes. Export the spreadsheet to Excel or export the active worksheet to CSV, then upload that file to Google Sheets.

Does CSV export include both Collections worksheets?

No. CSV export downloads only the active worksheet. Use Excel export when you want multiple worksheets in one file.

For a broader comparison of Shopify export methods and file formats, see Shopify to Excel.