frequal.com

Apache Commons CSV for Easy CSV Parsing in Java

To parse CSV files in Java, Apache Commons CSV should be your go-to library. Wheteher your CSV files are simple or complex, it can handle them easily and efficiently.

Dependency

Import with Maven:

  <dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-csv</artifactId>
    <version>1.14.0</version>
  </dependency>

Java Usage

If you have a CSV file folder/example.csv that looks like this:

Address,City,State
100 Main St,Mainville,ME
100 Second St,Flint,MI

You can read the rows and access the fields by name as follows:

  Reader reader = new FileReader("folder/example.csv");
  Iterable<CSVRecord> records = CSVFormat.EXCEL.withHeader().parse(reader);
  for (CSVRecord record : records) {
    String address = record.get("Address");
    String city = record.get("City");
    String state = record.get("State");
  }

Summary

I have used Apache Commons CSV and it is easy, quick, and powerful. I highly recommend it.

Last modified on 1 Apr 2025 by AO