There are two ways to create a CSV file from a report, this is usually to import or send the file where it is imported into third party software.
After creating the report, on the ‘Default output’ screen at the end of the report, select the Text option under Presentation, in the Format box selected Comma Separated.
Click the Browse button and find a location that you want to save the file, name the file in the format of test.csv and the screen should look like as below.
Click the Run button at the top of the screen and the file will now be created in the location you have specified.
Output the report to Excel, click the Run button. After Excel loads, go to File > Save as and choose CSV from the file type list and save to a location of your choice.