> ## Content Index
> Fetch the complete content index at: https://kudithipudi.org/llms.txt
> Use this file to discover other available public pages before exploring further.

# Excel : Import tables from web pages
- URL: https://kudithipudi.org/excel-import-tables-from-web-pages/
- Published: 2005-11-09T06:29:55.000Z
- Updated: 2005-11-09T06:29:55.000Z
- Description: Ran into a bit of a tough nut the other day. One of my colleagues was trying to gather data from a HTML page and run...
- Author: admin
- Tags: Technology, Uncategorized, Web, Windows, #wp, #wp-post, #Import 2026-08-23 02:32

Ran into a bit of a tough nut the other day. One of my colleagues was trying to gather data from a HTML page and run some reports. He could scrape the page and copy the data into Excel, but any operations he tried on the data errored out. He tried every trick in the book (change format of columns etc) but it didn’t help.

A bit of [googling](http://www.google.com/?ref=kudithipudi.org) and found this new cool function in Excel 2003.

Go to “**Data –> Import External Data –> New Web Query**” in Excel and you check on this new cool method.

“F1” in Excel rules :)..