Import Excel generated csv to SCSM via powershell

If you want to bulk Import data to System Center Service Manager from CSV with german data using powershell, there two things to do right:

  1. Save the Excel spreadsheet as “CSV (Trennzeichen-getrennt) .csv”
  2. Import into SCSM with right encoding
    1. Import-Csv $Filename -Delimiter ‘;’ -Encoding Default
    2. Import-Csv $Filename -Delimiter ‘;’ -Encoding UTF7

That’s it.