How do I output a CSV using PowerShell without the “#TYPE” line?

Add the NoTypeInformation switch, like this:

Export-Csv "../SSIS/Import Data/ADUsers.csv" -NoTypeInformation