Convert Text file to Excel file

[Anjali_Rani]

Hi can anyone help me into this,
I have this file test.txt (926 Bytes)

and i want to convert into datatable and store into excel file.
Please Help.

[Daniela_Colina]

Hi @Anjali_Rani,

You can read the text with Read Text File and then use string as Input for the the activity Generate Data Table with property ColumnSeparators with vbTab

[Anjali_Rani]

hi this is giving output like this,

used the same:

[Daniela_Colina]

Please use the Options… button to select tab as column separator and new line ad new line separator and then set CSV Parsing Property to TRUE

[Anjali_Rani]

Thank you.