Importing data from CSV files

Comma Separated Value (CSV) files are often used to export data from applications such as Excel and OpenOffice (see http://en.wikipedia.org/wiki/Comma-separated_values ). The format is rather poorly defined, however, with many different variants. The data can be read using CSV tab of the Data->Import dialog box:

import_csv.png

Veusz can read datasets in the column direction (by default) or in rows. If you read a file which is just a set of numbers, you will end up with datasets called "col1", "col2", etc. If you switch on reading by rows, they will be called "row1", "row2", etc.

If you want to read data and give the datasets particular names, or read data with error bars, you need to place dataset names at the top of columns. They should be by the left of rows if reading by rows. Multiple datasets can be placed below each other if new names are given. To import error bars on datasets, columns with the names +, - or +- should be given in columns immediately to the right of the dataset, for positive, negative or symmetric errors, respectively.

If you want to read in text use (text) after the name of the dataset in the top column, e.g. name (text). If you are using non-ASCII characters in your text you need to encode the text in your file with a Unicode encoding (e.g. UTF-8) and choose the correct encoding in the encoding drop down box.

Veusz also supports CSV files which don't use commas as separators. If you have a tab, space or pipe (|) separated file, select the correct delimiter from the list. You can also choose different text delimiters, if applicable.

CsvImport (last edited 2010-05-28 19:13:08 by JeremySanders)