Skip to main content

Embed Interactive Excel Spreadsheets in Your HTML Website

How do you share spreadsheet data in your blog or webpages ? An immediate response would be to save the Microsoft Excel file in webpage format and then copy-paste that HTML snippet in your blog template.

While this approach may work, it has four major drawbacks:

1. The Excel-style interactivity is lost - all you get is a boring array of rows and columns inside an HTML table. You can't have live charts and diagrams.

2. The spreadsheet data becomes static. Later if you edit your original spreadsheet data, you'll have to redo the entire HTML to keep the webpage data in sync with the actual spreadsheet.

3. It is so tough [if not impossible] to select tabular data from an HTML table - the text formatting, font colors, sizes, and other visual enhancements are completely lost when copy that data from a webpage to another spreadsheet.

4. Site visitors cannot edit the HTML table data unless they copy-paste that to another spreadsheet inside Excel. They can't do calculations, add-delete cells, etc which are so basic to any spreadsheet.

So here's the complete workaround ?

To embed a Microsoft Excel spreadsheet into a HTML-page that closely mimicks an online version of Excel [in terms of interactivity, formatting, selection capabilities], we will make use of an excellent web spreadsheets service called ZohoSheets. Here's a step-by-step process:

Step 1: Import an existing xls spreadsheet or create one from scratch inside Zoho Sheets

Step 2: Once your spreadsheet is ready for sharing, click the Publish Menu and choose "Make Public & Embed"

Step 3: You will get a small snippet of HTML IFRAME code which can be added either in your blog posts or onto your webpages. You can also modify the height/width of the embedded spreadsheet to fit your site layout.

That's it. Your site visitors can work on this embedded sheet just like they are working on the desktop version of Microsoft Excel. It can even perform calculations, multiple cell selections and text formatting like bold or italic text.

Your readers will love the fact that these embedded spreadsheets can be directly saved on the local hard-drive as a Microsoft Excel document at the click of the button. And the price is so reasonable. Zero dollars.

The only concern I have with Zohosheets is that they take a while to load and the spreadsheets become available in the public domain of Zoho website as soon as you make them public.

Popular posts from this blog

How to Download Contacts from Facebook To Outlook Address Book

Facebook users are not too pleased with the "walled garden" approach of Facebook. The reason is simple - while you can easily import your Outlook address book and GMail contacts into Facebook, the reverse path is closed. There's no "official" way to export your Facebook friends email addresses or contact phone numbers out as a CSV file so that you can sync the contacts data with Outlook, GMail or your BlackBerry. Some third-party Facebook hacks like "Facebook Sync" (for Mac) and "Facebook Downloader" (for Windows) did allow you to download your Facebook friends' names, emails, mobile phone number and profile photo to the desktop but they were quickly removed for violation of Facebook Terms of Use. How to Download Contacts from Facebook There are still some options to take Friends data outside the walls of Facebook wall. Facebook offers the Takeout option allowing you to download all Facebook data locally to the disk (include

Digital Inspiration

Digital Inspiration is a popular tech blog by  Amit Agarwal . Our popular Google Scripts include  Gmail Mail Merge  (send personalized emails with Gmail ),  Document Studio (generate PDFs from Google Forms ) and   File Upload Forms ( receive files  in Google Drive). Also see  Reverse Image Mobile Search , Online Speech Recognition and Website Screenshots , the most useful websites on the Internet.

PhishTank Detects Phishing Websites by Digg Style Voting

OpenDNS, a free service that helps anyone surf the Internet faster with a simple DNS tweak , will announce PhishTank today. PhishTank is a free public database of phishing URLs where anyone can submit their phishes via email or through the website. The submissions are verified by the other community members who then vote for the suspected site. This is such a neat idea as sites can be categorized just based on user feedback without even having to manually verify each and every submission. PhishTank employs the "feedback loop" mechanism where users will be kept updated with the status' of the phish they submit either via email alerts or a personal RSS feed . Naturally, once the PhishTank databases grows, other sites can harness the data using open APIs which will remain free. OpenDNS would also use this data to improve their existing phishing detection algorithms which are already very impressive and efficient. PhishTank | PhishTank Blog [Thanks Allison] Related: Google