Exporting Web Page Tables to Excel

Posted Feb 25, 2007 | by Jason Faulkner | No Comments  

A really nifty feature of IE7 is the ability to export a table inside of a web page to Excel. Even if you are not a developer, this can be incredibly handy as static text, obviously, you cannot manipulate through a web browser. To export a page, simply right click anywhere on the page (but not in a data entry field) and select “Export to Microsoft Excel”. When you do this a wizard will open to walk you through importing the target table.

I’ve used this feature many times to bring tabular data directly into Excel so I can perform analysis on it (such as adding formulas, sorting, etc.) which is not available through the web interface. Try it when viewing your online banking information so you can get a list of transactions in a “usable” format.

Post to Twitter Post to Delicious Post to Digg Post to Facebook Post to StumbleUpon

Posted In: Daily Tips

If you like this, you might also like...

  • 5 FREE Solutions Guides
  • Weekly Newsletter (6 Years Running)
  • Special Deals & Announcements
  • Subscribe FREE

Leave a Reply

Let PCMech Be Your Hookup To What's HOT In Computers And Technology

  • Plain-English Guides and Resources
  • Our Top Picks for Free Software
  • A Special Gift From PCMech
  • Weekly Newsletter (6 Years Running!)

PCMech Poll

Would you get a Mac if expense was not an issue?

View Results

Loading ... Loading ...