You can embed your Google Sheet Spreadsheet as a beautiful responsive table onto your WordPress website and apply the changes that you make in Google Sheet will be automatically update on your website.
Watch a Quick Video
You can watch this video to see how to do it in 4 minutes:
If you have an existing WordPress website and you want to embed your Google Sheet data onto it, this article will explain how you can do you exactly step by step.
You should see embedded Google Sheet in your WordPress website:
After this step your Google Sheet will be embed into your Website.
Advanced Table Options
You can cusomize your embedded Google Sheet on your WordPress website with some advanced feature such as images, links, call to action buttons, sorting, filters and search. Here is how you can do it:
If you want to add an image to your Google Sheet and showing it on your Word Press website you can just upload the image to any free photo sharing hosting even Google Drive will work. Most important that this link has an image format name, in the end, .jpeg, jpg, png.
To be able to display a clickable link in your table, simply add a link to a particular cell has http, https, or mailto in the start. It will be shown as a clickable link with a highlighted color.
Call to Action Buttons
You can change links to beautiful looking buttons on your WordPress website. Just rename your column to a Learn More-Button and a button for each cell of the column.
Hide Columns of your Google Sheet
If you would like to hide some columns from your embed Google Sheet you can add -Hide to a particular column that you would like to hide. Might be useful for some calculations. Example of how you need to name a column header: Current Year-Hide
One of most important feature of any table is a search. Search functionality is incuded by default. Searching is executing by default throught all cells in the sheet. If the data exist in any cell it will be shown.
When the user loads the website, the initial sorting of the table is the same as in your Google Sheet. If you will change the sorting in your Google Sheet, the website's table sorting will change as well
Sorting by a speficic column
Each column can be sorted separately when you click on the Table's header. The data type of the column is recognizing by default.
Current types that are supported:
Number: 20000 or 20,000
Explore More Table Website Examples that were Made by People using Sheet2Site