Converting an CSV file to a JSON object in Java

Question

Is there an open source java library to convert a CSV (or XLS) file to a JSON object? I tried using json.cdl (http://bethecoder.com/applications/tutorials/json/json-java/csv-to-jsonarray.html) but somehow it does not seem to work for large CSS strings. I'm trying to find something like http://www.cparker15.com/code/utilities/csv-to-json/, but written in java. Any help is appreciated. Thanks!

possibly not an exact duplicate since it asks specifically for a Java solution.

Mouscellaneous · Answer 1 · 2012-03-01 21:24:17Z

up vote 1 down vote

You can use Open CSV to map CSV to a Java Bean, and then use JAXB to convert the Java Bean into a JSON object.

answered Mar 1 '12 at 21:24

Mouscellaneous
430313

add comment (requires an account with 50 reputation)

DNA · Answer 2 · 2012-03-01 21:27:11Z

If your CSV is simple, then this is easy to write by hand - but CSV can include nasty edge cases with quoting, missing values, etc.

load the file using BufferedReader.readLine()
use String.split(",") to get the value from each line
write each value to the output using BufferedWriter
- with the necessary JSON braces and quoting

You might want to use a CSV library, then convert to JSON 'by hand'

2 Answers