Powershell Tip #125: Identify the duplicates headers of a CSV file

Tip: You can identify the headers duplicated in a CSV file.

It can happen if someone save as CSV an Excel file and some duplicates were repeated multiple times by mistake.

excel-file-duplicates-headers

When trying to import the CSV, we can only see the first duplicate found but not all of them (SamAccountName and Department).

import-csv-duplicates-powershell

Here we can see the two duplicates headers :

(Get-Content .\duplicates.csv | Select-Object -First 1).Split(',') | Group-Object | Where-Object {$_.Count -ge 2}

1	(Get-Content .\duplicates.csv \| Select-Object -First 1).Split(',') \| Group-Object \| Where-Object {$_.Count -ge 2}

import-csv-duplicates-powershell-found