How to get Power Shell Output into excel file

Sreeram MUNIRAJA

7y1.1k

Dear Team,

How can we get below script output into excel?

#Read CSV file

$CSV = Import-Csv "D:\Test\Sites.csv"

$SubSites = $CSV.Sites

$credential = Get-Credential

#Iterate through each site in subsite

Foreach ($Subsite in $SubSites)

{

#Inititate PnP Properties and get access request settings

Connect-PnPOnline -Url $Subsite -Credentials $credential

$Web = Get-PnPWeb

Write-Host "Site" $Web.Url -ForegroundColor Green

Get-PnPGroup -AssociatedOwnerGroup -ErrorAction SilentlyContinue

Get-PnPGroup -AssociatedMemberGroup -ErrorAction SilentlyContinue

Get-PnPGroup -AssociatedVisitorGroup -ErrorAction SilentlyContinue

}

Best regards

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan7y ago
Option 1: Out-File
PS C:\> YourCode.ps1 | Out-File -filepath C:\Output.txt
Option 2: Export-Csv
Code changes may be needed to format the output
Please refer: https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/export-csv?view=powershell-6

Option 3: Arrow operator
PS C:\> YourCode.ps1 > C:\Output.txt
Abhishek Mishra7y ago
Below link will help to build excel for your output in Powershell
https://gist.github.com/josheinstein/9898245