Converting csv row to JSON object in Java

Question

I've a csv file something similar to this

"name.firstName","name.givenName","name.DisplayName","phone.type","phone.value"
"john","maverick","John Maverick","mobile","123-123-123"
"jim","lasher","Jim Lasher","mobile","123-123-123"

I want to convert the 2nd and 3rd row into JSON objects.Using the first row as Header. So the result will be

[
{  
"name": {
    "firstName": "john",
    "givenName": "maverick",
    "DisplayName": "John Maverick"
},
"phone": {
    "type": "mobile",
    "value": "123-123-123"
}
},
{
"name": {
    "firstName": "john",
    "givenName": "maverick",
    "DisplayName": "John Maverick"
},
"phone": {
    "type": "mobile",
    "value": "123-123-123"
}
]

Any idea how to achieve this?

Create the Array and Map objects that represent the structure, then serialize them into JSON. — Hot Licks
– Hot Licks, Commented Mar 22, 2013 at 21:57

Community · Accepted Answer · 2017-05-23 11:58:13Z

2

Here is a Java library that may help you. http://www.jonathanhfisher.co.uk/playpen/csv2json/index.htm

Here is a JavaScript library that may or may not be useful to you. http://www.cparker15.com/code/utilities/csv-to-json/

And finally, here is a past answer that may be useful. I like the OpenCSV solution. However, instead of JAXB, you could use Jackson. Converting an CSV file to a JSON object in Java

edited May 23, 2017 at 11:58

CommunityBot

11 silver badge

answered Mar 22, 2013 at 22:03

Rob Breidecker

6141 gold badge7 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

R Syed Over a year ago

Thanks for the answer, in this third solution, the example code which is used is ColumnPositionMappingStrategy strat = new ColumnPositionMappingStrategy(); strat.setType(YourOrderBean.class); String[] columns = new String[] {"name", "orderNumber", "id"}; // the fields to bind do in your JavaBean strat.setColumnMapping(columns); CsvToBean csv = new CsvToBean(); List list = csv.parse(strat, yourReader); what exactly is yourReader here, and how do I input values to bind with bean? Thanks

Rob Breidecker Over a year ago

I believe the yourReader is the inputFileReader.

R Syed Over a year ago

yeah got it thanks, also is there any documentation for using Jackson to covert javaBean to JSON? Thanks again.

Rob Breidecker Over a year ago

This looks like a nice tutorial, but I haven't had a chance to go through it yet. mkyong.com/java/how-to-convert-java-object-to-from-json-jackson

Rob Breidecker Over a year ago

If my answer was helpful, can you up vote it and/or select it as the correct answer? Thanks!

|

Collectives™ on Stack Overflow

Converting csv row to JSON object in Java

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related