<div>
You did several typical beginner's mistakes:<br />

<ul>
<li>Piping <b>format-*</b> cmdlet output to a file. That does not work - that formatting is intended only for display in the console screen. You can make it work to create a plain text output, but that is not the what you should do.</li>
<li>Considering a CSV file to be an Excel file. That's wrong. CSV is a structured text file containing multi-column data with delimiters. Excel uses binary formats.</li>
<li>Posting a screenshot as attachment, and not using the &quot;embed&quot; feature, so we do not see it unless we download. I've changed that already (being a Topic Advisor, I'm able to edit questions).</li>
</ul>
First attempt usually is to <u>really</u> export to CSV, but on screen, to see what you would get:<br />

<pre><code class="code-1 nolinks" id="code-20-41763575-1"><span>&lt;# your code generating output #&gt; | Select &lt;# list of columns you want to keep #&gt; | ConvertTo-CSV -NoType</span>
</code></pre>
You can leave out the <b>Select</b> if you do not want to modify which columns to see.<br />
If that works, you just replace <b>ConvertTo-CSV -NoType</b> by <b>Export-CSV -NoType &lt;# path and file name #&gt;</b>.<br />
<br />
The most simple line is:<br />

<pre><code class="code-1 nolinks" id="code-20-41763575-2"><span>Get-PublicFolderStatistics | Export-CSV -NoTYpe C:\Temp\EE\PublicFolderStats.csv</span>
</code></pre>
</div>


<div>
I tried as you said before creating this question: <br />
Get-PublicFolderStatistics<wbr /> | Export-CSV -NoTYpe C:\Temp\EE\PublicFolderSta<wbr />ts.csv.<br />
<br />
Get-PublicFolderStatistics<wbr /> is fine.
</div>


<div>
Well, I tried too, and my results are fine. Your screenshot is doubtless the result of using <b>format-table</b>.
</div>


<div>
The reason I am using FT is because I need to list certain pieces of information in the statistics.<br />
<br />
get-publicfolderstatistics<wbr /> -resultsize unlimited | ft creationtime,lastaccesstim<wbr />e,.....<br />
<br />
Without ft being specified, my parameters will not be recognized. &nbsp;<br />
<br />
Thanks.
</div>


<div>
@Qlemo: a long week?<br />

<pre><code class="code-1 nolinks" id="code-20-41764654-1"><span>$stats = get-publicfolderstatistics -resultsize unlimited |  select-object creationtime,lastaccesstime,andothers</span>
<span>$stats | format-table</span>
<span>$stats | Export-CSV -NoTypeInformation C:\Temp\EE\PublicFolderStats.csv.</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
I am running a get-publicfolderstatistics<wbr /> in Exchange Management Shell to list a couple of properties of each Public Folder. &nbsp;The result is returned as expected. &nbsp;<br />
<br />
I then run the same command again and pipe the result to a CSV file, I see the result differently - please see the attached. &nbsp;<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w34/1112469/pf.png" target="_blank" title="Public Folder Statistics (86 KB)"><img alt="Public Folder Statistics" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/08_w34/800_1112469/pf.png" /></a>Please advise how to fix this. &nbsp;<br />
<br />
Thanks,
</div>
</div>


pf.png

I am running a get-publicfolderstatistics in Exchange Management Shell to list a couple of properties of each Public Folder.  The result is returned as expected.  

I then run the same command again and pipe the result to a CSV file, I see the result differently - please see the attached.  

Please advise how to fix this.  

Thanks,

Publicfolderstatistics result is not displayed correctly in CSV.

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

Exchange

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.