How to get data from text file to Excel file

[rajthyaga53]

Hi , i need to read a data from text file line by line and store that in excel single column

this is the text file

it should look like this in excel

[supermanPunch (Arpan)]

Hi @rajthyaga53 ,

Could you try using the Generate Datatable Activity like shown below :

Pass the text file data to the Generate Data Table Activity Property Input and Configure it as provided in the Screenshot.

Let us know if this works.

[rajthyaga53]

i tried it , but its showing like this

all data should be in single column

[Sudharsan_Ka]

HI @rajthyaga53

Remove the column separator and try again

Regards
Sudharsan

[Sudharsan_Ka]

@rajthyaga53

Try this way and let us know

Regards
Sudharsan

[rajthyaga53]

its getting all data into single cell i guess

[Sudharsan_Ka]

Can you send that text here @rajthyaga53 ?

[rajthyaga53]

actually im downloading this data from server as text file
output.txt (312 Bytes)

[Sudharsan_Ka]

@rajthyaga53

Try like this

GeneratingSingleColumn.xaml (8.7 KB)

SampleColumn.xlsx (7.3 KB)

Hope this helps!!

Regards
Sudharsan

[supermanPunch (Arpan)]

@rajthyaga53 ,

Apologies. After using the text file provided, we have the configuration for the Generate Datatable Activity as below :

Let us know if this does not work.