Display Excel Data On a Web Page


How to quickly display data from a Microsoft Excel spreadsheet online


Display Excel data on website

At the company where I’m working we have a marketing calendar in MS Excel showing schedule for different marketing events and activities. The file is maintained by marketing and regularly updated with new speaking engagement opportunities or changes of venues to current events. And every time we updated it, we put a copy on a network or shared drive so that other people can access it. Later, we made it a little easier to access by putting a link to the Excel file on a web page.

The ways above might have worked in the past, but today when the workforce becomes more mobile and global, people want to see the spreadsheet content online with their smart phones [that don’t have Excel installed] or with their home computers [that may have Excel but with a lower version] whenever and wherever they want.

Display Excel data on a separate web page

To solve the problem, Excel has a simple but great functionality that is possibly overlooked by most users: save the spreadsheet as an HTML file (or HTM file in Excel language). The File > Save As functionality also outputs the excel tabs and charts! More information can be found on the Microsoft website.

All you need to do is to click File > Save As > Web Page (.htm). Excel will output an HTML file and a folder to hold the associated files/data. Push everything on the live server, then link to it from a web page, and your’re done.

Click here to see an example of a spreadsheet saved as a web page. Don’t forget to check out the tab at the bottom.



Display Excel data on your current web page with iframe

As you can tell from the above demo, you can now see the Excel data online; however, the excel web page is a separate or stand-alone web page and doesn’t look like the rest of your site. What if you want to display the Excel data on a web page with your current website template — with the branding, logo, site navigation and everything?

Another simple solution, not perfect, but workable is to use iframe. If you don’t know what it is, get more information on W3school website. Iframe is just an HTML tag that let you hold and display information from a URL inside itself. Below is the same example above, but displayed directly on the web page.



Basically, you’ll need to add the following HTML code to your web page.

<iframe src=”http://www.yoursite.com/yourexcelfile.htm” height=”400px” width=”650px” frameborder=”0″></iframe>

Note: If your height and/or width is big enough, the corresponding scroll bar will become hidden.

Hope that this is useful!



Related Posts:



Comments


  1. Pretty useful tip. I had to do this once in the past and ended up creating an html version instead with the screen shots of charts and everything, pretty time consuming. This way seems much much faster.

  2. Very simple but helpful. Didn’t know Excel has that save as option.

  3. Big thanks! I’ll hand this to our web guy and this would save us tons of time and give us more control.

  4. Very useful and well explained. Thanks a ton!

  5. it is very useful. good writing. thanks a lot!

Leave a Comment