
There is a huge amount of people who face issues in creating tables using both CSV data and Google Sheets with the same WordPress plugin.
In this article, I will show you how you can easily create tables using both CSV data and Google Sheets with the same WordPress plugin.
Let’s find out how:
What are the Required WordPress Plugins?
To follow along with this tutorial, you will need WordPress plugins mentioned below:
Elementor
ElementsKit Lite & ElementsKit Pro
Once you have downloaded and activated the required plugins, move on to the next section.
How to create a table using CSV or Google Sheet in WordPress: Step by Step
Go through the steps to learn how to import data to your WordPress table using both CSV and Google sheet. It’s a 7 step guide.
Now upload the CSV File:
To upload a CSV file, click on the upload icon, upload the file and click on insert. If you already have a file uploaded to the server, then find the file and click on insert.
Upload CSV file located in remote server:
Using the table widget of ElementsKit, you can also display data using a CSV file that’s located on a different server. For that, choose the File Type as remote file URL and On the Enter a CSV File URL input field provides the location of your CSV file.
Upload data via Google Sheet:
To use Google sheet data in your WordPress table, choose the File Type as Google Sheet Viewer URL and enter the Google Sheet URL.
(Make sure the URL has viewer access turned on)
Step 5: Customize table settings
Now customize the table settings using the following options:
Search, Search Placeholder, Fixed Header. Ordering, Responsive, Pagination, Nav Style, Info, Entries,Entries Text, Show item per page
Now you know how to create a table using CSV or Google Sheets in WordPress and display tons of data in just a few steps. The best part about ElementsKit is along with the easy CSV import option, it also provides a lot of customization. So, use the customization options to change the look and feel of your WordPress table to your taste.
If you are interested in learning more about this topic and read the whole article, visit the link below:
How to Create a Table Using Google Sheet in WordPress