This page looks best with JavaScript enabled

Working with CSV's in Windows Powershell

 ·   ·  ☕ 1 min read

Powershell is a relatively unique and very powerful command line interface (CLI) and with Windows 10 is now the default shell for Windows. In this video we’ll explore some of the basics of powershell and specifically look at how to use powershell to analyze CSV data.

Powershell is uniquely useful for this task due to its ability to handle data as objects and because of the native support for both CSV and JSON input and output. The ability to filter, sort and format data is also a very strong tool that is both easy to use and understand.

We will also look at using the Powershell ISE (included with Windows) that provides a useful scripting environment for building scripts and testing commands as well as learning more about the capabilities of powershell.

Powershell is included with Windows and is available for download for both MacOS and Linux operating systems. See the Get Powershell section over at the Powershell GitHub page for more information on getting started on other operating systems:

Source data for the element data used in this video:


Sam Wronski
Sam Wronski
Maker of things, currently helping build cloud things @ Google. World of Zero is a personal project disconnected from my professional work. Lets make something awesome together!