Saving as a CSV file
To save a spreadsheet as a comma separate value (CSV) file:
- Choose File > Save As.
- In the File name box, type a name for the file.
- In the File type list, select Text CSV and click Save.
You may see the message box shown below. Click Keep Current Format.
- In the Export of text files dialog, select the options you want. Click OK.
Choosing options when exporting to Text CSV