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