Importing Files Into Excel 2019

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. Select Text

10. Click Finish