top of page

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

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page