Using Read Columns and Type Into Activities

Hello UiPath community!

I have been dealt a task to read from an Excel Sheet, which defines its data into columns.

My end goal : For the robot to read every column and input the values into a Google Form, and the robot knows that the first column is the header.

I want the robot to understand that the first column is the headers. And for the second, third and fourth columns to represent three individual persons.

Once that is achieved, I want to use the TypeInto activity to key this info into an eForm.
Thanks a lot!

Test Data UiPath Help.xlsx (8.2 KB)


You can refer below post

Above post will clear you how to make as the first column as the headers

and also you can place a typeinto inside the for each row

Hope this helps you



Thanks for your answer. Actually this is not what I want.

What I want is that for example:

All the values in Column A are denoted as headers.
Then all the values from Column B onwards are data, whereby

The whole Column B represents one applicant, the whole of Column C represents one applicant, the whole of Column D represents one applicant and so on and so forth.

This is the structure for my Excel Sheet.