Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

copy paste file names and windows columns details

Brass Contributor

more of a Windows explorer functionality w Excel question.  How do I copy all the file names including all the details in the columns I chose?  

I can get path/filename but am stuck with how to export all attributes of the files.  

Need: Date modified, Type, Size Authors, etc......

6 Replies

@cris_no_h 

You may Power Query the folder

It doesn't bring in all the columns I have added. ie Date accessed or created.

@cris_no_h 

They are available directly, some other ones are in Attributes

image.png

It's not available to pick - so I want to import Authors and Creators.

Also, you are way more advanced than me.  Wish I could just copy/paste and have a choice of not pasting the files, rather the info I am viewing.

@cris_no_h 

And if expand Attributes?

I have the same problem. I want the details of Video Length and it is not available when I expand Attributes after using Get Data in excel.