If you can get rid of the first line, can you now import the file as a csv with the earlier suggestions? That would be the best way to get to an object. Otherwise, you would need to create a new custom object and then define new properties using Add-Member. As to how that would all fit in your script would really depend. if you want to do this using PowerShell, then you need to stick to the PowerShell paradigm. And maybe instead of trying to get everything into one monolithic script, break things down into Powershell functions. Have one function take the Excel file and turn it into a CSV file. Then use PowerShell to import the csv. Pipe that output to another PowerShell expression using foreach-object to do something.