TechTipsApp

Technology tips blog

  • Articles
    Categories
    • Tech news
    • Internet
    • Social Network
    • Google
    • Geeky Tips
    • Android
    • Windows 10
    Top Posts
    • Install Windows XP from USB
    • Install Windows 7 from USB
    • Open Facebook When It's Blocked
    • Partition Hard Drive Without Formatting
    • Reset Windows 7 Password
    • About
    • Contact
    • Privacy policy
    • Advertise
    • Terms of Conduct & Copyright Policy

How to Embed Live Spreadsheet in Web Pages

Tanmay Geeky Tips 10 Comments

Do you have some spreadsheets to embed on webpage? Do you want to make it live so that your further changes will get live automatically? Although, Microsoft Excel’s HTML feature is a pretty good option, but, here are some other substitutes to embed live spreadsheet on web page. Let’s check them out.

Embed Live Spreadsheet in Web Pages using Google Docs

Try Google docs to embed spreadsheet on any web page. Google Docs has included the feature that allows you to embed live spreadsheet on the web page. That means if you make any change in the spreadsheet in Google docs the changes will be reflected on your web page automatically.
At first, upload the Excel file (spreadsheet) to Google docs. Let Google Docs convert that in its own format when uploading. If you want to create excel sheet and then embed it, do create it using Google Sheets.
After converting, open the spreadsheet via Google Sheet. Then, navigate through Files > Publish to the web menu.
Publish Spreadsheet to Web from Google Docs
Go to “Embed” tab and select sheet number or entire document that you would like to embed.
Get Embed Code for Google Spreadsheet
Now, make sure that the option called “Automatically republish when changes are made” is selected. Otherwise, the embedded spreadsheet will not be updated according to your changes.
After that, hit the “Publish” button and copy the iframe attributed code. You can paste this exact code anywhere to showcase your spreadsheet.
Read Also: Display Live Web Pages in PowerPoint Presentation Slides

Embed Live Spreadsheet on Web Pages using Excel for Web?

Microsoft has dedicated Office package containing MS Word, MS Excel etc. for Windows and Mac. However, they also offer their most popular and useful office tools i.e. Word, Excel etc. as a web version. You can make use of the web version of Microsoft Excel to ember live spreadsheet on any webpage.
To use web version of Excel, just go to office.live.com and create your document. Alternatively, if you already the excel sheet, you can upload it to your OneDrive account and open it via Excel for web. Then, navigate through FILE > Share > Embed.
Share Spreadsheet from Microsoft Excel
On the other next screen, you can generate HTML for embedding your spreadsheet. Just, hit the “Generate” button to get more options.
Generate HTML of spreadsheet for Web
Alike Google Spreadsheet, you can select either particular sheet or entire document to embed, hide/show grid lines (Not recommended), hide/show row/column headers, include download link, change aspect ratio and more others.
At last, copy the HTML code and paste it anywhere to display your live spreadsheet. On the other hand, you can also get Javascript if you want instead of HTML code.
Editor’s Note
Obviously, you can create spreadsheet using HTML on any webpage. In addition, this is also possible to generate HTML code for any spreadsheet using Microsoft Excel. This is also a good option but, these specific things consumes a lot of times as well as it has several drawbacks like,

  1. The spreadsheet you embed becomes static if you use Microsoft Excel’s default HTML embedding feature. That means, if you want to update the spreadsheet you cannot do that by modifying the existing code. You have to replace the entire code again again as per your changes.
  2. The data are not live.
  3. The user can’t copy the tabular data.
  4. It is tough to customize the table.

And so forth.
However, if you use this above mentioned trick to embed any spreadsheet on any webpage, you will get the following benefits,

  1. The embedded spreadsheet will be copy-able. That means, your viewers can check and copy if they want.
  2. You can edit the embedded file remotely. You can edit the file right from your Google Drive or OneDrive.

And more others.
Considering all the things, you should opt for these methods while embedding spreadsheet on any webpage.

Post Tags: Excel, Google Docs, Spreadsheet
Similar Articles from This Blog
How to Add Google Search to MS Word 2013, Excel 2013
How to Add Google Search to MS Word 2013, Excel 2013
How to Create Flowchart and Diagram
How to Create Flowchart and Diagram
How to Organize Online Quiz Contest With Google Docs
How to Organize Online Quiz Contest With Google Docs
Extract ZIP and RAR Files in Google Docs and Download Selected Content
Extract ZIP and RAR Files in Google Docs and Download Selected Content
How To Conduct Online Survey Using Google Docs
How To Conduct Online Survey Using Google Docs
Sync Microsoft Office and Google Docs with Data Synchronization Software OffiSync
Sync Microsoft Office and Google Docs with Data Synchronization Software OffiSync

Comments

  1. Tanmay :

    Google docs might remove that from the Sharing option. Therefore, the only way to share a document as a web page in Google Docs is to submit that in template gallery.
    Another great tool is Zoho Sheet.

    Reply
  2. DataWiz :

    An alternative is to use Excel Web App, which is a web version of Microsoft Excel, and is live. See an example here: http://datawiz.wordpress.com/2011/01/11/visualize-your-data-with-interactive-charts/

    Reply
  3. android free app :

    great. i have just used this info to make a live table on my page from google docs

    Reply
  4. Daniel :

    What do you mean by “it’s not live”? when i change data in my excel spreadsheet in skydrive, my google site changes the data after pushing F5 also.

    Reply
  5. Matt :

    There is another site called jsondata.com which lets you input your data then once finished it gives you an embed code much like youtube. This is also code that allows for live updates.

    Reply
  6. Sara :

    Amit, what do you mean by “publish as a web page from sharing options”? Do you mean sharing the document to the public? And what is the iframe embed code?
    Thank you!

    Reply
  7. Mariam :

    Not sure about how easy it is to share google docs, but I find working with Collate Box , this new concept, much easier ! Great for sharing online spreadsheets and mobile workforce management.

    Reply
  8. Amrul Ismail :

    Google Spreadsheet is not exactly ‘Live’. When u embed the code generated from ‘Publish to the web’ option, the viewers will need to refresh their browser in order to view any adjustments made to the spreadsheet. You can however display ‘live’ feed by replacing the link with the url generated from ‘sharing – anyone with link can view’ option but unfortunately this will display along the menu, and all the row and column ruler.
    I’m not sure what Ms Excel can do.

    Reply
  9. Prasad :

    Embed option is not displayed in File-> share->embed. please help

    Reply

Leave a Comment Cancel reply

Your email address will not be published. Required fields are marked *

About Us

Tech Tips App is a technology blog, looking forward to broaden the mental horizons of technical geeks round the web. Striving hard to quench your technical thirst, we have put our best efforts on the line of exhaust to satisfy your versatile technical vocabulary.

Recently Published

  1. Partitioning Hard Drive in Windows 7 Without Formatting
  2. How to Find My Contacts on Google Map
  3. Introducing SMS Organizer by Microsoft is the Best SMS App
  4. How to Fix Windows Update When It Gets Stuck
  5. How to Get Rid of Windows 10 Automatic Repair Loop [Solved]
  6. Best Antivirus for Windows 10 (Is Windows Defender Good Enough?)
  7. Best Facebook Messenger Bots to Get more out of Messenger
  8. How to Fax a Document From Your Smartphone
  9. Top Social Media Platforms You Should Always Know About
  10. Bitcoin vs Altcoin: Where to Invest? – Guide For Dummies

© 2021 Tech Tips App All Rights Reserved  Post Sitemap