This post is to show you how to display data from a Microsoft Excel spreadsheet online
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!