Exporting Web Page Tables to Excel

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.

Free eBook!

Like what you read?

If so, please join over 28,000 people who receive our exclusive weekly newsletter and computer tips, and get FREE COPIES of 5 eBooks we created, as our gift to you for subscribing. Just enter your name and email below:

Post A Comment Using Facebook

Discuss This Article (Without Facebook)

Leave a Reply

PCMech Insider Cover Images - Subscribe To Get Your Copies!
Learn More
Every week, hundreds of tech enthusiasts, computer owners
and geeks read The Insider, the digital magazine of PCMech.

What’s Your Preference?

Daily Alerts

Each day we send out a quick email to thousands of PCMECH readers to notify them of new posts. This email is just a short, plain email with titles and links to our latest posts. You can unsubscribe from this service at any time.

You can subscribe to it by leaving your email address in the following field and confirming your subscription when you get an email asking you to do so.

Enter your email address for
Daily Updates:

Weekly Newsletter

Running for over 6 years, the PCMECH weekly newsletter helps you keep tabs on the world of tech. Each issue includes news bits, an article, an exclusive rant as well as a download of the week. This newsletter is subscribed to by over 28,000 readers (many who also subscribe to the other option) - come join the community!

To subscribe to this weekly newsletter simply add your email address to the following field and then follow the confirmation prompts. You will be able to unsubscribe at any time.

Enter your email address for
Free Weekly Newsletter: