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
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

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

  




 

 

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