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