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.
The easiest way to edit multiple products or product variants simultaneously is to use the bulk editor in your Shopify admin.
Learn more about how to export products from your Shopify admin:
Export your products
To export your products:
From your Shopify admin, click Products (or press
If there are specific products you want to export, then you can search and filter products to select many products for export, and click the checkboxes to make your selections.
From the dialog box, choose the products you want to export:
Select which type of CSV file you would like:
- CSV file for Excel, Numbers, or another spreadsheet program. Use this format if you plan to use a spreadsheet program with 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.
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.
If you don't have a spreadsheet program, you can edit CSV files using a text editor.
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.
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 Products CSV file in a text editor:
- Column headers must be separated by commas (for example,
- The list of tags must be wrapped in quotation marks (for example,
- Different product records must be separated by line breaks.