How to extract files data properties

Occasional Contributor


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 (Occasional Contributor)

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


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.