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.
Learn more about how to export products from your Shopify admin:
If you want to see more educational videos and tutorials like this one, visit our video library.
Export your products
To export your products:
From your Shopify admin, go to Products.
From the dialog box, choose the products you want to export:
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.
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.
Access your product image files
If you move your products to a new website with plans to close your current store or delete some of its product listings, then you need to upload your product CSV file to your new store while your old store and its product listings remain viewable.
When you export your products, the images associated with each product will not be included in the CSV file. If you import the products to a new store, then the product images will generate only if they remain viewable on a publicly accessible website.
To ensure that your product images remain accessible to you, leave your original store and its products intact until you finish the import process. This will allow your new store to assign the correct product image to each listing.
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.
To format your CSV file in a text editor:
- 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,
- 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:
On the Products page in Shopify, add a filter using conditions to list only the necessary products.
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.