To do this we advise to use one of the custom reports and export this to excel where you can save this as a CSV file.
You can do this in Reporting > Reports > Students tab > Custom report:
This one will give you basic information. Once you have selected the items to include and run the report use the yellow export icon in the top right to download the report to excel.
If you need more information you can use the other custom report in Reporting > Custom report:
Then click on new report and select the items to include. Once the report is run you can use the export icon in the top right.
Once you have the report in excel you can click to save as and select file type CSV.