Exporting products

You can export your products to a CSV file if you want to create a backup, move your existing products to a new Shopify store, or edit your products in bulk using a spreadsheet. Any changes you make to the products in your product CSV file will appear in your store's product list if you import your product CSV file into your Shopify admin.

Tip

The easiest way to edit multiple products or product variants simultaneously is to use the bulk editor in your Shopify admin.

Overview

Learn more about how to export products from your Shopify admin:

Tip

If you want to see more educational videos and tutorials like this one, visit our video library.

Export your products

To export your products:

  1. From your Shopify admin, click Products.

    Tip

    If you only want to export some of your products, then you can filter your product list to view and select specific products for export.

  2. Click Export.

  3. From the dialog box, choose the products you want to export:

  4. Select which type of CSV file you want to export:

    • CSV file for Excel, Numbers, or another spreadsheet program. Use this format if you plan to use a spreadsheet program to edit your product CSV file.
    • Plain CSV file. Use this format if you plan to use a plain-text editor with your product CSV file.
  5. Click Export products.

    An email is sent to you containing a secure download link. Click the link to retrieve your product CSV file. Shopify recommends importing your CSV file into Google Sheets to view and edit a formatted version of it.

Caution

Sorting your CSV file in a spreadsheet program can cause product variants or image URLs to become disassociated. Importing a CSV file that has been sorted might overwrite your existing products with bad data, which cannot be recovered.

Use a text editor to edit your products CSV file

If you don't have a spreadsheet program, then you can edit CSV files using a text editor.

Caution

You should only use a text editor as a last resort, for example, if there are formatting errors in your CSV file and you cannot open it in a spreadsheet program.

Most computers have text editors that can open CSV files. You can also use a program like Atom or Sublime Text to edit and debug your CSV file.

Note

A CSV file with UTF-8 encoding is the only file format that can be used to import to or export from Shopify.

To format your CSV file in a text editor, you need to:

  • Column headers must be separated by commas (for example, First Name,Last Name,Email,Company,Address1).
  • The list of tags must be wrapped in quotation marks (for example, "tag1,tag2,tag3").
  • Different records must be separated by line breaks.

Filter and export your products list

You can use filters to organize your products list before exporting. If you need to change only some of your products, then you can add a filter. It could be easier to edit your products using a shortened CSV, rather than your entire product list.

To export a filtered product list to CSV:

  1. On the Products page in Shopify, add a filter using conditions to list only the necessary products.

  2. Export your products list, and make sure that you select the option to export only the products matching your search.

A CSV file containing only those products in your filtered list will export.

After you make any changes to your exported product CSV, you can import the CSV edited CSV file back to Shopify.

Want to discuss this page?

Visit the Shopify Community

Ready to start selling online with Shopify?

Try it free