How to quickly display data from a Microsoft Excel spreadsheet to a webpage 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.
Note: You have the options to Save As the whole workbook, or just one spreadsheet or just the printable area. Depending on what option you’ll use the file size will get bigger or smaller. For my stuff, I usually choose to Publish one sheet, and publish only the Printable area. Also, any additional format that you put on the Excel file will likely result in bigger file size such as merged cells, unnecessary bullets/format etc. For my stuff, I removed all the extra formatting when possible.
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.