How to convert txt file to excel

[prashant1603765 (Prashant Kumar)]

Hi @pabaleloh

Pls check this link for same,

Text file to Excel file conversion

Hi hope the below steps would help you resolve this Use a READ TEXT FILE activity where pass the filepath of text as input and get the output as string named Strinput Then use a GENERATE DATATABLE activity and pass Strinput as input variable and get the output as dt DATATABLE Now use a WRITE RANGE activity and pass dt as input and enable add headers property and mention the filepath where you want to write Mention the column separator as “ “ A space that’s it [image] Cheers @Priy…

OR

Convert txt to excel?

I want to convert txt and write it in excel. text.txt (137 Bytes) [image] I want copy in column Flag_RM_Return = B only And Write in file excel ( write next row from input file) File Input as below. Ex code Lot.xlsx (18.5 KB) [image] I want to copy data from text file to file input as below. [image] *write in Column Status if column Flag_RM_return = B —> write text ตัดออก Please guide me about it.

If you found helpful, Mark as a solution tick .
Happy Automation