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, you can add it back manually.
Add “Export to Microsoft Excel” command to the Context menu
Launch Regedit.exe and navigate to:
HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\MenuExt
Create a subkey and name it as Export to Microsoft Excel
Double-click (default) and set its Value data as follows:
For Excel 2003
res://C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE/3000
For Excel 2007
res://C:\Program Files\Microsoft Office\OFFICE12\EXCEL.EXE/3000
For Excel 2010
res://C:\Program Files\Microsoft Office\Office14\EXCEL.EXE/3000
For Excel 2016
res://C:\\Program Files\\Microsoft Office\\OFFICE16\\EXCEL.EXE/3000
For Excel 2016 – Office 365
res://C:\\Program Files\\Microsoft Office\\root\\OFFICE16\\EXCEL.EXE/3000
Note: If using 32-bit Office on a 64-bit computer, the path would be C:\Program Files (x86)
instead of C:\Program Files
.
Hint: You can check the path to excel.exe by right-clicking the Excel shortcut in the Start menu and clicking Properties.
Exit the Registry Editor.
REG Files
To automate the above setting, download exporttoexcel.zip and save it to desktop. Unzip and run the appropriate registry file 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.
This imports the table into Excel.
One small request: If you liked this post, please share this?
One "tiny" share from you would seriously help a lot with the growth of this blog. Some great suggestions:- Pin it!
- Share it to your favorite blog + Facebook, Reddit
- Tweet it!
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 🙂
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.
Can you help me how to export to Open Office Calc
thanks 🙂
That feature in IE 9 is not working anymore. Some genius at Microsoft decided not to make it available. The ability for IE to export to Excel was an added value in a highly competitive browser market.
Thanks for the guidance followed each step word by word and got the thing up and running, may God Bless you.
this article is clearly explain me about “Export to Microsoft Excel To the Right-Click Menu in Internet Explorer”. but, shall i get this option in Firefox or any other browser?
Exelente! Es exactamente lo que estaba buscando. Muy bien explicado.
any idea, how to get n number of pages exported ? Because i have noticed that option is working for 1st page, if we have n number of pages to be printed. Can anyone help me to get the issue sorted ?