Get-ChildItem -Path . -Filter *.csv | ForEach-Object {
$csv = Import-Csv $_.FullName
$rowCount = $csv.Count
$colCount = if ($csv.Count -gt 0) { ($csv[0].psobject.Properties | Measure-Object).Count } else { 0 }
$colNames = if ($csv.Count -gt 0) { $csv[0].psobject.Properties.Name -join ", " } else { "" }
[PSCustomObject]@{
File = $_.Name
Rows = $rowCount
Columns = $colCount
ColNames = $colNames
}
} | Format-Table -AutoSize