Script for converting a CSV file to markdown. Note: the CSV is loaded into memory, not streamed from disk. Probably not suitable for large files.

CsvToMD.ps1

function CsvToMd {
    param ($PathToCsv)
    
    if (-not (Test-Path $PathToCsv)) {
        throw [System.IO.FileNotFoundException]::new("Provided path doesn't resolve to a CSV file", $PathToCsv)
    }

    $records = import-csv $PathToCsv
    $header = ($records | select -First 1).PSObject.Properties.Name
    $headerLine = $header -join ' | '
    $headerDivider = (1.. ($header.Count) | foreach { '---' } ) -join '|'

    Write-Output $headerLine
    Write-Output $headerDivider
    Write-Output $records | ConvertTo-Csv -NoTypeInformation -Delimiter '|' | foreach { $_.Replace('"','') } | select -Skip 1
}