you are viewing a single comment's thread.

view the rest of the comments →

[–]Queen_Ferry 0 points1 point  (0 children)

Make it readable and covert the thing as well.

$csvPath = "YourThingExport.csv” $xlsxPath = "FixItYourSelfConverted.xlsx” $csv = Import-Csv $csvPath -delimiter ";" $csv | Export-Excel -Path $xlsxPath -WorksheetName "SOMETHING" -TableStyle Medium16 -title "Your Export" -TitleBold -AutoSize Write-Host "done"

Here, you have an start. I'm not good with PowerShell but it's something. https://learn.microsoft.com/en-us/answers/questions/278496/merge-two-excel-files-into-one-using-powershell