Now that I have shown you how to create a .CSV file, I want to show you how to import a .CSV file into PowerShell. I will cover that in Part 2 here.

If you've encountered a CSV file and you're unsure what they're for, the good news is they're pretty straightforward and easy-to-use with apps you already know.

One way to turn a CSV file into a Microsoft Excel spreadsheet is to open the document in Excel, but with this method you won't see the text-import wizard that allows you to specify how Excel ...

Now you can see some options listed in a popup window. You need to select Export to a file from the list and click the Next button. Then, you will have two options, i.e. CSV and PST.

When you drag a CSV file into the spreadsheet area in the Essential Graphics panel, the Spreadsheet Data window opens, and you may have to map the data in the spreadsheet to the data in the template.

This process shows you how to export your passwords stored in Chrome into a CSV file, so that you are able to import your account credentials into a password manager. However, there's one big caveat.

In the second part of this series, Brien shows how to import a .CSV file into a PowerShell array, including two methods for zooming in on just the specific data you need and filtering out the rest.