Calc Guide

Tip
To have Calc save documents by default in a Microsoft Excel
file format, go to Tools > Options > Load/Save > General.
In the section named Default file format and ODF settings,
under Document type, select Spreadsheet, then under Always
save as, select your preferred file format.
Saving as a CSV file
To save a spreadsheet as a comma separate value (CSV) file:
1) Choose File > Save As.
2) In the File name box, type a name for the file.
3) In the File type list, select Text CSV (*.csv;*.txt;*.xls) and click
Save.
You may see the message box shown below. Click Keep Current
Format.
4) In the Export of text files dialog (Figure 9), select the options you
want and then click OK.
Figure 9: Choosing options when exporting to Text CSV
22 OpenOffice.org 3.x Calc Guide