1. Export the file as text (*.txt).
     
  2. In Excel, select File, Open from the menu bar, and select the TXT file.
     
  3. The Excel Text Import Wizard is automatically activated.  In step 1, select Fixed Width and click Next.
     
  4. In Step 2, follow the steps to create column breaks. Click Next.
     
  5. In step 3, highlight the column with the import ID (or data formatting as date), and select Text. Click Finish.