How to convert txt file data into Excel columns

Hi Folks,

i have txt file.
image

and i have 1 excel sheet with empty

i want to convert the above txt file into columns and need to insert into excel sheet.
PFB expected output.
image

Kindly help to provide any sample xaml file.

@anilkumar.vegi
Have a Look on the read CSV Activity, which will read in into a Datatable.

The resulting Datatable can be used within a write Ränge for writing IT to Excel. Ensure that add Headers is Ticked off

checking

@anilkumar.vegi
Find starter help here:
Demo_SemiColon_NoHeader.xaml (5.4 KB)
Demo_SemiColon_NoHeader.txt (21 Bytes)

Also good to know activities:


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