CSV files are flat files with data delimited by comma. On Windows we are provided with the ability to open it in Microsoft Excel and hence it appears to have three sheets.
If you wish to export the data in a single CSV file but on different sheets it will not be possible. Simple reason being that CSV is not XLSX.
Interfacing applications will be requiring a single flat file for reading data.