The Export to Microsoft Excel context menu option in Internet Explorer helps you export tabular data in a Web page to Microsoft Excel. If for some reason the Export to Microsoft Excel option is not added after installing Microsoft Office 2003/2007, you can restore it back manually.
Add "Export to Microsoft Excel" command to the Context menu
Launch Regedit.exe and navigate to:
Create a subkey and name it as Export to Microsoft Excel
Double-click (default) and set its Value data as follows:
For Excel 2003
For Excel 2007
Exit the Registry Editor.
REG Files
To automate the above setting, download exporttoexcel.zip and save to Desktop. Unzip and run the appropriate REG file (exporttoexcel07.reg or exporttoexcel03.reg) for the version of Microsoft Excel installed. To remove the option, run the file undo.reg.
Usage
Open Internet Explorer and browse a Web page containing tabular data. Right-click on the data and choose Export to Microsoft Excel. Select one or more tables by clicking the arrows corresponding to each table.
For more information, see Microsoft Office Online article Getting data from the Web in Excel.
Related Posts
- Preserve the Order of Internet Explorer Favorites When Transferring to Another PC
- Clean Up the Right-Click Menu in Internet Explorer 8
- How to Transfer Your Bloglines Feed Subscriptions to Google Reader or IE
- Transfer Your Internet Explorer Feed Subscriptions to Outlook 2007
- Error “Not a Valid Bookmark File” When Importing IE8 Bookmarks (Favorites) to IE7
If you enjoyed this post, make sure you subscribe to our RSS feed! We feature Tips, Troubleshooting information, Scripts and Utilities for Microsoft Windows Operating Systems!
Prefer an E-mail subscription?
Can you help me how to export to Open Office Calc
thanks :)
Thank you, thank you, thank you. Did the regedit and it worked great. Had a nasty rootkit plus a few other things on this machine and I few things were missing. Very much appreciate the help.
What about Office 2010/Excel 2010 ?
I navigated to HKEY_CURRENT_USER \ Software \ Microsoft \ Internet Explorer \
but there was no MenuExt folder (maybe cause I’m on a network?)
Did a search and found it somewhere else but the settings seemed to already be correct!?
Ran the exporttoexcel.zip and it’s resolved it, so thanks :)