To import and connect a website in an Excel sheet, you can do as these:
1. Click Data > From Web.
doc import connect website 1
2. Then in the New Web Query dialog, type the website address you want to import into Address textbox, and click Go to display the website.
doc import connect website 2
3. Click Import, and the Import Data dialog pops out for selecting a cell or a new sheet to place the webpage content. See screenshot:
doc import connect website 3
4. Click OK. Now all webpage content excluding images have been imported in the sheet.
doc import connect website 4
5. Then select the whole worksheet, and then click Data > Properties in the Connections group. See screenshot:
doc import connect website 5
6. In the External Data Range Properties dialog, check the options as you need in Refresh control section and click OK.
doc import connect website 6
7. Also you can refresh the sheet contents by manually clicking on Refresh All > Refresh All/Refresh.