Skip to content
DataEase
Try for free

How to Export Data from Shopify to CSV or Excel

Shopify’s built-in CSV export covers only a handful of data types and fixed columns. With DataEase you can export data from Shopify for 20+ data types to Excel or CSV, choose exactly which fields become columns, filter the rows, and automate the export on a schedule.

Follow this step-by-step guide to get started.

What data can I export from Shopify?

Section titled “What data can I export from Shopify?”

DataEase exports every Shopify data type it can import, so an export file can be edited and imported back:

Recently added: the inventory locations filter and filters by metafields.

Several entities can go into one Excel file — each one on its own worksheet.

1. Choose Export Format

Section titled “1. Choose Export Format”

DataEase supports two file formats:

  • Excel (.xlsx) - great for working with multiple entities. Each entity will go on its own worksheet.
  • CSV (.csv) - best for working with large datasets and system integrations.

Tip: Excel files have limits - 1,048,576 rows, 16,384 columns, and 32,767 characters per cell. If you’re exporting long descriptions (like HTML), some content may get cut off. For large exports, use CSV instead.

2. Select Entities and Fields

Section titled “2. Select Entities and Fields”

Next, choose the entities you want to export, like Products, Customers, or Orders.

  • Each entity becomes a separate sheet in Excel.
  • Each field becomes a column.

You can also:

  • Customize field names in the export by clicking the ✏️ icon.
  • Create presets to save frequently used export setups.
  • Use filters to limit the data. For example, filter by id, title, or handle to export only what you need.
  • Filter by metafields only when filtering is enabled for the metafield definition in Shopify admin (Settings → Custom data). Shopify rejects other metafield conditions, so DataEase removes them and shows a warning on the export page (they had no effect before either). If such a condition is combined with OR or placed inside a group (for example NOT), it can’t be removed safely: the export stops with an explanation until you change the filter.

Example: You want to export only products tagged “summer”. Use the Tag filter to include only those.

3. Configure Export Options

Section titled “3. Configure Export Options”

In the Export Options section, you can:

  • Schedule your export for later
  • Choose where to save the file (FTP, server, or local)
  • Set a file name template
  • For Products: enable media grouping to place all image URLs in one column, separated by a semicolon.

4. Run the Export

Section titled “4. Run the Export”

Click Run Export to start the task.

You’ll be taken to the export progress screen, where you can:

  • See a progress bar
  • Watch the log for task updates

Once the export finishes, the status will show Completed.

5. Download the Export File

Section titled “5. Download the Export File”

Click Download Result File to get your export. If you enabled link access, you can also copy the download link using the 📋 button next to it.

6. Re-run the Export

Section titled “6. Re-run the Export”

Need to run the export again with the same settings?
Use the Re-run button on the task page to repeat it without setting everything up again.

Automate Shopify data exports

Section titled “Automate Shopify data exports”

To export Shopify data automatically — for example, orders every morning for your ERP or a nightly product backup:

By following these steps, you can easily export exactly the data you need from Shopify using DataEase-on your schedule, in your format.

How-to guides

Products

Inventory & prices

Orders & customers