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:

Recent Posts

See All

Frequently Asked Questions, by phone

I have a warning message When does it happen? Can you send a screenshot to us? Also, if you can, please email the PDF input document to us (or upload it using the 'File' menu within StatementReader) a