Back ArrowExplore all topics

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

share link

by Abdul Rawoof A R dot icon Updated: Feb 3, 2023

technology logo
technology logo

Solution Kit Solution Kit  

An ordered list of values is called a JSON array. It can store multiple values, strings, numbers, booleans, or objects in a JSON array. A comma must separate the values in the JSON array. A normal text file or stored data in column by column and split by a comma is called a CSV(comma-separated values).


Now will see the procedure to convert the JSON array to CSV,

  • Read the data from the JSON file and store the result as a string.
  • Construct a JSON object using the above string.
  • Get the JSON Array from the JSON Object.
  • Create a new CSV file using java. io. File.
  • Deliver a comma-delimited text from the JSONArray of JSONObjects and write it to the newly created CSV file.


The JSON can be used as a 'data-interchange format' and it is 'lightweight' and 'language independent'. It can parse text from a string to produce vector-like objects. The advantage of using JSON for data storage, it is safe for transferring the data and suitable across platforms. To store the data comparatively JSON is preferred better than CSV In terms of scalability of application or file and while working with a large volume of data. The most common usage of JSON is used in JavaScript-based applications that have browser extensions and websites as a part of their features.


Here is an example of how you can convert JSON array to CSV in Java:

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

Code

Json Array List to CSV format

JavadotLines of Code : 18dotLicense : Strong Copyleft (CC BY-SA 4.0)

Dependent Libraries : 
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

  1. Copy the code using the "Copy" button above, and paste it in a Java file in your IDE.
  2. Add the required dependencies and import them in java file.
  3. 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.

  1. The solution is created in Java 11.0.17.
  2. 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.

Dependent Libraries

commons-ioby apache

Java doticonstar image 913 doticonVersion:Currentdoticon
License: Permissive (Apache-2.0)

Apache Commons IO

Support
    Quality
      Security
        License
          Reuse

            commons-ioby apache

            Java doticon star image 913 doticonVersion:Currentdoticon License: Permissive (Apache-2.0)

            Apache Commons IO
            Support
              Quality
                Security
                  License
                    Reuse

                      JSON-javaby stleary

                      Java doticonstar image 4285 doticonVersion:20230227doticon
                      License: Others (Non-SPDX)

                      A reference implementation of a JSON package in Java.

                      Support
                        Quality
                          Security
                            License
                              Reuse

                                JSON-javaby stleary

                                Java doticon star image 4285 doticonVersion:20230227doticon License: Others (Non-SPDX)

                                A reference implementation of a JSON package in Java.
                                Support
                                  Quality
                                    Security
                                      License
                                        Reuse

                                          You can add the dependent library in your gradle or maven files. you can get the dependancy xml in above link

                                          You can search for any dependent library on kandi like apache commons io and json java

                                          Support

                                          1. For any support on kandi solution kits, please use the chat
                                          2. For further learning resources, visit the Open Weaver Community learning page.

                                          See similar Kits and Libraries

                                          Open Weaver – Develop Applications Faster with Open Source

                                          kandi

                                          Community and Support

                                          Company

                                          Follow

                                          • © 2023 Open Weaver Inc.