Android - How to Parse CSV file in Android with sample code for example?

You will get Final Output:

We are using Category.csv file in this example - you can follow the steps given below.

Screenshot of CSV file:

Step 1 Add .jar files

First we need to add following Jar file

• opencsv-2.3.jar

You can download this jar file from the following link:

• http://www.java2s.com/Code/Jar/o/Downloadopencsv23jar.htm

Step 2 CSVReader Class

Assume that Our CSV file contains two fields:

We can fetch these fields data using the following code:

String next[] = {};
List<string[]> list = new ArrayList<string[]>();
try {
    CSVReader reader = new CSVReader(new InputStreamReader(getAssets().open("test.csv")));//Specify asset file name
    //in open();
        for(;;) {
            next = reader.readNext();
            if(next != null) {
                list.add(next);
            } else {
                break;
            }
        }
    } catch (IOException e) {
        e.printStackTrace();
    }

Now If we want to fetch categoryId and categoryName fields than we can use the list as following:

list.get(row index)[column index]

i.e:

private ArrayList categoryList = new ArrayList();
    for (int i = 0; i < list.size(); i++) {
        categoryList.add(list.get(i)[1]);
    }

I hope you found this blog helpful Parse CSV file in Android. Let me know if you have any questions or concerns regarding  Parsing CSV file in Android, please put a comment here and we will get back to you ASAP.

Got an Idea of Android App Development? What are you still waiting for? Contact us now and see the Idea live soon. Our company has been named as one of the best Android App Development Company in India.

Tejas Jasani

An entrepreneur who has founded 2 flourishing software firms in 7 years, Tejas is keen to understand everything about gaming - from the business dynamics to awesome designs to gamer psychology. As the founder-CEO of a company that has released some very successful games, he knows a thing or two about gaming. He shares his knowledge through blogs and talks that he gets invited to.