Automating Excel and CSV Work with PowerShell — Practical Recipes for Aggregation, Reconciliation, and Report Output (archived 2026-08-30)

Abstract

Practical recipes for automating CSV aggregation, reconciliation, and Excel report output with PowerShell. Covers the default encodings of Import-Csv/Export-Csv (how 5.1 and 7 differ), aggregation with Group-Object, reconciliation with Compare-Object and hash tables, and the caveats around ImportExcel and Excel COM. Archived version of https://comcomponent.com/en/blog/powershell-excel-csv-automation-recipes/, as published on 2026-08-30. The live article is maintained and may change after this date. First published 2026-07-18.