Question: how to export data from excel in csv format?
Answer: Open an Excel document.
In Excel top menu go to File → Save as.
Type the file name into the Save As field.
Set File Format as Comma Separated Values (. csv).
Click Save.