Tweet
Importing Online Data Tables into Excel
Posted on August 16, 2007
Filed Under Excel Tips | Questions or Comments
This is a useful trick for researchers and gathers of data, especially for you fantasy football die-hards looking to import pre-draft rankings or last year’s football statistics into excel.
If you cut and paste any online table of data or information into excel, you get alot of annoying html markup and formatting that is carried over with the table. To avoid this and get clean text and numerical data, excel has the ability to query a webpage and import the data only. Here are the steps to use this helpful feature:
Have open in a web browser or know the web address of the table you want to download.
In Microsoft Excel, select: Data, Import External Data, New Web Query.
In the interface that opens, paste or type your web address and click “Go’
You will now see the webpage you have navigated to, all the tables will be marked with a yellow box with a black arrow, you may now select specific tables by clicking these boxes or just hit ‘Import’ to bring in all.
You will now be asked where to dump the data into your excel sheet and you’re done.
Hopefully this will make your research or fantasy football research just that much easier.
Posted on August 16, 2007
Filed Under Excel Tips | Questions or Comments
This is a useful trick for researchers and gathers of data, especially for you fantasy football die-hards looking to import pre-draft rankings or last year’s football statistics into excel.
If you cut and paste any online table of data or information into excel, you get alot of annoying html markup and formatting that is carried over with the table. To avoid this and get clean text and numerical data, excel has the ability to query a webpage and import the data only. Here are the steps to use this helpful feature:
Have open in a web browser or know the web address of the table you want to download.
In Microsoft Excel, select: Data, Import External Data, New Web Query.
In the interface that opens, paste or type your web address and click “Go’
You will now see the webpage you have navigated to, all the tables will be marked with a yellow box with a black arrow, you may now select specific tables by clicking these boxes or just hit ‘Import’ to bring in all.
You will now be asked where to dump the data into your excel sheet and you’re done.
Hopefully this will make your research or fantasy football research just that much easier.
Comment