Getting Data from Web site to Excel Excel 2003 and 2007 When you find the page you want, copy the URL.
To create a web query of the data on the page you've chosen, open a new workbook in Excel. Then choose Data, Import External Data, New Web Query. When you do so, Excel launches the New Web Query window, which resembles a web browser. This browser begins to open your normal home page. paste the URL that you copied from your web browser into the address bar of the New Web Query browser.
Use text to columns to put data in correct columns