If you want to read data from a spreadsheet is not always a good idea. You need to know how to embed Google Sheets into WordPress tables, which is one of the driving factors behind a successful website.
In the past, you had to use a plugin or HTML code to build a table in a WordPress post or page.
In this article, we’ll show you how to create tables in WordPress posts and pages without using a plugin or any HTML code. We’ll also cover how to create advanced tables in WordPress with sorting and search features.
Table of contents
- Google Sheets for WordPress Table Live Sync plugin features
- How to install Google Sheets to WP Table Live Sync
- How to insert WordPress tables using Google Sheets
Google Sheets for WordPress Table Live Sync plugin features
This plugin has some unique features that set it apart from any other WordPress table plugin in the WordPress repository.
When you add or update your Google SpreadSheet data, the data in the table on your WordPress site will update as well. How cool is that? This is just the tip of the iceberg. This plugin has other features as well.
Powerful Features of the Plugin:
- Live Data Synchronization
- Leverage cache to ensure faster loading
- Shortcode Support
- Pagination Support
- Gutenberg Block
- Vertical scrolling
- Elementor Widget Support
- Unlimited row sync from Google sheet
- Export table from CSV, Excel, PDF, JSON
- 6 pre-built table styles
- Custom CSS
- And more.
How to install Google Sheets to WP Table Live Sync
To embed Google Sheets in WordPress you need to install the plugin. Installing the Google Spreadsheet to WP Table Live Sync Plugin is very easy and simple. You can easily install this plugin just like any other WordPress Table plugin. Also, you can install this plugin right on your website.
To install the plugin, navigate to WP Admin–> Plugins–> Add New. You need to type Google Sheets to WP Table Live Sync. You will find the WP Table plugin. Install and activate the plugin.
How to insert WordPress tables using Google Sheets
When you are done installing the WordPress plugin, you need a guide on how you can easily create a table that will fetch the data from your Google Spreadsheet.
Step 1: Starting with your first table
So, we are going to start with creating your first table using this Google Spreadsheet to the WordPress plugin.
Hopefully, you have a Google SpreadSheet already created. Otherwise, you need to create an excel sheet using Google Spreadsheets. However, we prefer you to use an existing one because the existing one will have more data.
After creating the sheet, click on the File option and click the Publish On The Web button. It will publish your sheet on the web and be easily accessible.
Choose Entire Document and select Publish.
For you to customize the table right from your WordPress dashboard you need to give the editor access. You need to click the Share button and give the Editor access.
Go back to the WordPress dashboard. There navigate to WP Admin–> Sheets to Table –> Create Table.
To make your WordPress table unique you need to pick a name. Select the Google Spreadsheet option from the drop-down box. Now, enter the URL on the sidebar. Click on the Fetch Data button to continue.
You will see the table is exported.
After the table is exported you can go to Display Settings and,
- Enable to show the table title
- Select default rows per page
- Enable info block
- Show X entries
- Swap filters
- Swap bottom elements.
If you go to Sort & Filter, you will find some options there as well,
If you navigate to Table Tools you will see that you can select how to import the table. Like CSV, JSON, PDF, Excel, Print, etc. Click on Save Table to finish.
Step 2: Managing the table
When you go to Sheets to Table –> Manage Table, you will find the shortcode for the table you created, for that table which you can use to insert the table on any page.
Also, you can update the table,
While you can delete the table from here as well.
Step 3: General settings
If you navigate to WP Admin–> Sheets to Table –> General Settings, you will find three options,
- Asynchronous Loading, when you enable this feature to load the table in the front-end after loading all content with a pre-loader. This will help your website load fast.
- Multiple Spreadsheet Tab, this feature will let you choose and save multiple spreadsheet tabs
- Table Connection: With this function will let you connect multiple tables on a single page.
This is how you can set up Google Sheets to WordPress Table Live Sync plugin.
As we said earlier, showing a lot of data without any proper organization can lead to disaster. And when you can’t show your data accordingly, you will lose the interest of your users. Because they won’t get or find the desired data they are looking for and will leave your site.
But when you use a table to show this data, then you can convince your users. If you have a table plugin like Sheets for WordPress Table Live Sync, then adding a table on your site won’t be a problem.