Magento Tutorials

How to Export Products to CSV in Magento 2

This guide will walk you through how to export products into CSV file in Magento 2.

Step 1: Log into your Magento backend. Go to System > Data Transfer > Export

magento export products csv

Step 2: In Export Settings page, select Products under Entity Type.

Magento export settings

Step 3: Check the boxes on which attributes you want to exclude from your CSV. Then, click Continue.

entity attributes 1

entity attributes 2

After export succeeds, you will get a .csv file of all your products. You can use this file to import the products into other Magento 2 sites.

Related post: How to Export Orders to CSV in Magento 1 & 2

A knowledge craver who always strive to be wiser everyday.

avatar
4 Comment threads
1 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
5 Comment authors
AdamYogeshMikeysaeedMake Vana Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Make Vana
Guest

Good one, nice clear and easy instructions. It really helped to export the products and import into our new store.

saeed
Guest
saeed

how can i customize this export ?

Adam
Guest
Adam

The default does not allow much customization. If you want to exclude out of stock products from the list, manage product visibility according to product types, customer groups or would like to export in PDF or XLS file, this extension will help you.

Mikey
Guest

Thanks for the easy guide! Switching over to Magento 2 has thrown me off in all kinds of ways, much appreciated!

Yogesh
Guest

not able to export custom product attributes created by me kindly guide