13

I have the following line in Powershell to output an array of data. The problem I am having is that Name,Title,Department do not go into columns. Instead I get a single column with each row in a single cell with tabs between.

$outList | Format-Table Name,Title,Department -auto >c:\Scripts\test2.csv

How can I output into columns?

Alex_P
  • 2,580
  • 3
  • 22
  • 37
devfunkd
  • 3,164
  • 12
  • 45
  • 73

1 Answers1

25

You should be using the Export-Csv cmdlet instead.

$outList | Export-Csv -path c:\scripts\test.csv -NoTypeInformation

If you need only selected fields, pipe it into a Select-Object cmdlet first.

$outList | Select-Object -Property Name, Title, Department | Export-Csv -path c:\scripts\test.csv -NoTypeInformation
MFT
  • 1,405
  • 12
  • 11