How to export array to csv in powershell?

Question

$x1 = (1,22,333,4444)
$x1 | export-csv 'd:\123.csv' -Force

Then I get this:

How do I Get a table like this?:

colsw · Accepted Answer · 2017-08-17 15:39:58Z

9

CSV's don't just accept arbitrary data properly, you can use | Out-File x.csv to dump them out on individual lines, and then read it back in with Import-Csv specifying headers, but a proper CSV needs headers when it is saved.

if you want to save it out properly you need to convert it into an object where the numbers are actually "named" within an object so powershell can create a valid CSV.

1,22,333,4444 | ForEach {
    [PSCustomObject]@{Number = $_}
} | Export-Csv C:\++\123.csv -NoTypeInformation

-NoTypeInformation removes the #TYPE header.

that being said, Out-File is the only way it will match your 'expected' output table, you don't seem to be looking for a CSV here.

answered Aug 17, 2017 at 15:39

colsw

3,3661 gold badge18 silver badges29 bronze badges

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

Comments

user6811411 · Accepted Answer · 2017-08-17 19:23:19Z

1

This will create a proper csv file with a header:

ConvertFrom-Csv (1,22,333,4444) -Header Number|Export-Csv .\123.csv -NoType

Loaded in Excel cell A1 will be Number

This will create a fake Csv accepted by Excel and returning your sample table.

 (1,22,333,4444)|Set-Content .\234.csv

answered Aug 17, 2017 at 19:23

user6811411

Collectives™ on Stack Overflow

How to export array to csv in powershell?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related