CSV : Java Glossary

2008-05-08 by Roedy Green ©1996-2009 Canadian Mind Products
index page for letter ⇒ punctuation 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z (all)

CSV

comma separated value. A file of ASCII fields separated by commas. Microsoft Word, Microsoft Excel, and SQL can often import some variant on this format.

apple,"wild cherry",peach
pear,plum,"apricot"
mango,payaya,guava
"orange, Valencia",  lemon, lime
"""extra virgin"" olive", palm, date

Usually fields containing embedded spaces or commas are contained in " marks, but there are other conventions. Quotes (") inside quoted fields are doubled. Europeans often use ; and Perl aficionados use tab to separate fields instead of commas. Sybase SQL import uses ' instead of ".

I wrote CSVReader and CSVWriter which are available with Java source. They are full featured, configurable except for handling comments.

For simple key=value you might use the built-in Properties mechanism instead. Unfortunately, it has a complex system of encoding awkward characters incompatible with CSV.

Creativyst csv
CSV Objects
CSV Reader in C#
CSV-JDBC
CSVReader in Java
CSVReader.com
DataPipeline
H2 csv
JSefa csv
Open CSV
Ricebridge

	Please email your feedback for publication, errors, omissions, broken/redirected link reports and suggestions to improve this page to Roedy Green :
	Canadian Mind Products
	mindprod.com IP:[65.110.21.43]
	Your face IP:[38.103.63.62]
	You are visitor number 26,644.
	You can get a fresh copy of this page from:	or possibly from your local J: drive (Java virtual drive/mindprod.com website mirror)
	http://mindprod.com/jgloss/csv.html	J:\mindprod\jgloss\csv.html