From the course: PowerShell 5 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Working with CSVs

Working with CSVs - PowerShell Tutorial

From the course: PowerShell 5 Essential Training

Start my 1-month free trial

Working with CSVs

“

- One of the most common formats to put data in as we're moving data from one application to another and around our network is CSV, or Comma Separated Value. I'm sure you have a lot of applications that either create CSVs that you need to bring in or you want to send data out to a CVS. So we're gonna see that PowerShell can help us with this. I'm going to do get-help "csv" and you're gonna see some commandlets for that and it looks a little confusing at first. Notice I've got a ConvertTo-CSV and I've got a Export-CSV. You might be asking, "Well which one do I use?" And we're going to get to that because they do act differently. I also have an Import-CSV, so I could bring in other CVSs that may have been created by some other application that I want to use in PowerShell. So let's go ahead and try this out. And we're going to start with Export-CSV. I'm going to get some information, and yeah, I'm gonna stick with get-service and I'll just export this out as a csv. Remember you can look…

Contents