1. Open Excel

  2. Go to File, Open

  3. Select the text file.  If it is not showing, chose the option to show all files.

  4. Select Delimited

  5. Click Next

  6. Uncheck Tab

  7. Check Other, type | in the box

  8. Click Next

  9. Click Finish