Reading CSV file in Java

Question

How to read the CSV file in Java?

I assume I need to use an InputStream. How do I continue after the InputStream declaration?

InputStream file = item.getInputStream();

Does this answer your question? [Read all lines with BufferedReader](https://stackoverflow.com/questions/28977308/read-all-lines-with-bufferedreader) — Ivan, Nov 21 '20 at 23:20

score 5 · Accepted Answer · edited Oct 07 '15 at 07:52

For reading the CSV file, you can use the BufferedReader class:

BufferedReader reader = new BufferedReader(
    new InputStreamReader(new FileInputStream("CSV file location"))
);

After that, use StringTokenizer to read each common separated values from the file, ex.:

if(reader.readLine()!=null) {
    StringTokenizer tokens = new StringTokenizer(

    // this will read first line and separates values by (,) and stores them in tokens.
    (String) reader.readLine(), ",");

    tokens.nextToken(); // this method will read the tokens values on each call.
}

For example, the CSV file is having record of a employee, like:

ram,101

The first time, the tokens.nextToken() call will return ram.
The second time, the tokens.nextToken() call will return 101.

This works considering that I am using the using a directory in my computer. However, I want is file upload but `BufferedReader reader = new BufferedReader(new InputStreamReader(file));` doesn't seem to work as I am getting an error in this line `List items = new ServletFileUpload(new DiskFileItemFactory()).parseRequest(request);` — nubteens, Oct 07 '15 at 07:54

score 0 · Answer 2 · answered Oct 07 '15 at 07:16

0

For reading/manipulating csv in Java, you can check out Apache POI Library.

answered Oct 07 '15 at 07:16

Xoul

359
1
3
13

score 0 · Answer 3 · answered Oct 07 '15 at 10:01

0

I recommend https://commons.apache.org/proper/commons-csv/

"Commons CSV reads and writes files in variations of the Comma Separated Value (CSV) format."

answered Oct 07 '15 at 10:01

salyh

2,095
1
17
31

Reading CSV file in Java

3 Answers3