tree to excel

I am trying to capture all the directories (NAMES ONLY, and subdirectories) on a given network share.  I know i can do powershell and Get-ChildItem | tree > c:\tree.txt    but can someone help me get it so i can import it into excel in a nice layout so we can use it as a checklist?
Thanks!
bbimisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SubsunCommented:
Check the csv report format from following question and see if it works for you..
http://www.experts-exchange.com/Programming/Languages/Scripting/Powershell/Q_28212659.html
0
bbimisAuthor Commented:
that looks great. I have one question though and I have no problem opening a new question if need be.  Here is ultimately what I need to figure out.

lets say i have
f:\common
apples
oranges
grapes

and they have files inside of them I want for each directory a csv file of all its file permissions
I have a powershell script that will do the WHOLE thing but i want it to go to one directory say apples and make a csv file called apples.csv  then when it finishes move on an make a csv file called oranges and so on.  Is this possible and if so can someone help me with the code.  this is what i have so far.

$path = 'F:\common’

$outFilename = Join-Path $path "Dir-$(Get-Date -Format 'yyyyMMdd-HHmmss').csv"

dir $path -attr !D -r | select Name, Extension, DirectoryName, Length, CreationTime, LastAccessTime, LastWriteTime | export-csv $outFilename -NoTypeInformation

Open in new window

0
SubsunCommented:
Try this and see if it works for you.. Results will be saved in C:\Temp..
$Path = "F:\common"
Foreach ($Dir in (GCI $Path | ?{$_.PSIsContainer})){
	GCI $Dir.FullName -Recurse | ?{!($_.PSIsContainer)} | % {
	$Perm = Get-Acl $_.FullName
	$_ | Select Name,Extension,DirectoryName,Length,CreationTime,LastAccessTime,LastWriteTime,`
			@{N="Owner";E={$Perm.Owner}},@{N="Access";E={$Perm.Access | Out-String}}
	} | Export-Csv "C:\Temp\$($Dir.Name)-$(Get-Date -Format 'yyyyMMdd-HHmmss').csv"
}

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bbimisAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for bbimis's comment #a39445574
Assisted answer: 500 points for Subsun's comment #a39445462

for the following reason:

thank you so much that is exactly what i needed!!!!
0
bbimisAuthor Commented:
THANK YOU SO MUCH!!! This is what i needed!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.