title: Displaying csv in powershell
body: <p>I have a CSV that I created and I'm trying to run an Import-CSV command on it.  From examples I've seen, the data is displayed in a nice table format.  However, I can not get my data to look that way.  If I open it in Excel, everything is is it's own cell block.  Below is some of my data, how it is displayed, and what I am expecting:</p>
  
  <p>Data:</p>
  
  <pre><code>Directory,Name,Length,CreationTime,LastWriteTime
  \\foo\foofoo\nightly.188\share\name,name.pst,271360,6/4/2009 2:42:21 PM,6/9/2011 8:58:50 AM
  \\foo\foofoo\nightly.188\share\name,name2.pst,71123968,10/5/2010 2:41:56 PM,8/1/2011 4:08:32 PM
  </code></pre>
  
  <p>Data output:</p>
  
  <pre><code>Directory     : \\foo\foofoo\nightly.188\share\name
  Name          : name.pst
  Length        : 271360
  CreationTime  : 6/4/2009 2:42:21 PM
  LastWriteTime : 6/9/2011 8:58:50 AM
  
  Directory     : \\foo\foofoo\nightly.188\share\name
  Name          : name2.pst
  Length        : 71123968
  CreationTime  : 10/5/2010 2:41:56 PM
  LastWriteTime : 8/1/2011 4:08:32 PM
  </code></pre>
  
  <p>What I'm expecting:</p>
  
  <pre><code>Directory                            Name        Length      CreationTime             LastWriteTime
  \\foo\foofoo\nightly.188\share\name  name.pst    271360      6/4/2009 2:42:21 PM     8/1/2011 4:08:32 PM
  \\foo\foofoo\nightly.188\share\name  name2.pst   71123968    10/5/2010 2:41:56 PM    8/1/2011 4:08:32 PM
  </code></pre>