How to Insert .txt file data into excel with proper format

anyone has a solution to insert data from text file to excel
please find attachments in text file first row is a column header and after second line its data which is separated by (|), in attached file only sample data actually its thousands of linesRow (5.5 KB)

@suraj23 Please find below file, it will work

textToexcel.xaml (15.3 KB)