Start Free Trial
Start Free Trial

How to export Shopify Metaobject Entries to Excel/CSV file

Featured Image - Exprot Shopify Metaobject Entries to Excel CSV Spreadsheet file

If you’ve been looking for a way to export Shopify Metaobject Entries from your Shopify Admin, you’ve probably noticed that Shopify doesn’t natively offer this functionality. But don’t worry, we’ve got you covered!
With the Matrixify app, you can easily export your Metaobject entries for analysis, backup, or sharing outside of Shopify.

Whether you’re a Shopify veteran or a newcomer, this tutorial will provide you with a simple, straightforward process to export your Metaobject entries to an Excel or CSV file. Let’s dive in!

Steps in short

  1. Create a new export in the Matrixify app.
  2. Configure the export to export Metaobjects to Excel or CSV file.
  3. Start the export and download the exported file.
  4. Understand the exported Shopify Metaobject Entries file.

1. Create a new Matrixify export

Start by opening the Matrixify app on your Shopify store.
Once you’re in the app, look for the “New Export” button and click on it.

This will open a new page where you can set up your export.

1. create new export in Matrixify app - Excel CSV bulk manage Shopify data

2. Configure your new export

Now you can start to configure the new export.

Choose an export format – Excel or CSV

Begin by choosing the format for your exported file. Click on the “Format” section to open a drop-down list of all available formats.
It is suggested to select and use the “Matrixify: Excel” format as it is a lot more user-friendly and easier to work with the data.
If you’re exporting a large amount of data or have other reasons why you specifically need CSV, you can select the “Matrixify: CSV” format.

You can read our Matrixify format documentation page for more details and differences between CSV and Excel formats.

2. create new export in Matrixify app - select Excel or CSV bulk manage Shopify data

Select to export Metaobject Entries

After selecting the format, proceed to choose the data you want to export. Click on the “Select Sheets” button and select the “Metaobjects” sheet.

3. create new export in Matrixify app - select to export Shopify Metaobject Entries Excel CSV bulk manage

Next, click on the entity sheet to open it. Here, you’ll see groups of fields that you can select to export.
Open the group to select individual columns/fields you wish to export.

The “Basic Columns” column group for Metaobjects sheet will include basic details about each Metaobject Entry, such as the entry ID, Handle, Created dates, what Metaobject definition the entry is linked to, and others.
You can think of this column group as the main Metaobject Entries page in Shopify with general details about each entry:

4. Shopify All Metaobject entries page - export CSV Excel Matrixify

The “Field Values” column group for Metaobjects sheet will include actual fields and their values for the entry.
The exported data from this column group would be the data you see in Shopify Admin for fields when you open specific Metaobject Entry:

5. Shopify Metaobject entries page - export CSV Excel Matrixify

Selecting only columns from the “Basic Columns” column group will ensure that one row per Metaobject Entry is exported.
But if you also have selected to export any column from the “Field Values” column group, then the exported file will have for each Metaobject Entry as many rows as you have fields in the definition linked to the Entry.

6. create new export in Matrixify app - select to export Shopify Metaobject Entries fields and columns Excel CSV bulk manage

Other export customizations and options

You can also open the “Customize Columns” section where you can change the exported column order.

In the “Options” section you can change various export-specific options, such as scheduling the export, setting it to repeat automatically, changing CSV file-specific options such as delimiters, and many other options.
Read our Matrixify Options documentation page to learn how individual Options work and how to use them correctly.

3. Run the export and download the file

Once you’ve configured your export, you can start the export job.

You can initiate the export process by simply clicking the “Export” button.
While the export is running, you can monitor the progress on the same page, and see job duration, estimated finishing time, and other details.

You are free to close the app page – the export is running on Matrixify servers and does not require for the app to remain open in the browser.
You can always come back to the export job by opening the app and locating this export from the Matrixify app Home page’s last 5 jobs or All Jobs page.

7. Export process in Matrixify app - select to export Shopify Metaobject Entries fields and columns Excel CSV bulk manage

Once the export is complete, a “Download Exported File” button will appear. Click on this button to download your file.
The file will be in the format you selected earlier (Excel or CSV) and will contain all the Metaobject Entries from your Shopify store.

4. Understanding exported Metaobject Entries file

Now you can open the exported file which contains all the Metaobject Entries you’ve exported.

The exported file is in two dimensions – columns representing different fields/attributes and rows representing Metaobject entry fields.
If you exported only columns from the “Basic Columns” column group, then you will have one row per Metaobject entry, but if you also selected at least one column from “Field Values” column group, then each row will be Metaobject Entry field and thus would have multiple rows per each Metaobject Entry.

In the example covered in this tutorial, there are 4 Metaobject Entries, each with 2 Metaobject Entry fields.
2 Metaobject Entries are linked to one Metaobject definition and 2 Metaobject entries are linked to another Metaobject definition.

Metaobject Entry fields use the same types as Shopify Metafields and thus export data in the same value structure.
You can see examples of how each field type value looks when exported in the Matrixify Metafields documentation.

That’s it! You’ve successfully learned how to export Shopify Metaobject Entries to a spreadsheet file using the Matrixify app.
Remember, you can always revisit this tutorial if you need a refresher.

If you have any questions or run into any issues, don’t hesitate to reach out to our support team.

Good to know