Best approach to read many fields from excel and paste /enter on webpage


I am new to uipath and want to implement below scenario.
I want to read data from around 30 cells on excel and then want to enter those fields on webpage.
Webpage is also having equivalent 30 fields
Can you please suggest best approach for that ?

Reading each excel cell and put details using type into is the only option ?



You can take all the data into a Datatable (using Read Range Activity) and iterate through the datatable to put the values on the website (Type Into)


Use Excel application scope
Read range activity (store variable in type data table)
Use fo reach row (pass data table variable here)
Use get row item (it will give ur cell store in string variable )
Use type into activity (pass string variable here)



Got the read range part but do I need 30 "Type into " activities ?


@Shashii No in one type into activity just pass variable it will iterate


if possible please share the example


@Shashii Can you share webpage you are trying to automate


for simplicity we can consider as its having only two fields.
Thanks for the time

How to import excel data into web application

@Shashii its not working for me attached zip file is for googe sign up page values are retrieved from excel and entered into sign up page check it (24.4 KB)

I want to Copy my Data from Excel Cell and Paste it in Web Post?
How to paste something from excel to the browser by using UiPath/
Data from excel to web looping
How to login to website by using excel input for credentials
How to choose a random cell in an excel sheet
Hi this is my first day to UI Path. Can anyone tell me how to automate login to web application.I am just able to open the website till now
Issue on looping on websites
Read data from excel sheet
To read the excel data and enter into the web application

Thanks Indra… but for 5 fields you used 5 Type into activities

So if on same webpage… In case there are 30 fields… do we require same number of type into activities ?
Is there any way by using which just one type into for all the 5 fields ?


@Shashii Yes If there are 30 fields in excel and 30 text box in web page than you need 30 type into actvity


Hi @Shashii,

Just got some idea on reducing the number of Type Into activities and wanted to share here.

If all the fields are in same web-page, instead of using 30 type into activities try using hotkeys(tab, enter,…)
row(0).ToString+ "[k(tab)]" +row(1).ToString+ "[k(tab)]"

Saranya K R




@Indra: I am using open office and getting following error. Can you help me with this.


@indra: Got the solution working further

closed #16