If you export up to one page of products (up to 50 products), then the CSV file is downloaded by your browser. If you export more than one page of products (51 or more products), then the CSV file is emailed to you. If you aren't the store owner, then the file is sent to the store owner's email as well.
Steps
From your Shopify admin, go to Products.
If you want to export only some of your products, then you can filter your product list to view and select specific products for export.
Click Export.
From the dialog box, choose the products that you want to export:
The current page of products
All products
Products you have selected
Products that match your search and filters.
Select which type of CSV file you want to export:
CSV file for Excel, Numbers, or another spreadsheet program. Use this format if you plan to use a spreadsheet program to edit 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.