From txt file to excel

Help
1

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

Become Excel file like this
excelfile

Any suggestion
Thanks

2

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,
Susana

1 Like
3

Thanks Susana, I will try :slight_smile:

1 Like
4

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

image

image

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

1 Like
5

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

4 Likes
6

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

1 Like