File dbFile = getDatabasePath("water.db"); // dbfile File exportDir = new File(Environment .getExternalStorageDirectory(), ""); if (!exportDir.exists()) { exportDir.mkdirs(); } File file = new File(exportDir, "database_export.csv"); try { file.createNewFile(); CSVWriter csvWrite = new CSVWriter(new FileWriter(file)); Cursor curCSV = db .rawQuery("SELECT * FROM waterdata", null); // query csvWrite.writeNext(curCSV.getColumnNames()); while (curCSV.moveToNext()) { // Which column you want to exprort String arrStr[] = { curCSV.getString(0), curCSV.getString(1), curCSV.getString(2), curCSV.getString(3) }; csvWrite.writeNext(arrStr); } csvWrite.close(); curCSV.close(); Toast msg = Toast.makeText(MainActivity.this, "File was stored in SDCARD", Toast.LENGTH_LONG); msg.show(); } catch (Exception sqlEx) { Toast msg = Toast.makeText(MainActivity.this, "Failed", Toast.LENGTH_LONG); msg.show(); }