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.