home | about | newsletters | contact | advertising | Shop | radio | membership | site map

Helping Normal People Get Their Geek On And Live The Digital Lifestyle

Free and Premium. Why Register?

Login: Password: Remember me

Exporting Web Page Tables to Excel

Posted Feb 25, 2007 by Jason Faulkner  

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.

Categories: Daily Tips

Fire Your Computer Guy!

A computer technician spills the beans and makes available the knowledge he has charged clients hundreds in service fees for. It is Computer Secrets Unleashed. Find Out More.

About the Author

Jason Faulkner is the man who brings you our daily tips. He is based in Atlanta, Georgia.

Free Weekly Newsletter

Weekly tech delivered straight to your inbox. Sign up and receive our free report: 20 Tips For Becoming a Technology Power User.

Name:
Email:
 

Featured Product of The Week

Getting Started with Ubuntu Linux

Getting Started with Ubuntu Linux

Now Playing on PCMech Video

Feature ImageHow-To: Buy A Computer Case

Feature ImageUsing Your Own FTP Server With Foxmarks

See All Videos | PCMech Channel Youtube Channel

Learn Your Laptop

  • See video on how to disassemble, maintain, and repair your laptop fast at www.learnlaptop.com.