How to export/download product list/catalogue from my Magento store?
Go to the Magento administrator area and
Choose System -> Import/Export -> Dataflow – Profiles -> Import All Products.
Select the required settings in the Profile Wizard tab:
Then choose Upload file tab and browse for the .csv file on your computer.
Video Source: LevelUpTuts (Youtube Channel)