Export Tabular Data On A Web Page Into Excel

Monday, July 24th, 2006
by Diana Huggins

If you are browsing the Internet and come across tabular data you want to save to Excel, you can do just that. For example, maybe you want to save financial or statistical data you found on a Web site into a spreadsheet. You could open Excel and start typing in the information manually.

Since this can end up being very time consuming, you may want to use the shortcut method. Simply right-click the Web page that contains the data you want to export and click the Export to Microsoft Excel option. Excel will automatically open (if you have it installed on your), and the data will be exported for you. Keep in mind that this will only work for tabular data.

Tags: excel, office, diana huggins, tabular data, convert web

7 Comments

Dan Bromberg

October 15th, 2006
at 10:36pm

Your article states: “Simply right-click the Web page that contains the data you want to export and click the Export to Microsoft Excel option.” I’m using IE6 and upon right-clicking on a table I see no “Export to Microsoft Excel” option. Any suggestions?
Thanks,
Dan

Terence

January 23rd, 2007
at 7:08pm

Agreed with Dan Bromberg, I also cannot find such a feature. Was it even tried and tested successfully?

Eddie

January 31st, 2007
at 11:31pm

I have this option using IE 7

scott

February 16th, 2007
at 1:24pm

I build websites and I am looking to add a function to export dynamic table to an excel spreadsheet

Chris

May 23rd, 2007
at 6:33am

As far as I know this is a function that comes from installing excel on a windows PC.

We have written web applications that have custom export to excel options in them but recently we also started telling our users to use export to excel from the right-click menu too.

Recently we obtained a new suite of PC’s and after re-installing windows vista and office on them this option disappeared - it worked previously on IE 6 and 7 on windows XP

I’m trying to track down how to turn it back on now and will post again when I have a solution

Chris

May 23rd, 2007
at 7:27am

Have worked out a solution and have posted it here:

http://www.christopher-dean.co.uk/?p=70

Please feel free to comment with questions, I will try to answer them if possible

jon

July 15th, 2008
at 2:31am

i need a program that does exactly this for me, but instead for a lot of websites (44,000 to be exact)

any ideas?

What Do You Think?

Want to Start a Blog Here for Free?

Are you an expert in one subject or another? If your goal is to help others and dispense hard-earned information back to the community, stake a claim on your very own Lockergnome blog today! You can write about anything - no matter the topic. Sign-up to start blogging!