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
(41)
Level
Beginner
Updated
May 26, 2017
Duration
51m
Table of contents
Description
Course info
Rating
(41)
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
Configuring and Managing SharePoint Online
Intermediate
4h 31m
Oct 1, 2019
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.