Working with CSV Data in PowerShell
Course info
Course info
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
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
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.