Go to the folder page and find the "Actions" drop-down list. Click on "Export to CSV".
Select the fields that you would like to include in the CSV and click "Export to CSV".
The file will include all the fields that you have selected. Here is the guide that can help you split text into different columns.