Converting csv file into data table in uipath getting all column values in as single column value

Help Studio
, ,
1

Hi All!!!

i do have a csv file with the help of read csv file i am getting datatable but all row values in single column, you can see below

actual csv file look like

image

after converting to data table getting like this

image
image694×259 7.02 KB

let me know how i can make them in separate columns.

Thank you!!!

2

we would assume to handle / inspect the CSV file within a text editor (e.g. notepad++)
Check for used delimiter char and adapt the read csv file activity accordingly

1 Like
4

Hi,
you can use read text file activity for reading csv file then use generate data table activity as shown as below, click on options and separate your text as you want

image
image611×644 20.8 KB

5

HI @vineelag ,

I am facing similar issue , having the values accumulating in first column rather multiple columns .

Could you elaborate the solution please

Thanks