title: How to rename a column heading in a CSV file?
body: <p>I cannot work out how to rename a column heading in a CSV file with Windows PowerShell. I can add new rows, delete rows, fill, and export, but cannot find out how to change a header value.</p>
  <p>I thought I could import the CSV &amp; export with headers specified, but taht doesn't work:</p>
  <pre><code>import-csv c:\tmp\test.csv | Select-Object first_name | Export-Csv -header &quot;test&quot; c:\tmp\test1.csv
  </code></pre>
  <p>I basically need to re-format a CSV file, so if I can select the data I want &amp; specify the new headers that would be perfect.</p>