Just collect a few articles about reading CSV with PowerShell.
- Read a Csv file with powershell and capture corresponding data
- Powershell read from CSV set variables
- Use a CSV File to Populate Parameters of PowerShell Cmdlets
This one is more practical relate to AD account creation.
Use PowerShell to Read a CSV file and Create Active Directory User Accounts