You’ve probably heard that you should never use tables on your website. Well, tables refers to an old way of laying your website out before css came along so of course that’s correct. But then sometimes you do actually need to add a table to your website and you’ll soon find out it isn’t the easiest thing to do. You may even have a rota or table that you need to keep up to date for others to look at and things start to get even worse! But don’t worry the new Google Sheets is here to the rescue!
Google Sheets is the new name for Google Spreadsheets announced in December 2013 on the official Google Blog. Without exploring all the new features here one of the great things you can do with Google Sheets is create a table and embed it on your website and hey presto, it will automatically stay up to date. This is a great solution for putting a table on your website that will always be up to date. If you know anything about rotas you’ll know they are out of date almost immediately so there is not much point in sending round a PDF or Spreadsheet document to people. What you need is a place online people can refer to and now you have one!
After you’ve created your table go to File/Publish to Web and hit the Publish to Web button which will ask you if you want to republish for changes – of course you do! From here you’ll get a document link and an embed code. If you don’t need it on a website but just want the live table then use the document link or use the embed code for your website. Of course there isn’t much choice over styling apart from height and width but it’s pretty neutral so you should be able to live with it and it comes with a nice message that the table is refreshed every five minutes so people know it’s up to date!
Here’s an example of a simple Google Sheet I created to embed in this post to show you. Hope you enjoyed the post and stay tuned for more next time by subscribing to the blog or leaving a comment to let me know if this would be useful for you. Only point I would make is that the new Sheets doesn’t give you the option to change the width and height but the old version still does for now.