Convert Text file to Excel file

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.

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

hi this is giving output like this,

used the same:

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


Thank you.

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