SOLVED

How to extract files data properties

%3CLINGO-SUB%20id%3D%22lingo-sub-1245486%22%20slang%3D%22en-US%22%3EHow%20to%20extract%20files%20data%20properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1245486%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20would%20extract%20in%20a%20txt%20file%2C%20all%20the%20properties%20of%20all%20the%20files%20stored%20in%20a%20sharepoint%20archive.%3C%2FP%3E%3CP%3EI%20moved%20some%20files%20from%20a%20directory%20to%20sharepoint.%20Before%20that%2C%20I%20use%20tu%20lanch%20a%20dos%20%22dir%22%20command%20to%20check%20all%20files%20stored.%3C%2FP%3E%3CP%3ECan%20I%20do%20the%20same%20think%20now%20in%20sharepoint%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1245486%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262037%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20extract%20files%20data%20properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262037%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F15807%22%20target%3D%22_blank%22%3E%40Gianluca%20Principato%3C%2FA%3E%26nbsp%3BYou%20can%20use%20PowerShell%20to%20get%20a%20list%20of%20all%20files%20in%20a%20library%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.sharepointdiary.com%2F2018%2F08%2Fsharepoint-online-powershell-to-get-all-files-in-document-library.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sharepointdiary.com%2F2018%2F08%2Fsharepoint-online-powershell-to-get-all-files-in-document-library.html%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20also%20go%20to%20the%20SharePoint%20library%20and%20choose%20%22Export%20to%20Excel%22%20to%20get%20a%20list%20of%20all%20files%20in%20the%20library%20and%20metadata%20column%20values.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2017864%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20extract%20files%20data%20properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2017864%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F43161%22%20target%3D%22_blank%22%3E%40Steve%20Knutson%3C%2FA%3E%26nbsp%3B%3CSPAN%3EThanks%20for%20your%20reply.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20didn't%20know%20Powershell%20and%20after%20reading%20your%20answer%20I%20started%20to%20deepen%20it.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20solved%20my%20problem%20even%20though%20I%20have%20not%20yet%20been%20able%20to%20export%20owner's%20file%3B%20the%20DOS%20command%20allowed%20me%20to%20highlight%20them%20while%20Powershell%20does%20not%20seem%20to%20me%20to%20have%20this%20information.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHowever%20Powershell%20seems%20to%20me%20just%20what%20I%20need%3A%20I%20guess%20that%20with%20Powershell%20I%20can%20also%20connect%20to%20Office%20(outlook%2C%20word%2C%20etc.).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20will%20continue%20to%20figure%20out%20how%20to%20best%20use%20it!%20Thanks%20again.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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.