Need help - writing text to excel

[mneethu1845 (Neethu)]

Hi there, have read data from Get text and stored in txt file as below

would like to save it to excel as below

tried to replace new line with “,” and save it as excel but it saves as one row
a,1,b,2,c,3

any help is appreciated

[Hiba_B (Hiba Beldi)]

Hi @mneethu1845 !
Here is a suggestion
From_txt_to_excel.xaml (10.4 KB)
Let us know if it fits your expectations, or if you don’t quite understand what I did !
Also, if you have missing elements when you open the file, upgrade all your packages: I am using UiPath Studio 21.4, with the following versions of packages:

[mneethu1845 (Neethu)]

Works like charm! thanks