How to create one single CSV report instead of separate CSV files for each table?
Adjust your report save settings by unchecking "Seperate CSV Files for each Table"
To generate a full CSV report, select Settings>Save>Table to CSV.
Then deselect Separate CSV Files for each Table.
For more information on saving reports, please visit our Saving Reports help article.