Writing to CSV Files in Python

Goal: Writing all files' names in any folder to a CSV File in Python

Pre-Requisites:

  • Working Python Shell like IDLE
  • Notepad ++ or any other text editor

Lets begin

1. Open Python Shell "IDLE" and save a file named "Allfiles.py"

2. Copy below code to "Allfiles.py"

import os
import csv
os.chdir('C:\\data')
file=os.listdir()
with open('fileslist.csv', mode='w') as new_file:
        wri = csv.writer(new_file)
        for i in range(len(file)):
            wri1 = file[i]
            wri.writerow(wri1)

3. Save and press F5 to execute.

4. Open folder 'data' in C: drive and you will find a file named 'fileslist.csv'.

5. Open fileslist.csv in NotePad++.

6. You will see one empty line after each file name. To delete empty row, select edit-->Line Operations-->Remove Empty Lines

7. To remove unwanted commas, do CTRL-F, Click Replace, Put "," in Find and click Replace All.

8. That's it. You have a list of files in your desired folder.