Insert Interactive Tables in WordPress Posts Without Plugin Using Google Sheets

0
41

You can add interactive tables in your WordPress posts by using plugin or HTML. But I don’t suggest plugins as sometimes it can become a hindrance for your site speed. Also many of the bloggers are not familiar with codding. Then what’s the solution? You can insert tables in WordPress posts without plugin or HTML coding. You can use Google Sheets for this purpose. The table you are inserting using Google Sheets will retain the below four table features.

  • The table will be interactive that means you can navigate through the rows with your keyboard or mouse.
  • You can control the table length with pagination.
  • Your readers can sort your table if require.
  • You can update the table in Google Sheets and it will be automatically reflected in your WordPress post table.

I never compromise on page speed whether it’s on mobile or desktop. So if you prefer to go ahead with a plugin for inserting beautiful simple tables in your posts, after installation check with Google Page Speed Insight whether it’s not affecting your site loading time.

Tables in WordPress Posts Without Plugin

Finally one more thing before we start our tutorial. If you monetise your blog, my humble advice is never compromise on page speed. You can earn threefold more money with a blazing speed site together with a spiced up layout compared to a site with poor performance.

Google Sheets is a free online application with offline features. So the table you create by using Google Sheets will be of course free to use on WordPress.

When you insert interactive tables in WordPress posts without plugin and using spreadsheet table, the inserted table will look like and behave as below. If you satisfy with this type of responsive table in WordPress, you can continue with the tutorial.

How to Insert Interactive Tables in WordPress Posts Without Plugin

We use the Google Sheet Table Chart feature here to insert tables in WordPress. So you can also learn how to use Table Chart in Google Sheets. The main use of Table Chart in Google spreadsheet is to create a Google Sheet Dashboard as well as publish interactive tables on the web. It’s one of the chart which is not available in Excel.

Let’s begin.

Make your table ready in Google Sheets. You can refer our spreadsheet data above for creating your table.

Select your data.┬áThen from the Insert menu select “Chart”.

Insert Chart - Table Chart 1

From the “Chart editor” that appears on the right, select “Table Chart” under “Chart type”.

Insert Chart - Table Chart 2

We are now inching towards finishing the steps in Google sheets. Let’s move to the customisation part of table chart menu.

Under “DATA” enable “Use row 1 as headers”. Actually it depends. In our data the first row is with header label.

Insert Chart - Table Chart Step 3

Move to the next tab in the chart editor labelled “CUSTOMISE”. There make the following changes to add pagination and for colouring alternative rows.

Insert Chart - Table Chart Step 4

In the above enabling “Alternative row colours” will give your table a shaded colour in alternative rows. The “Show row numbers” will show the row number of your spreadsheet on the left. Click “Pagination” if when you want to control page number in the inserted table in WordPress and decide the row numbers in each page under “Page size.”

Now our last step to insert interactive tables in WordPress posts without plugin. To insert the Google Sheet table in to your blog post you require the embed code.

Click on the Chart Table you just created. You can see a three dotted menu on the right top corner.Insert Chart - Table Chart Step 5

Access this menu and click “Publish chart” to get the following options.Insert Chart - Table Chart Step 6

Go to “Embed” tab and click “Publish”. Just copy the code and in your blog post insert it. This way you can easily insert┬átables in WordPress Posts without using plugin and HTML coding.

LEAVE A REPLY

Please enter your comment!
Please enter your name here