Improving Excel with Python (Day 3 of 5)

My starter scripts in January 2021:

List Excel file attributes in Excel

File attributes of Excel files (the file properties accessible on right-click) are seldom used to their full potential, in my experience. I suspect one reason for this is that there’s no quick way to see what details have been entered for multiple files.

Here’s a snippet that allows you to see the title, description, subject and other details (like date last modified) for multiple Excel files held in a single folder, all in one spreadsheet.

Check out tomorrow’s post for an easy way to update all file attributes for all Excel files in a folder, in a single click.

Any thoughts or questions, get in touch

---

Have a look at the code I used, here: