Home

How to report from file folders using excel

%3CLINGO-SUB%20id%3D%22lingo-sub-338761%22%20slang%3D%22en-US%22%3EHow%20to%20report%20from%20file%20folders%20using%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338761%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20struggling%20with%20finding%20a%20way%20to%20report%20information%20in%20a%20file%20folder.%3CBR%20%2F%3EI%20have%20been%20asking%20to%20review%20the%20list%20inside%20a%20folder%20that%20is%20used%20by%20Law%20Clerks.%20Each%20folder%20would%20have%20documents%20I%20would%20then%20created%20the%20list%20would%20be%20the%20following%3A%E3%80%80%3C%2FP%3E%3CP%3EName%20of%20the%20file%20%E2%80%93%20case%20number%20%E3%80%80%3C%2FP%3E%3CP%3EDate%20modified%20%E2%80%93%20mm%2Fdd%2Fyear%20%E3%80%80%3C%2FP%3E%3CP%3EType%20%E2%80%93%20Microsoft%20word%20%E3%80%80%3C%2FP%3E%3CP%3EFile%20size-%20KB%20%E3%80%80%3C%2FP%3E%3CP%3EOwner%20%E2%80%93%20the%20law%20clerk%20that%20created%20the%20document.%E3%80%80%3C%2FP%3E%3CP%3EI%20was%20asked%20to%20create%20a%20report%20that%20would%20show%20the%20above%20fields%20for%20the%20year%202018.%3CBR%20%2F%3EI%20am%20using%20excel%202016%20I%20was%20looking%20at%20using%20power%20query%2C%20but%20after%20view%2C%20the%20data%20in%20the%20power%20query%20editor%20fields%20I%20can%E2%80%99t%20see%20the%20file%20size%20or%20the%20owner%20fields.%26nbsp%3B%20Any%20suggestions.%26nbsp%3B%20Thanks%20Brenda.%20T%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-338761%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338959%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20report%20from%20file%20folders%20using%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338959%22%20slang%3D%22en-US%22%3E%3CP%3EI%20guess%20that's%20with%20VBA%20coding%2C%20or%20PowerShell%20script%20to%20create%20.csv%20file%2C%20but%20I%20have%20no%20such%20samples%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338952%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20report%20from%20file%20folders%20using%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338952%22%20slang%3D%22en-US%22%3EThanks%20Sergei%2C%20for%20getting%20back%20with%20me.%20Now%20owners%20is%20one%20field%20I%20do%20need.%20Is%20there%20any%20other%20tool%20I%20can%20us.%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338824%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20report%20from%20file%20folders%20using%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338824%22%20slang%3D%22en-US%22%3E%3CP%3ESize%20is%20in%20the%20Attribute%20column%20if%20you%20expand%20it%2C%20owner%20is%20not%20returned%3C%2FP%3E%3C%2FLINGO-BODY%3E
BTink619
New Contributor

I am struggling with finding a way to report information in a file folder.
I have been asking to review the list inside a folder that is used by Law Clerks. Each folder would have documents I would then created the list would be the following: 

Name of the file – case number  

Date modified – mm/dd/year  

Type – Microsoft word  

File size- KB  

Owner – the law clerk that created the document. 

I was asked to create a report that would show the above fields for the year 2018.
I am using excel 2016 I was looking at using power query, but after view, the data in the power query editor fields I can’t see the file size or the owner fields.  Any suggestions.  Thanks Brenda. T

3 Replies

Size is in the Attribute column if you expand it, owner is not returned

Thanks Sergei, for getting back with me. Now owners is one field I do need. Is there any other tool I can us.?

I guess that's with VBA coding, or PowerShell script to create .csv file, but I have no such samples

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies