How to convert txt file data into Excel columns

Hi Folks,

i have txt file.

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.

Kindly help to provide any sample xaml file.

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


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.