PowerShell Get Column Names for a CSV File

Posted on August 13, 2017 by Alan

Get-Member doesn’t always show you what is under the hood for an object. For that you need the .PSObject property. Here PSObject.Properties contains CSV column names

$data = Import-Csv -Path $csvfile
$ColNames =  ($data[0].psobject.Properties).name
$ColNames

You must be logged in to post a comment.

All the scripts are saved as .txt files. Newer files have a “View Script” button which will let you save or open a script in notepad. For earlier posts, the easiest way to download with IE is to right click on the link and use “Save Target As”. Rename file from Name_ext.txt to Name.ext.

To see a full post after searching, please click on the title.

PowerShell Scripts were written with version 3 or later.

https connections are supported.

All new users accounts must be approved, as are comments. Please be patient. If you find a post error or a script which doesn’t work as expected, I appreciate being notified. My email is my first name at the domain name, and you are welcome to contact me that way.

Leave a Reply