# Format List Properties into Excel
**URL:** https://forums.powershell.org/t/format-list-properties-into-excel/6657
**Category:** PowerShell Help
**Created:** [June 18, 2016, 5:36am UTC](https://forums.powershell.org/t/format-list-properties-into-excel/6657 "2016-06-18T05:36:54Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@drop-box](https://forums.powershell.org/u/drop-box)
#### Post date: [June 18, 2016, 5:36am UTC](https://forums.powershell.org/t/format-list-properties-into-excel/6657/1 "2016-06-18T05:36:54Z")
Hi,
I am trying to convert some output into nice CSV files for later reference.
E.g I am running in Office 365 Get-TransportConfig and it returns a list of properties and values. e.g.
AddressBookPolicyRoutingEnabled : False
AnonymousSenderToRecipientRatePerHour : 1800
I would like to export all of these values into a CSV with the column headings:
Property Values
AddressBookPolicyRoutingEnabled False
AnonymousSenderToRecipientRatePerHour 1800
Any help would be greatly appreciated.
Kind regards,
---
### Author:  [@graham-beer](https://forums.powershell.org/u/graham-beer)
#### Post date: [June 18, 2016, 5:49am UTC](https://forums.powershell.org/t/format-list-properties-into-excel/6657/2 "2016-06-18T05:49:34Z")
Hi DB,
you can use the ‘Export-CSV’ cmdlet. Simply pipe your ‘Get-TransportConfig’ cmdlet to ‘export-csv’, set the path and job done 🙂
---
### Author:  [@drop-box](https://forums.powershell.org/u/drop-box)
#### Post date: [June 18, 2016, 8:39am UTC](https://forums.powershell.org/t/format-list-properties-into-excel/6657/3 "2016-06-18T08:39:11Z")
Sorry this does not work, since all the values are returned in one row, and each property is a separate column.
I am wanting to substitute the property/value pairs into a custom table, with each on a separate row.
I guess I could reformat the data once it is already in CSV, but out of interest I would like to know how I might be able to manipulate the output in powershell.
---
### Author:  [@graham-beer](https://forums.powershell.org/u/graham-beer)
#### Post date: [June 19, 2016, 4:31am UTC](https://forums.powershell.org/t/format-list-properties-into-excel/6657/4 "2016-06-19T04:31:13Z")
DB,
you can use the Export-Csv -Delimiter “,” which should separate your output. If that does not help, pop your code up and i can see how the data is being outputted.
---
### Author:  [@dotnVo](https://forums.powershell.org/u/dotnVo)
#### Post date: [May 16, 2024, 8:41pm UTC](https://forums.powershell.org/t/format-list-properties-into-excel/6657/5 "2024-05-16T20:41:01Z")