Operation Manual

Opening a CSV file
Comma-separated-values (CSV) files are spreadsheet files in a text format where cell contents are
separated by a character, for example a comma or semicolon. Each line in a CSV text file
represents a row in a spreadsheet. Text is entered between quotation marks; numbers are entered
without quotation marks.
Tip
Most CSV files come from databases tables, queries, or reports, where further
calculations and charting are required. On Microsoft Windows, CSV files often have the
XLS file name extension to look like an Excel file, but they are still CSV files internally.
To open a CSV file in Calc:
1) Choose File > Open on the Menu bar and locate the CSV file that you want to open.
2) Select the file and click Open. By default, a CSV file has the extension .csv. However,
some CSV files may have a .txt extension.
3) The Text Import dialog (Figure 95) opens. Here you can select the various options
available when importing a CSV file into a Calc spreadsheet.
4) Click OK to open and import the file.
Figure 95: Text Import dialog
Chapter 5 Getting Started with Calc | 121