Exporting SQLCMD output to a comma delimeted .csv file

hello,

want run below shown ps script. issue have writing output file comma delimiter. should have column header. can please this?

currently, when open output file using excel, there no column separation. so, comma delimiter help.

=================

##save below powershell script in folder "e:\powershellscripts\sqlserversbackupstatusfrommsdb.ps1"

$querypath= "e:\powershellscripts\backupstatusquery1.sql"
$outputfile = "e:\powershellscripts\backupstatusquery1_output.csv"

$executequery= get-content -path $querypath | out-string

#"results -- > `r`n`r`n" > $outputfile

foreach($server in gc "e:\powershellscripts\sqlserverlist.txt")
 {
$server 

#"---------------------------------------------------------------------------------------------------------" >> $outputfile
#$server >> $outputfile
#"---------------------------------------------------------------------------------------------------------" >> $outputfile
invoke-sqlcmd -serverinstance $server -query $executequery  -querytimeout 65534  | ft -autosize | out-string -width 4096   >> $outputfile
 }

==============

victor

---

victor

try using commands intended. command can t o understand how use commands.

$sqlfile = e:\powershellscripts\backupstatusquery1.sql $csvfile = e:\powershellscripts\backupstatusquery1_output.csv  get-content e:\powershellscripts\sqlserverlist.txt | foreach-object{ 	invoke-sqlcmd -serverinstance $_ -inputfile $sqlfile } | export-csv $csvfile -notype

---

\_(ツ)_/

Windows Server  >  Windows PowerShell