Home > Microsoft Excel, Web > Use the Web as a Data Source

Use the Web as a Data Source

As you have probably already seen, Sunset Reports can use an Excel Workbook as a data source.  Excel has the ability to pull data from a Web Page using what is called a Web Query.   When you are in Excel choose the Data tab on the ribbon bar, and then choose the item “From Web”.   You can pull data from a section of a web page and have it inserted into a worksheet.   If the inserted data is formatted with headers, give it a range name, and now you have a web based data source.   Be sure to setup the options to have the data extracted when Excel is opened so the data is refreshed automatically.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s