SOLVED

How to extract files data properties

Brass Contributor

Hello,

I would extract in a txt file, all the properties of all the files stored in a sharepoint archive.

I moved some files from a directory to sharepoint. Before that, I use tu lanch a dos "dir" command to check all files stored.

Can I do the same think now in sharepoint?

Thanks in advance!

2 Replies
best response confirmed by Gianluca Principato (Brass Contributor)
Solution

@Gianluca Principato You can use PowerShell to get a list of all files in a library 

https://www.sharepointdiary.com/2018/08/sharepoint-online-powershell-to-get-all-files-in-document-li...

 

You can also go to the SharePoint library and choose "Export to Excel" to get a list of all files in the library and metadata column values.

@Steve Knutson Thanks for your reply.

I didn't know Powershell and after reading your answer I started to deepen it.

I solved my problem even though I have not yet been able to export owner's file; the DOS command allowed me to highlight them while Powershell does not seem to me to have this information.

However Powershell seems to me just what I need: I guess that with Powershell I can also connect to Office (outlook, word, etc.).

I will continue to figure out how to best use it! Thanks again.

1 best response

Accepted Solutions
best response confirmed by Gianluca Principato (Brass Contributor)
Solution

@Gianluca Principato You can use PowerShell to get a list of all files in a library 

https://www.sharepointdiary.com/2018/08/sharepoint-online-powershell-to-get-all-files-in-document-li...

 

You can also go to the SharePoint library and choose "Export to Excel" to get a list of all files in the library and metadata column values.

View solution in original post