![]() ![]() Next you may want to setup some options as far as how the import is gonna look. In the URL portion of the Excel Web Query window enter the URL of the web site you want to pull data from and click Go. So to create my basic Excel Web Query I open up a new workbook, find the ‘Data’ item from the menu then go to ‘Import external data’ and ‘New web query’. I decided to use some basketball stats from. Lets get started by creating a simple Excel Web Query. These are what we call Excel Web Queries. Basically you tell Excel where to look (web page) and what to copy (tables of data) and Excel will automatically import the data into a worksheet for you. Briefly, an Excel Web Query is a great way to automate the mundane task of going to a web page and copying the data into an Excel sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |