Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Opening CSV files

Comma separated values (CSV) files are text files that contain the cell contents of a single sheet. Each line in a CSV file represents a row in a spreadsheet. Commas, semicolons, or other characters are used to separate the cells. Text is put in quotation marks, numbers are written without quotation marks.

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 in the File type box (scroll down into the spreadsheet section to find it) and then click Open.
  5. On the Text Import dialog, 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.
ext Import dialog, with Comma selected as the separator and double quotation mark (“) as the text delimiter.
Image:documentation_caution.png If you do not select Text CSV as the file type when opening the file, the document opens in Writer, not Calc.

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire