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


#1

Hello,
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 Data.zip (5.5 KB)


#2

@suraj23 Please find below file, it will work

textToexcel.xaml (15.3 KB)