Working with CSV Data in PowerShell

PowerShell is one of the most popular scripting languages for IT Professionals in the Microsoft ecosystem. This course will teach you how to use CSV files both as input for your PowerShell scripts, as well as an output from your PowerShell scripts.
Course info
Rating
(38)
Level
Beginner
Updated
May 26, 2017
Duration
51m
Table of contents
Description
Course info
Rating
(38)
Level
Beginner
Updated
May 26, 2017
Duration
51m
Description

PowerShell is an awesome tool, and as an IT pro you probably want to use its powerful automation potential to automate your own tasks. To efficiently automate processes, you will need to use input files, because it's not really automation if you need to give it a manual input for every single process you want to run. In this course, Working with CSV Data in PowerShell, you will learn how to work with CSV files in your PowerShell scripts. First, you will learn what CSV files are, and why/when you should use them. Next, you'll learn how to get information with PowerShell and output it to a CSV file. Finally, you'll learn how to use CSV files as input files for your PowerShell scripts. When you're finished with this course, you will have the skills and knowledge of PowerShell needed to work with CSV data in PowerShell.

About the author
About the author

Vlad is a SharePoint and Office 365 Consultant specializing in SharePoint and SharePoint Online deployments as well as hybrid scenarios. As a Pluralsight Author, Microsoft Certified Trainer, and recognized international speaker, Vlad has helped thousands of users and IT Pros across the globe to better understand and to get the most out of SharePoint. Vlad is also a Microsoft Most Valuable Professional (MVP) in SharePoint since 2013 and has his own blog at www.absolute-sharepoint.com and he often shares his knowledge by speaking at local conferences and community events. Vlad also blogs at CMSWire as well as Computerworld and is often featured in other Microsoft sites such as Redmond Channel Partner. In Addition, Vlad is the recipient of the "Top 25 Office 365 Influencers" award, showcasing him as one of the most influential Office 365 specialists in 2015 demonstrating his expertise and passion for Microsoft's shift towards the cloud in the past years.

More from the author
Microsoft 365 Security Concepts
Beginner
1h 3m
Jul 10, 2019
Microsoft 365 Services and Concepts
Beginner
1h 26m
Jun 6, 2019
More courses by Vlad Catrinescu
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone, my name is Vlad Catrinescu, and welcome to my course, Working with CSV Data in PowerShell. I'm a Microsoft MVP and independent consultant from Montreal, Canada. When automating tasks with PowerShell, you need to use input files, because well, it's not really automating if you need to give it information for every small task. One of the popular input files for PowerShell is CSV, short for comma-separated values. In this course, we are going to learn how to both use CSV files as input for our partial scripts, as well as how to output information to CSV files by using PowerShell. Some of the major topics that we will cover include an introduction to the CSV file format, how to export information from PowerShell to CSV, and lastly, how to use CSV files as input for partial scripts. By the end of the course, you'll know how to work with CSV files from your PowerShell scripts. Before beginning this course, you should be familiar with the basics of PowerShell. I hope you will join me on this journey to learn PowerShell with the Working with CSV Data in PowerShell course at Pluralsight.

Exporting Information to CSV
Hello, and welcome to this course on working with CSV data in PowerShell. My name is Vlad Catrinescu, and I will be your instructor for this course. In this module, we'll learn how to export information to CSV. We will first start with the basics of exporting to CSV, and learn how to do it, as well as what options we can configure to get the output we want. We will then look at some real-life examples, and look at, for example, how to export the hard drive space to CSV, how to export some information about Active Directory users, as well as Office 365 licensed users. This way not only you will know the theory, but we'll be able to cover some real-life examples, even if they don't directly relate to what you do every day, it will give you an idea of how it's done in the real day-to-day life.

Importing Information from CSV
Hello, and welcome to this course on Working with CSV Data in PowerShell. My name is Vlad Catrinescu, and I will be your instructor for this course. In this module, we will learn how to import information from CSV, and use it in our PowerShell scripts. We will first start by covering the basics of importing from CSV files, and then we'll look at some real-life examples for Office 365 and SharePoint.