download data to excel from web

This simple tutorial will show you how to download data into an excel spreadsheet, creating a web query.

Download data into excel

select “data” tab

 

select “from web”

 

 

input the desidered web URL

click “go” button

select data you want to download

click “import” button

---

Refresh downloaded data

 

select “data” tab

select “connections”

select your connection

click “refresh” button

 

Advertisement