How to convert CSV file to Array?

Question

For example, I have csv file and then imported to PowerShell:

$animal = Import-Csv “animal.csv”
$animal

Output is:

Animal
------
Bird
cat
dog

I would like to convert to array value, i.e. I would like to put these "bird","cat","dog" in array, basically like this:

$newanimals = "Bird","Cat","Dog"

How can I do that?

xXhRQ8sD2L7Z · Accepted Answer · 2016-01-12 22:55:41Z

3

$newanimals = Import-Csv -Path "animal.csv" | Select -ExpandProperty Animal

answered Jan 12, 2016 at 22:55

xXhRQ8sD2L7Z

1,7261 gold badge14 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kyle Muir · Accepted Answer · 2016-01-12 22:50:53Z

1

Quick and dirty:

Import-Csv ".\animal.csv" | Foreach-Object {$arrayOfAnimals += @($_.Animal)}
Write-Host $arrayOfAnimals #Bird cat dog
$arrayOfAnimals[1] #cat

answered Jan 12, 2016 at 22:50

Kyle Muir

3,9252 gold badges24 silver badges28 bronze badges