Format output from powershell

Question

Good Morning,

I'm trying to format the output from the below PowerShell script into a table so it can be imported into an excel spreadsheet.

Get-ADGroupMember -Identity "GroupA" | ForEach-Object {
Get-ADUser -Identity $_.SamAccountName -Properties EmailAddress, LastLogonDate, Created |
Select-Object -Property Name, GivenName, Surname, UserPrincipalName, EmailAddress, Enabled, LastLogonDate, Created | Format-Table } > C:\Temp\GroupA.txt

But I can't get the formatting right. When I run the about script it comes out like:

Name GivenName Surname UserPrincipalName EmailAddress Enabled LastLogonDate Created
---- --------- ------- ----------------- ------------ ------- ------------- -------
Person A Person A Person.A@mathieu.company .co.uk PersonB@mathieu.company .co.uk True 11/03/2021 13:55:55 02/02/2021 09:43:25

Name GivenName Surname UserPrincipalName EmailAddress Enabled LastLogonDate Created
---- --------- ------- ----------------- ------------ ------- ------------- -------
Person B Person B Person.B@mathieu.company .co.uk PersonB@mathieu.company .co.uk True 11/03/2021 11:42:14 04/12/2020 14:53:45

I have added the -HideTableHeaders but i still get all the blank spaces and excel doesn't recognise the columns

Please help!!

Answer 1

Hi @lee roberts ,

instead of Format-Table and >C:\Temp\groupA.txt you could use Export-Csv.
CSV files can be opened with Excel.

https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/export-csv?view=powershell-7.1

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten