Import data in different formats for use in scripts by using Windows PowerShell cmdlets

Intermediate
Administrator
Azure
Microsoft Entra ID
Azure Cloud Shell
Azure PowerShell
Azure Virtual Machines
Microsoft 365

This module explains how to import data from a text file, CSV file, XML file, and JavaScript Object Notation (JSON) file.

Learning objectives

Upon completion of this module, the learner will be able to:

  • Describe how to use Get-Content to review file data.
  • Describe how to use Import-Csv to retrieve data.
  • Describe how to use Import-Clixml to import XML data.
  • Describe how to use ConvertFrom-Json to work with JSON data.
  • Import data from text, CSV, and XML files.

Prerequisites

  • Familiarity with Windows networking technologies and implementation
  • Familiarity with Windows Server administration, maintenance, and troubleshooting
  • Familiarity with Windows PowerShell and its commands to perform specific tasks
  • Familiarity with PowerShell cmdlets used for system administration tasks related to Active Directory, network configuration, server administration, and Windows 10 device administration
  • Familiarity with Windows PowerShell pipeline, PowerShell providers, and PowerShell drives
  • Familiarity with CIM and WMI technologies
  • Familiarity to use variables, arrays, and hash tables in Windows PowerShell