Magento Tutorials

How to Export Products to CSV in Magento 2

magento-2-export-products-csv

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

5 Comments

Dom

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