Start Free Trial
Start Free Trial

Export Shopify store data to a spreadsheet with Matrixify

Learn more about Shopify data exports with the Matrixify app. How to create a new export, what various export user interface details mean, and where they are located.

Create a new Shopify data export

1. Create new Shopify data export with Matrixify app

You can create a new export by pressing the ‘New Export’ button in the Matrixify app’s home page.
By doing so, you will open a New Export page where you can configure, customize, and set up your Shopify data export.

Configure your Shopify data export

The New Export page in the Matrixify app consists of multiple sections – “Preset”, “Format”, “Sheets” and “Options”. Let’s dive into each New Export section and how to best use them.

Export Presets

3. Select save manage Shopify data export template preset options

At the very top of the New Export page, you can save your export setup as a preset.

To configure your export, select the sheets and columns you wish to export and save that setup to use later for manually repeating the same export job.
Note that you can also repeat jobs automatically by using export options.

There are two pre-defined Presets available in all stores:

  • “Latest Export” preset will copy the same setup you had in the last export done with the Matrixify app.
  • “New Blank Export” preset will not have any sheet or columns selected.

Choose an export format

4. Select Shopify data export template columns datafeed format

In the “Format” section you can click on the drop-down button to expand a list of all available export formats.

If your goal is to bulk update your Shopify store data or migrate to another Shopify store then you will need to select one of “Matrixify: …” formats.

We suggest using the “Matrixify: Excel” format which would export the Excel XLSX file. Excel files are a lot more stable than CSV files, allow simpler use of formulas, and are more user-friendly.

If your store is very large and any single sheet has more than 100,000 items then select “Matrixify: CSV” format to export to the CSV file.
Exporting CSV files is faster for large amounts of data and doesn’t run the risk of exceeding Excel’s limitations (~1,000,000 rows and ~16,000 columns among other limits).

You can also select various data feed formats for exports to other services, such as Google Shopping, eBay, and more.
Note that only Matrixify formats can be imported back into the Shopify store.

Configure sheets to export

Select Sheets – Select entities to export

3. Create Shopify data export select export sheets entities Matrixify app

In the “Sheets” section you can click on the “Select Sheets” dropdown button to select sheets for your export file.
You can also see the total count of items in this drop-down for each sheet entity, except Payouts and Files where Shopify does not provide us with the exact total item count.

You can select multiple entities at the same export!

After you have selected the sheets you wish to export you will have a card for each sheet in the “Sheets” section.
Click on the entity sheet card to expand it where you will be able to configure what data is exported in the specific sheet.

Select Columns – Choose columns to export

6. Shopify data export select individual exact columns fields to export Matrixify app

The first section in the sheet card is “Select Columns” where you can configure and change the columns that will be exported.

There are various column groups available for each sheet such as “Basic Columns”, “Metafields” and others.

Click and expand the column group to select individual columns/fields you wish to export.
You can find what fields are under each group in the Matrixify template sheets documentation.

Slow and Very Slow tags for column groups

Many of the column groups have a tag next to it “Slow” or “Very Slow” which indicates column groups that will require extra Shopify API calls making the export slower.
It is suggested to export only columns you need to make the export job faster.

Metafield column selector

Metafield columns within the Metafield column group have a pencil icon next to it and clicking it will allow to apply a selector for what Metafield columns should be exported in the form of column filters.
The app does not know what Metafields there will be without exporting the data so you can specify to export only Metafields with a specific namespace, key, and/or type.

Export duration estimate

When selecting different column groups you will see that the “Estimate” duration time will also change.
Estimates are very approximate at this point, because those are global averages – but a few minutes after the export has been started, those will get much more precise, because the estimate will be calculated based on the actual exported items on your specific data.

Customize Columns – Change how columns will be exported

7. Customize shopify data export columns sorting order selection Matrixify app

When expanding the “Customize Columns” section you can see a list of all the columns that will be exported.

In this section, you can drag columns to change their position in the export file, or press on the “X” button to remove the field.

Command columns have a pencil icon next to them in the Customize Columns section which you can use to change the exported value in those Command columns.
For example, to change for the Tags Command to be exported as REPLACE instead of the default MERGE.
You can also adjust the Command column values manually in the exported file. This feature is great when setting up automated synchronization between Shopify stores.

You cannot change the position of the Metafield columns. The app does not know what Metafields will exist for each product and they are always added dynamically to the very end of the file.

Check out this tutorial for more details on advanced exporting – Export Data from Shopify with custom columns.

Set Filters – specify what data to export in the sheet

8. Filter Shopify data export Matrixify app

To focus on a specific list of items, use the Filters.

Click on the Filter button to select and apply filters to the exported sheet.
Select the filter of your choice for your items and press the “Add” button to apply the filter to your next export.

If the filter has been applied, you will see the applied filter listed in the Set Filters section.

Do note – the Estimate count will not change when you set the filters, because at this stage the app does not yet know how many items will match your filters – it will be clear only when the export job has finished.

Options

9. Customize export Matrixify app export options Shopify data

In the “Options” section of the export job, you can specify additional details on how the export is processed, for example, schedule the export to run at specific date and time, set the export to repeat automatically, change the exported files name and many more.

Export progress

After starting the export in the Matrixify app, you can follow the export progress.
You can see how long the export has been running, the estimated remaining duration, and exported item counts.

Exported Item Count

10. Shopify data export progress details exported item count

While the export is running you can see exactly how many items have been exported and how far the app is in the export process from all items.
This comes in handy when you are applying multiple filters to your export to see how many items exactly will be in your file.

Now, let’s decode these numbers:

  • Exported (filtered) item count – Displays how many items are exported to the file. If using filters then you might see that the Exported item count is lower than the Processed item count as the app is not exporting items that do not match the applied filters.
  • Processed item count – Displays how far the app is between all items. Some filters might provide the ability for the app to disregard a lot of items in bulk, so you might see the processed count jump at the start.
  • Total item count – This number will display the total count of the items you have in the store for that specific entity.

Exported spreadsheet file

Download exported file

11. Download Shopify data export spreasheet Excel CSV file Matrixify app

Once your export has finished, click on the “Download Exported File” button to download your file.

You can also open any historic export job and download its files so there is no need to download it immediately after the export, it will not be lost.

Inspect the exported file

12. Shopify data exported Excel XLSX CSV file multiple tabs sheets

If the export job had multiple entity sheets selected then the exported file will also contain multiple sheets.

If exporting to the “Matrixify: Excel” format for the XLSX file, you will see multiple sheets/tabs in the same file, one for each sheet.
If exporting to the “Matrixify: CSV” format, by default the app will compress multiple CSV files in a single ZIP file.

In the Excel format, the exported files column headers will be color-coded with each column group having a different column making it easier to view the file, for example, see which columns are Basic columns, Media columns, Variant columns, etc.

Export will also contain an “Export Summary” sheet where you can see general details about the export job as a summary of what you can see in the Matrixify app.
If you need to locate an export job based on the file you have exported previously, in the Export Summary sheet you can see the export job ID and search for it in the Matrixify All Jobs page.