What are common mistakes when importing and exporting CSV with PowerShell ?
Documentation: Microsoft Learn
Imported CSV values begin as strings, headers become property names, and Export-Csv should receive objects before formatting.
Interview · Question 18 of 34
Answer before reveal
Your draft
Write the answer you would give in an interview. The model answer stays hidden until you have drafted at least a short response.
A strong answer
Imported CSV values begin as strings, headers become property names, and Export-Csv should receive objects before formatting. Choose encoding deliberately and validate headers and row counts after export.
Show it concretely
1PS> Import-Csv .\users.csv | Select-Object Name, Department | Export-Csv .\clean.csv -NoTypeInformation
Expect this follow-up
How would you preserve a date or integer type across a CSV round trip?
