Convert json array to CSV using Apache common-io in Java

by Abdul Rawoof A R Updated: Jan 24, 2023

Java has many libraries which provide the ability to work with CSV files. This solution gives a hassle-free ready to go code template to read json list using JSONArray in Java which can be executed straight in the IDE. Add required dependent library in your Gradle or Maven files and we suggest you to use the same versions of libraries which we used.

Fig 1: Preview of the output that you will get on running this code from your IDE

Code

Json Array List to CSV format

JavaLines of Code : 18License : CC BY-SA 4.0

public static void main(String[] args) throws IOException {
    String inputJson = "{Results: [\n" +
            " {\"Item\":1,\"Status\":\"Approved\",\"Name\":\"Brownie\",\"SubmitDate\":\"2016-04-05T14:06:16Z\",\"ReceivedState\":1},\n" +
            " {\"Item\":3,\"Status\":\"Approved\",\"Name\":\"Oats\",\"SubmitDate\":\"2016-04-19T19:39:25Z\",\"ReceivedState\":1},\n" +
            " {\"Item\":2,\"Status\":\"Submitted\",\"Name\":\"Choclate\",\"SubmitDate\":\"2016-06-01T12:40:19Z\",\"ReceivedState\":1},\n" +
            " ]}";
    JSONObject jsonObj = new JSONObject(inputJson);
    JSONArray objJsonArray = jsonObj.getJSONArray("Results");
    String csv = CDL.toString(objJsonArray);
    System.out.println(csv);
    FileUtils.writeStringToFile(new File(System.getenv("HOME")+ "/temp.csv"), csv);
}

Status,Item,SubmitDate,ReceivedState,Name
Approved,1,2016-04-05T14:06:16Z,1,Brownie
Approved,3,2016-04-19T19:39:25Z,1,Oats
Submitted,2,2016-06-01T12:40:19Z,1,Choclate

Instructions

Copy the code using the "Copy" button above, and paste it in a Java file in your IDE.
Add the required dependencies and import them in java file.
Run the file to generate the output csv file.

I hope you found this useful. I have added the link to dependent libraries, version information in the following sections.

I found this code snippet by searching for 'json array list to csv format' in kandi. You can try any such use case!

Environment Tested

I tested this solution in the following versions. Be mindful of changes when working with other versions.

The solution is created in Java 11.0.17.
The solution is tested on JSON Version:20210307 and apache.commons:commons-io:1.3.2.

Using this solution, we are able to convert an json array to csv with simple steps. This process also facilities an easy way to use, hassle-free method to create a hands-on working version of code which would help us to convert an json array to csv.