From txt file to excel

I have a txt file that I would like to put in excel
Txt file like this:

Become Excel file like this

Any suggestion

Hi @rne,

You can achieve it using Read CVS and Write Range Activities.

  1. Read CVS
  1. Write Range

Try to do it and let us know :slight_smile:

Do you Know UiPath Academy ?

The UiPath RPA Academy is a valuable resource for all the RPA developers out there - not only for experienced ones, but also for beginners . Video tutorials, practical exercises, and evaluation tests are there to enhance your knowledge on the UiPath components and their functionalities . In the end, everyone who finishes the courses successfully receives a UiPath Diploma . Join now!

Best Regards,

1 Like

Thanks Susana, I will try :slight_smile:

1 Like

After reading text file as string, Use generate datatable, Click generate datatable and use preview options to see the output.



Use the Output datatable in Excel Write range to write in excel

1 Like

you can also just create excel file go to data tab and click on from text,
select the text file then in dialogue select delimited and specify , as a separator.Capture


Thanks to all of you for your quick replies. It was my first topic in here and you are amazing. Thanks again.

1 Like