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.
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.
For example, you have a pricing table in a Google Sheet that looks like this:
After you will have a beautiful responsive table that can be embed to your WordPress website:
Open your Google Sheet that you would like to embed into your website
For embedding Sheet2Site will use your first left sheet (tab). If you would like to embed another sheet, simply drag and drop this particular sheet to the left side to make the first.
Sheet2Site WordPress Plugin was made exactly for this purpose. It will embed your Google Sheet to the WordPress website page and keep update it automatically.
Now let's embed Google Sheet to your WordPress website. Here is what you need to do:
You can copy it from your browser address bar:
Click Publish and once again Publish to confirm
You should see embedded Google Sheet in your WordPress website:
After this step your Google Sheet will be embed into your Website.
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.
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.
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
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:
Explore More Table Website Examples that were Made by People using Sheet2Site
Let's embed your Google Sheet today!
If you need any help about embeding Google Sheet to WordPress website please message me in the chat in the right corner and I will be happy to help you.