// Create a new workbook Workbook workbook = new Workbook(); //Open csv with more settings. CsvOpenOptions options = new CsvOpenOptions(); options.setColumnSeparator(","); options.setRowSeparator("\r\n"); options.setCellSeparator('"'); //Change the path to the real file path when open. workbook.open("source.csv", options);