to separate the cells. Text is entered in quotation marks, numbers are entered
without quotation marks.
Opening a CSV file
To open a CSV file in Calc:
1) Choose File > Open.
2) Locate the CSV file that you want to open.
3) If the file has a *.csv extension, select the file and click Open.
4) If the file has another extension (for example, *.txt), select the file, select Text
CSV (*csv;*txt;*xls) in the File type box (scroll down into the spreadsheet
section to find it) and then click Open.
5) On the Text Import dialog (Figure 93), select the Separator options to divide
the text in the file into columns.
You can preview the layout of the imported data at the bottom of the dialog.
Right-click a column in the preview to set the format or to hide the column.
If the CSV file uses a text delimiter character that is not in the Text delimiter
list, click in the box, and type the character.
6) Click OK to open the file.
Comentarios a estos manuales