# Saving Data: Export-Csv and Cleaning a CSV

Export-Csv saves objects as a CSV file that Excel and other programs open as a table, and on the way there a pipeline can clean an untidy export, dropping its blank rows, renaming its columns and turning text such as $36.00 into numbers with \[decimal\] and \[int\].

![Cheat sheet for the lesson Saving Data: Export-Csv and Cleaning a CSV: Export-Csv saves objects as a CSV file that Excel and other programs open as a table, and on the way there a pipeline can clean an untidy export, dropping its blank rows, renaming its columns and turning text such as $36.00…](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/6c31f10d058e495f887b21629d392297.webp)

- Category: PowerShell
- Level: Journeyman
- Tags: Calculated Property, CSV File, export-csv, operating-system, powershell, type-conversion
- Updated: November 10, 2026

Source: https://www.ask-codey.com/cheat-sheets/powershell-export-csv-cheat-sheet