Export-Csv

noun

say it: “EK-sport SEE-ESS-VEE” /ˈɛkspɔrt ˌsiˌɛsˈvi/

A PowerShell command that saves objects as a CSV file, with their property names as the header and one object on each line.

What does Export-Csv do?

Export-Csv saves objects as a CSV file that Excel and other programs open: the property names become the header line and each object becomes one line. It replaces a file of the same name, unless you add -NoClobber, and -Append adds to the end instead. Choose the columns with Select-Object first, and keep formatting commands such as Format-Table out of the pipeline before it.

Import-Csv rentals-2026-10.csv | Select-Object Date, Store, Bike, Fee |
    Export-Csv rentals-2026-10-clean.csv

In a sentence

  • “Export-Csv replaced last month's file, because Sam hadn't added -NoClobber.”
  • “Sam saved the cleaned rentals with Export-Csv, and the file opened straight in Excel.”

Level: Apprentice · More PowerShell terms at this level

Updated