Sticker Sticker
StickerSticker Sticker
  • 00

    DAYS
  • 00

    HRS
  • 00

    MINS
  • 00

    SEC
Sticker
FlexTable - Sheets to WP Table Live Sync

How to insert WordPress tables using Google Sheets: A beginner’s guide

How to insert WordPress tables using Google Sheets: A beginner's guide

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

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: A beginner's guide
Sheets to WP Table Live Sync 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.

Publishing to Google Sheets to WordPress Table Live Sync
Google Sheets to WordPress Table Live Sync

Choose Entire Document and select Publish.

Publishing to Google Sheets to WordPress Table Live Sync
Publishing to Google Sheets to WordPress Table Live Sync

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.

Copying to Google Sheets to WordPress Table Live Sync
Copying to Google Sheets to WordPress Table Live Sync

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.

Fetch data from Google Sheets to WP Table Live Sync plugin
Fetch data from Google Sheets to WP Table Live Sync

You will see the table is exported.

Google Spreadsheet to WP Table Live Sync
Exported Table

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.
Google Spreadsheet to WP Table Live Sync
Display Settings of SWPTLS

If you go to Sort & Filter, you will find some options there as well,

Sort and filter for Google Spreadsheet to WP Table Sync
Multiple options of Sort & Filter of SWPTLS

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.

Tools in Google Sheets to WordPress Table Sync. Embed Google Sheets to WordPress.
Tools in Google Sheets to WordPress Table Sync

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.

Manage tables in Google Sheets to WordPress Table Live Sync plugin
Manage tables

Also, you can update the table,

Update Google Sheets to WordPress Table Live Sync plugin Embed Google Sheets to WordPress
Updated Table

While you can delete the table from here as well.

Delete Google Sheets to WordPress Table Sync Embed Google Sheets to WordPress
Delete Table

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.
link support Embed Google Sheets to WordPress
link support Embed Google Sheets to WordPress

This is how you can set up Google Sheets to WordPress Table Live Sync plugin.

Conclusion

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.

Leave a Reply

Your email address will not be published. Required fields are marked *


Subscribe to get product updates

Get exclusive updates on discounts, product updates, WordPress news & tips