How to read multiple csv files from a folder in java?

Question

i want to read multiple csv files from a folder in java. All files are csv and with same format, but problem is the path to the folder i get is like this only.

> conf/files

This is a folder where all my csv files are. I have a program which read single file when path is given like

> conf/files/sample.csv

If i could get a list of file name's like these i can read all those. Please help...

[This](http://stackoverflow.com/questions/5751335/using-file-listfiles-with-filenameextensionfilter) should be useful to you. — SME_Dev, Jan 30 '15 at 12:38
You can check this: http://stackoverflow.com/questions/1844688/read-all-files-in-a-folder — Luis González, Jan 30 '15 at 12:39
Hi i have tried like this csvFIlePath is "conf/files" File dir = new File(csvFilePath); File[] listOfFiles = dir.listFiles(); But i got listOfFiles as null... — Swapnil1988, Jan 30 '15 at 12:43
@Swapnil1988 : So let us know your findings . What are you getting as result after using the above piece of code ? — The Dark Knight, Jan 30 '15 at 12:46
Thanks guys for answering but i have solved my problem by dir = new File(FmceUtils.class.getClassLoader().getResource(csvFilePath).toURI()); File[] listOfFiles = dir.listFiles(); "conf/files"+file.getName(); Gives me what i wanted to read csv's thanks again — Swapnil1988, Jan 30 '15 at 15:45

score 6 · Answer 1 · answered Jan 30 '15 at 12:43

List<String> filenames = new LinkedList<String>();
public void listFilesForFolder(final File folder) {
    for (final File fileEntry : folder.listFiles()) {
        if (fileEntry.isDirectory()) {
            listFilesForFolder(fileEntry);
        } else {
            if(fileEntry.getName().contains(".csv"))
                filenames.add(fileEntry.getName())
        }
    }
}

final File folder = new File("/home/you/Desktop");
listFilesForFolder(folder);

This way, only have to loop over the filenames list, and access how you already know

score 2 · Answer 2 · answered Jan 30 '15 at 13:18

If you use FileFilter or FileNameFilter, you can get either a list of files for a later iteration or you can do something with every single file inside in the accept method.

String path = "conf/files";

File [] files = new File(path).listFiles(new FileFilter() {
    @Override
    public boolean accept(File path) {
        if(path.isFile()) {
            //Do something with a single file
            //or just return true to put it in the list
            return true;
        }
        return false;
    }
}); 
//Do something with the list of files

score 2 · Answer 3 · answered Aug 20 '20 at 14:17

2

With a lambda expression a solution can be achieved in one line:

File [] files = new File("path/to/folder/").listFiles(obj -> obj.isFile() && obj.getName().endsWith(".csv"));

answered Aug 20 '20 at 14:17

Stefanos

909
12
19

breakingcode · Answer 4 · 2022-09-20T08:57:05.177

You can easily achieve this using Files class from nio package

 RequiredType type = 
        Files.walk(Paths.get("conf/files"), 2)
                .filter(x -> x.getFileName().toString().endsWith(".csv"))
                .map(x -> {mapping logic})
                .toArray(RequiredType[]::new);

filter() will return Stream of Path, you'll need the map them using map() function after mapping them collect in the array of required type

Ashish · Answer 5 · 2017-01-19T08:20:18.357

Another way to read all .csv file in your folder directory by directory.

String inputFolder = "E:\\CSVFiles\\take";//input path where you read the file 
File folder = new File(inputFolder); 
List<String> listOfFiles=listDirectory(folder, 0);  //0 is the level where we start reading

//This method for Reading the file in directory manner(folder under folder all the csv)
private static List<String> listDirectory(File file, int level) {

    List<String> lstFiles = new ArrayList<String>();

    File[] firstLevelFiles = file.listFiles();
    if (firstLevelFiles != null && firstLevelFiles.length > 0) {
     for (File aFile : firstLevelFiles) {
      if (aFile.isDirectory() && !"ProcressedEMLs".equalsIgnoreCase(aFile.getName())
        && !"FailedEMLs".equalsIgnoreCase(aFile.getName())) {
       lstFiles.addAll(listDirectory(aFile, level + 1));
      } else if (!aFile.isDirectory()) {
       if (aFile.toString().toLowerCase().endsWith(".csv")) {
        lstFiles.add(aFile.getAbsolutePath());
       }
      }
     }
    }
    firstLevelFiles = null;
    return lstFiles;
}

How to read multiple csv files from a folder in java?

5 Answers5