Usntructured Data to Datatable

[Ritaman_Baral]

I have some data in a word document in unstructured format which I want to store them in an excel in tabular format.
Please provide me the approaches currently available in UiPath.

Thanks,
Ritaman.

[vrdabberu (Varunraj Dabberu)]

@Ritaman_Baral

Read the document and store it in a variable

Use the generate data table activity and based on your requirements split the rows and columns and store the output in a variable

Use the write range activity and pass the output of generate data table activity into it and the data will be written in Excel sheet

Hope it works!!

[mkankatala (Mahesh Kankatala)]

Hi @Ritaman_Baral

=> Use the read Text activity and store the data in the word document in a String Variable. Output - (String Datatype)
=> Use the Generate Datatable from Text activity to generate the string to datatable. Output - (Datatable Datatype)
=> Use the Write range workbook activity to write the datatable to excel.

Note - You can customize the datatable format in the Generate datatable from Text activity. You can give the sample input in the activity and customize it to datatable. You can configure.

Hope it helps!!