How to parse the CSV file in android application?

Question

I have a CSV file in drawable/asset folder. In the CSV file there are four columns. First one is for date and rest three are for integer data.

I need to parse this CSV file and save the data in separate arrays.

I have searched for a solution, but I don't get proper idea on how to do this.

This may help you mate: stackoverflow.com/questions/5360628/… — Pratik Purohit
– Pratik Purohit, Commented May 19, 2011 at 11:11

bendaf · Accepted Answer · 2016-12-09 12:45:19Z

33

I like this csv reader: https://mvnrepository.com/artifact/net.sf.opencsv/opencsv/2.3

Just add it to your project.

Example code (assuming there is the file assets/test.csv):

        String next[] = {};
        List<String[]> list = new ArrayList<String[]>();

        try {
            CSVReader reader = new CSVReader(new InputStreamReader(getAssets().open("test.csv")));
            while(true) {
                next = reader.readNext();
                if(next != null) {
                    list.add(next);
                } else {
                    break;
                }
            }
        } catch (IOException e) {
            e.printStackTrace();
        }

You can access the imported data with, for example,

list.get(1)[1]

That would return a string.

edited Dec 9, 2016 at 12:45

bendaf

3,0615 gold badges31 silver badges62 bronze badges

answered Oct 15, 2011 at 18:58

nspo

1,53817 silver badges21 bronze badges

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

4 Comments

chwi Over a year ago

@PratikButani the for(;;) does that, so you can do it again after that loop it you want

zeeshan Over a year ago

CSVReader worked for me, after trying tons of other CSV parsing solutions. I am surprised good CSV parsing remains a difficult to implement solution. In my case I had to deal with multilines, and this is the only file which made it work.

Si8 Over a year ago

What if I wanted to parse a CSV located on a Url?

Filowk Over a year ago

@Si8 Retrofit. ResponseBody. CSVReader reader = new CSVReader(response.body().charStream());

Collectives™ on Stack Overflow

How to parse the CSV file in android application?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related