How to Export Products from Shopify (2026 Guide)

Open your browser and go to your-store.myshopify.com/admin. Sign in with your credentials. You need at least the Products permission on your staff account to access the product catalog and export functionality.

Click Products in the left-hand sidebar of your Shopify admin. This shows your complete product catalog. The Export button is in the upper-right area of the page, next to the Import button.

If you only need certain products, use the search bar and filters before exporting. You can filter by product status (active, draft, archived), vendor, product type, tags, or collection. You can also manually select products using the checkboxes next to each product name.

Tip: When exporting filtered results, make sure to select 'Products matching your search' in the export dialog, not 'Current page' which may only include a subset.

Click the Export button to open the export dialog. You will see options including: all products in your store, all products on the current page, products you have selected manually, or products matching your search and filter criteria. Choose the option that covers the products you need.

Under the format section, choose 'CSV for Excel, Numbers, or other spreadsheet programs' if you plan to edit the file in a spreadsheet. Choose 'Plain CSV file' if you are importing into another system. The spreadsheet-friendly format includes encoding that helps Excel display special characters correctly.

Click the 'Export products' button to generate the file. If your catalog has fewer than 50 products, the CSV downloads directly to your browser. For larger catalogs, Shopify processes the export in the background and emails a download link to the store owner's address. Large catalogs may take several minutes to process.

Open the CSV in your spreadsheet application. Each row represents one product variant, not one product. A t-shirt with three sizes will have three rows sharing the same Handle value. The first row of each Handle group contains the product-level information (Title, Body HTML, Vendor, Tags), while subsequent rows contain only variant-specific data (Option values, SKU, Price, Inventory).

Tip: The Handle column is the URL slug that groups variants together. When looking at the file, sort by Handle to see all variants of each product grouped together.

Warning: Product images are not included as actual files in the CSV. The 'Image Src' column contains URLs pointing to the images hosted on Shopify's CDN.