Take the 2-minute tour ×

I would like to insert an Excel spreadsheet into a Web page but would like to change some of the data at the same time to make them more user friendly.

Is it easily possible?

Thank you for your help.

share|improve this question

closed as not a real question by Kev Nov 9 '11 at 13:16


Insert how? As a HTML table? –  Pekka 웃 Jul 16 '10 at 8:40
Yes Pekka, a html table –  user393621 Jul 16 '10 at 8:42
add comment

2 Answers

If you don't mind the security risks, you can activate ActiveX and embed the Excel spreadsheet in the web page using the <object> element (see these forum posts for some pointers). Don't browse the Internet with ActiveX enabled! You will get a virus or Trojan.

Note that the spreadsheet must be on a network drive that is accessible by all users.

If that isn't an option, then try Zoho Sheet or Google Docs. Drawback: You must give your previous data to a third party.

Last option: Use a web server to convert the Excel into HTML and use a JavaScript grid control.

share|improve this answer
OK. You mean I could import my Excel spreadsheet into Google docs, modify what data I want to modify but then how can I put the result into my page? –  user393621 Jul 16 '10 at 8:48
Follow these instructions: docs.google.com/support/bin/answer.py?hl=en&answer=55244 –  Aaron Digulla Jul 16 '10 at 10:12
Thanks a lot Aaron. That solves my problem. Cheers –  user393621 Jul 16 '10 at 10:24
add comment

Excel can export HTML files directly ("Save as...") What modification exactly do you want to do? Can you do them by hand? Do you want to automate them (how often you want to do the export?)

For small modifications, it's relatively easy to write a VBA macro (or just record it..).

share|improve this answer
A few of the data contained in the Excel spreadsheet need to be manually changed before putting the table on the Web, otherwise they would not be understood by visitors. I do not understand what is the easiest method to convert the Excel spreadsheet, change a few data and put the result on a web page as a table. –  user393621 Jul 16 '10 at 10:12
I'd probably change the data in the excel sheet before converting, then use "Save as ..." and choose HTML as output format. The resulting HTML file can be directly put on the web server. –  MartinStettner Jul 17 '10 at 17:46
add comment
