# Change Format of Export-CSV output in powershell

**URL:** <https://forums.powershell.org/t/change-format-of-export-csv-output-in-powershell/3477>\
**Category:** PowerShell Help\
**Created:** [December 3, 2014, 7:34pm UTC](https://forums.powershell.org/t/change-format-of-export-csv-output-in-powershell/3477 "2014-12-03T19:34:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![karunanidhi-mishra](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@karunanidhi-mishra](https://forums.powershell.org/u/karunanidhi-mishra)\
**Post date:** [December 3, 2014, 7:34pm UTC](https://forums.powershell.org/t/change-format-of-export-csv-output-in-powershell/3477/1 "2014-12-03T19:34:09Z")

</div>

Hello everyone,

The below script works well for comparing two CSV files and exports output ,

#Comparing the PrePatchReport & PostPatchReport  
$file1 =Import-Csv D:\List1.csv  
$file2=Import-Csv D:\List2.csv

# get list of CSV properties

$props1 = $file1 | gm -MemberType NoteProperty | select -expand Name | sort  
$props2 = $file2 | gm -MemberType NoteProperty | select -expand Name | sort

# first check that properties match

if(Compare-Object $props1 $props2)  
{  
throw “Properties are not the same! [$props1] [$props2]”  
}

# pass properties list to Compare-Object

else  
{  
$CR=Compare-Object -ReferenceObject ($file1) -DifferenceObject ($file2)  
$CR|Export-Csv D:\Results.csv -Append -NoTypeInformation  
}

List1.csv

KBNumber  
2112212  
5656666  
2211000  
8897991

List2.csv

KBNumber  
2112212  
5656666  
2211000

and output is:

Results.csv

“InputObject”,“SideIndicator”  
“@{KBNumber=8897991}”,"\<="  
"@{KBNumber=7665756}","\<="  
"@{KBNumber=9837129}","\<="  
"@{KBNumber=1212111}","\<="

Kindly help me out in ways to improve the format of my output.

Expected Format is:

Results.csv

KBNumber  
8897991  
7665756  
9837129  
1212111

Thanks in advance…

---

<div class="post-metadata">

**Author:** ![oyvind-kallstad](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/oyvind-kallstad/32/810_2.png) [@oyvind-kallstad](https://forums.powershell.org/u/oyvind-kallstad)\
**Post date:** [December 3, 2014, 8:02pm UTC](https://forums.powershell.org/t/change-format-of-export-csv-output-in-powershell/3477/2 "2014-12-03T20:02:24Z")

</div>

Try replacing your last line

```
$CR|Export-Csv D:\Results.csv -Append -NoTypeInformation

```

with

```
$CR | Select-Object -ExpandProperty KBNumber | Export-Csv D:\Results.csv -Append -NoTypeInformation

```

---

<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:46pm UTC](https://forums.powershell.org/t/change-format-of-export-csv-output-in-powershell/3477/3 "2024-05-16T20:46:42Z")

</div>

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