Holiday Deals are Here!

UP TO

35%

Discounts

Ending in:

Get Yours Now!
wpmet-website-logo
  • Home
  • Plugins
    • ElementsKit
    • ShopEngine
    • GetGenie AI
    • MetForm
    • WP Social
    • WP Fundraising
    • Wp Ultimate Review
  • About
  • Blog
  • Support
  • Contact
  • My Account
wordpress plugin

How to Create a Table Using Google Sheet in WordPress

Editorial StaffEditorial Staff Updated on: September 26, 2022 Elementor ElementsKit Tutorials 4 Min Read
how to create a table using CSV or Google Sheets in WordPress

Are you looking for an easier way to add data to your WordPress table than manual entry?

If yes, you should opt for CSV import or Google Sheet Integration because it will make the job easy. 

But how to create a table using CSV or Google Sheets in WordPress?  Well, Since it’s WordPress you can easily do this using a 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.

So, let’s dive in…

Contents hide
What are the Required WordPress Plugins?
How to create a table using CSV or Google Sheet in WordPress: Step by Step
Step 1: Enable the Table Widget
Step 2: Drag and drop Table widget of ElementsKit
Step 3: Choose Data Type as CSV from settings
Step 4: Upload CSV/Google Sheet
Step 5: Customize table settings
Step 6: Customize Style Settings
Step 7: Update and preview
Final Words

What are the Required WordPress Plugins?

To follow along with this tutorial, you will need WordPress plugins mentioned below:

  • Elementor (Free)
  • 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 steps guide.

Step 1: Enable the Table Widget

To use the table widget by ElementsKit, you need to enable it from the WordPress dashboard. Navigate to ElementsKit ⇒ ElementsKit ⇒ Widgets ⇒ Table Widget, then turn on the option and click on Save Changes to update.

enable table widget of elementskit - first step of how to create a table using CSV or Google Sheets in WordPress

👉👉 You can also checkout our blog on How to add modal popup in WordPress in just 3 steps.

 Step 2: Drag and drop Table widget of ElementsKit

Now, Navigate to All Pages ⇒ Pages and Click on Edit With Elementor.

Import csv data to WordPress table using Elementor page builder

On the left bar, Search for Table. Once you find the Table widget with the Ekit icon on the top right, drag and drop to the main page.

create table using csv or google sheet in wordpress

Step 3: Choose Data Type as CSV from settings

Now from the Content Settings Tab, choose data type as CSV file. You can choose three file types; Upload File, Remote File URL, and Google Sheet Viewer URL.

Elementskit widget data type how to create a table using CSV or Google Sheets in WordPress

Step 4: Upload CSV/Google Sheet

Have a look at three processes of uploading or selecting a CSV file. You can use the option you prefer.

✅ Upload 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 to WordPress table

✅ Upload CSV file located in remote server:

You don’t have to upload a CSV file to the server as your website is hosted at. 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 provide the location of your CSV file.

upload CSV file from remote server how to create a table using CSV or Google Sheets in WordPress

✅ Upload data via Google Sheet:

To use a Google sheet data in your WordPress table, choose the File Type as Google Sheet Viewer URL and enter the Google Sheet URL. 

🔔 Note: The google sheet URL should have Anyone on the internet with this link can view access.  

upload google sheet how to create a table using CSV or Google Sheets in WordPress

🔥 Great thing about using Google Sheets on the table widget is if you update information on the Google sheet file, your table data will get automatically updated.

After you upload data using your preferred data, choose the Header Alignment. Header alignment can be left, right, or center.

Step 5: Customize table settings

Now that you have your data, it’s time to customize the table settings: As part of the table settings you get the following options:

  • Search: You can enable or disable the search bar option.
  • Search Placeholder: Customize the text of the search placeholder using this option.
  • Fixed Header: You can set the header fixed by enabling this option.
  • Ordering: Turning on this option will enable the viewer to change the order of each column.
  • Responsive: This option will make the table responsive.
  • Pagination: Enable in order to add a pagination option to your WordPress table.
  • Nav Style: You can choose the nav style as Arrow, Text, or both. Depending on the choice you can set the arrow icon and texts.
  • Info: This option will add an info section on the bottom left portion of your table.
  • Entries: Turn this option to make the entries visible.
  • Entries Text: You can change the entries text here but it’s not recommended.
  • Show item per page: Choose how many rows of data you want to display per page.
how to create a table using CSV or Google Sheets in WordPress

👉👉 Looking for a cool review plugin to add reviews to your website? Checkout the Best WordPress Review Plugins (Ratings and Schema)

Step 6: Customize Style Settings

If you want to change the styles of the table, move to the Style tab and you will find various options to change the style of Wrapper, Header, Header Image, Body, Body Image, Search, Info, Entries and Navigation .

create a table using csv or google sheet in wordpress

Step 7: Update and preview

After making all the changes click on update and click on the preview icon to see the final table with CSV data. 

Here is a sample of how the table will look like

how to create a table using CSV or Google Sheets in WordPress

👉👉 You can also checkout our blog on How to Create Tables in WordPress with TablePress

Final Words

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. 

Get ElementsKit Pro Now
  • Share :

Ecommerce Website Checklist: Build Successful eCommerce Website from Scratch

Previous post

New Features of ShopEngine: Product Size Charts & Sticky Fly Cart

Next post

Leave a Reply Cancel reply

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

Get Subscribed Today!

wpmet-website-logo
© 2022, Wpmet. All Rights Reserved. Built with ElementsKit.
Elements Kit
ShopEngine
GetGenie AI
Metform
WP Social
Wp Ultimate Review
Wp Fundraising
About us
Contact us
Support
Login/Register
Collaborate
Affiliates
Affiliate Area
Privacy Policy
Terms and Conditions
Refund Policy
Payment systems accepted by Wpmet

Wpmet is not affiliated with or endorsed by Open Source Matters or the WordPress Project. The CMS logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Opt out!.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
Vendor/Partner
SAVE & ACCEPT