# How to get website results in to excel

#### guhanath

##### New Member
Hi,

I have a problem,

i want to get the data from one web site (internet) by running the multiple inputs which are input feed to that website (in the website have only one input box) via excel cell. in the web site, after giving one input data in to text box,and then after click on the 'go' button, the result will be shown in tablular format. i want this reslut in excel by giving the multiple inputs execute at a time. For Ex:

In the web site we have:
___
Login Name : | Text box | |go|
---
Result Table:
----------------------------------------
|Name | address | city | designation |
----------------------------------------
|AAAA |BBBBB |CCCC | DDDDDD |
----------------------------------------
|AAAA |EEEEE |FFFF | GGGGGG |
----------------------------------------

In Excel:

----------------------------------------------
|A |B | C |D
----------------------------------------------
|AAAA | | |
----------------------------------------------
|BBBB | | |
----------------------------------------------
|CCCC | | |
----------------------------------------------

By giving the above input via excel and it will run the website and get the values and pull the reslut data in to another sheet or same sheet in some other cell.like below(another sheet)

------------------------------------------------
|A |B | C |D
------------------------------------------------
|AAAA |BBBBB |CCCC | DDDDDD
------------------------------------------------
|AAAA |EEEEE |FFFF | GGGGGG
------------------------------------------------
|BBBB |BBBBB |CCCC | DDDDDD
------------------------------------------------
|BBBB |EEEEE |FFFF | GGGGGG
------------------------------------------------
|CCCC |BBBBB |CCCC | DDDDDD
------------------------------------------------
|CCCC |EEEEE |FFFF | GGGGGG
------------------------------------------------

Regards,
Nath.

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### guhanath

##### New Member
Hi,

And one more thing i forgot. the web site is secured web site (having https://)

Replies
3
Views
190
Replies
2
Views
4K
Replies
7
Views
2K
Replies
2
Views
2K
Replies
0
Views
413

1,191,418
Messages
5,986,451
Members
440,031
Latest member
davidvillegasr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back