From your Inventory page, click on Bulk Manage > select Update Existing Products > Click on No, I need to download a list of my products > Select all Sales Channels within Sales Channels. Click on Build Product Sheet and Download Product Sheet. This will download a CSV file of all your products. Products that are set as TRUE are published where as products that are set as FALSE are not published. Click here to for more information.