Any good library to read and write csv files?

Question

Possible Duplicate:
CSV API for Java
Can you recommend a Java library for reading (and possibly writing) CSV files?

I am wondering if there is a good library that supports reading and writing csv files?

@SamirMangroliya There is a lot of stuff out there. He is asking for an opinion. There is nothing wrong with that and it is a legitimate question. — MarianP, May 05 '12 at 14:46
@MarianP unfortunately (I had to learn and accept this too) asking for opinions or recommendations is not very welcome at SO: http://stackoverflow.com/help/dont-ask — Marged, Jun 17 '15 at 20:35

score 19 · Answer 1 · answered May 05 '12 at 13:54

19

answered May 05 '12 at 13:54

Francis Upton IV

2

Yup that one works. Only drawback (I found) is that it does not handle file encoding directly and I am unsure if there is a well-known csv-file encoding. – Guillaume Polet May 05 '12 at 14:02
1

The file encoding is really not dependent on CSV, it depends mainly on the environment/program where the file is written. So there is not a well established encoding. – Francis Upton IV May 05 '12 at 14:17

score 19 · Answer 2 · edited Oct 19 '17 at 11:13

19

There is also Super CSV, but I haven't tried it. http://super-csv.github.io/super-csv/

It is also not such a big deal to write something on your own IMO.

edited Oct 19 '17 at 11:13

Arnost Valicek

answered May 05 '12 at 13:56

MarianP

48

Well, there are a few cases with quotes and escaping, so it's a little more than meets the eye. – Francis Upton IV May 05 '12 at 14:01
16

It's usually a bad idea to write your own for something standard, especially when there's multiple libraries available. If you do write your own please take a look at the RFC: https://tools.ietf.org/html/rfc4180 – rhinoinrepose Dec 05 '16 at 21:24

score 8 · Answer 3 · answered May 05 '12 at 13:55

8

I would recommend to use opencsv

What is opencsv?

opencsv is a very simple csv (comma-separated values) parser library for Java.

answered May 05 '12 at 13:55

Pau Kiat Wee

3 Answers3