Need help - writing text to excel

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

image

would like to save it to excel as below

image

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

any help is appreciated

Hi @mneethu1845 !
Here is a suggestion :smile:
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:

Works like charm! thanks

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.