# Exporting an array to csv

**URL:** <https://forums.powershell.org/t/exporting-an-array-to-csv/14474>\
**Category:** PowerShell Help\
**Created:** [June 3, 2020, 8:33am UTC](https://forums.powershell.org/t/exporting-an-array-to-csv/14474 "2020-06-03T08:33:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![blue\_ken](https://avatars.discourse-cdn.com/v4/letter/b/e47c2d/32.png) [@blue\_ken](https://forums.powershell.org/u/blue_ken)\
**Post date:** [June 3, 2020, 8:33am UTC](https://forums.powershell.org/t/exporting-an-array-to-csv/14474/1 "2020-06-03T08:33:13Z")

</div>

I have created the script below and the values are being added into the CSV, but they are being duplicated on each line/column, example below.

RTC\_Status RTME\_Version UserName  
Connected,Connected 2.6.0.2030,2.6.0.2030 domain\user1,domain\user2  
Connected,Connected 2.6.0.2030,2.6.0.2030 domain\user1,domain\user2

```
$Array = @() ## Create Array to hold the Data 
$Computers = Get-Content -Path C:\Users\username\Downloads\Computernames.txt 

foreach ($Computer in $Computers) 
{ 
$Result = "" | Select RTC_Status,RTME_Version,UserName 
$OS = Get-WMIObject -ComputerName $Computers -Namespace ROOT\Citrix\hdx\RTOptPack -Class Citrix_HDXRTConnector 
$username = Get-WmiObject -ComputerName $Computers –Class Win32_ComputerSystem 
$Result.RTC_Status = $OS.RTC_Status -join ',' 
$Result.RTME_Version = $OS.RTME_Version -join ',' 
$Result.UserName = $username.UserName -join ',' 
$Array += $Result ## Add the data to the array } 
$Array | Export-Csv C:\Users\username\Downloads\file.csv -NoTypeInformation
```

---

<div class="post-metadata">

**Author:** ![Olaf](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/olaf/32/992_2.png) [@Olaf](https://forums.powershell.org/u/Olaf)\
**Post date:** [June 3, 2020, 9:14am UTC](https://forums.powershell.org/t/exporting-an-array-to-csv/14474/2 "2020-06-03T09:14:56Z")

</div>

There’s a cleaner (and easier) way to build such a report …

```
$ComputerList = Get-Content -Path C:\Users\username\Downloads\Computernames.txt 

$Results = foreach ($Computer in $ComputerList) { 
    $OS = Get-WMIObject -ComputerName $Computer -Namespace ROOT\Citrix\hdx\RTOptPack -Class Citrix_HDXRTConnector 
    $username = Get-WmiObject -ComputerName $Computer –Class Win32_ComputerSystem 

    [PSCustomObject]@{
        RTC_Status = $OS.RTC_Status -join ','
        RTME_Version = $OS.RTME_Version -join ',' 
        UserName = $username.UserName -join ',' 
    }
}

$Results | 
    Export-Csv C:\Users\username\Downloads\file.csv -NoTypeInformation
```

You use a loop to iterate over each single element of a list but you did not reference single elements inside your loop. You referenced the entire list instead. 😉

---

<div class="post-metadata">

**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\
**Post date:** [May 16, 2024, 8:29pm UTC](https://forums.powershell.org/t/exporting-an-array-to-csv/14474/3 "2024-05-16T20:29:27Z")

</div>

Closed on May 16, 2024, 8:29pm UTC


