Paula  Hall

Paula Hall

1619524860

How to Create A List Of Files, Folders, and Subfolders and Then Export As Excel

A productivity tool to Marie Kondo your folders

Can you create a list of files, folders, and subfolders for our project folder?

This request looks deceptively simple, but you can already imagine the n other modifications that may come once the first version of this list is done.

Can you also list the files types and add hyperlinks to the file? And maybe add the file size while you’re at it?

Depending on the size of the folder, number of files and how nested it might be, you could have chosen to complete this task manually as adding new fields might be simple. Now, let’s consider another request:

I’ve re-arranged some folders and renamed some files, can you update that list?

Fret not, Python to the rescue!

#python-programming #tkinter #pandas

How to Create A List Of Files, Folders, and Subfolders and Then Export As Excel