Latest

7 Best WordPress Table Plugins 2019

On the hunt for the perfect WordPress table plugin to display knowledge at your website?

On this submit, I’ve collected seven great free and premium options that can enable you to create tables with an Excel-like interface, import knowledge from exterior providers, create charts and graphs, plus more.

For every plugin, I’ll share:

  • Its key options
  • A hands-on take a look at its interface
  • The choices you could have for importing knowledge
  • Pricing details

Let’s dig in!

wpDataTables is a freemium WordPress table plugin with, for my part, the most effective interface of any plugin on this record. Past that, it’s also obtained a stellar function listing, with loads of options that will help you create interactive tables or great-looking charts.

And in the event you’re working with external knowledge, you get a lot of options for importing your knowledge, as properly.

At CodeCanyon, wpDataTables has properly over 21,000 sales while sustaining a 4.67-star score on over 950 critiques.

Key Features

  • Edit tables in an Excel-like interface – right in your WordPress dashboard.
  • There’s additionally a second “Standard” editor interface that allows you to edit utilizing varieties.
  • Tables are responsive by default, and you may choose exactly which columns get collapsed on cellular.
  • Import tables from quite a lot of exterior sources, including Excel, MySQL, Google Sheets, and extra.
  • Turn tables into lovely dynamic charts powered by Highcharts or Charts.js.
  • Let guests filter your tables on a per-column foundation.
  • Entrance-end table modifying, together with an choice to let users edit their own rows.
  • Excel-like options, like conditional formatting, formulation, and more.

Table Editor Interface

Again, wpDataTables has probably the most user-friendly interface of any plugin on this record, and it’s also simply usually considered one of my favorite plugins general when it comes to interface. So lengthy story brief – that’s an enormous promoting point.

To create your table, you’ll get this user-friendly setup wizard. You possibly can either construct a desk from scratch, or import it from an exterior source (more on that subsequent):

import options

Then, to truly edit your table, you get your selection of two interfaces, which you’ll be able to shortly change between:

Right here’s what the Excel-like interface seems to be like:

excel interface

And the Commonplace interface enables you to enter knowledge for a row in a popup like this, moderately than clicking in individual cells:

standard interface

Knowledge Import Options

With the premium model, you possibly can construct a table from scratch or import knowledge from:

  • Excel file
  • CSV file
  • Google Sheets
  • PHP Array
  • JSON
  • XML
  • MySQL query, both in your WordPress website’s database or any exterior database

For exterior sources like Google Sheets, you’ve two options. You possibly can:

  • Import the info as a one-time process and then edit it in WordPress.
  • Synchronize the table, in order that wpDataTables will load the newest version from the external source for each web page load.

And one other really neat thing concerning the MySQL query function is that wpDataTables may also help you build the question using a visible editor, so that you don’t have to be a SQL grasp to make use of this function.

Pricing and Particulars

Whereas wpDataTables is listed at CodeCanyon, you shouldn’t buy it from there until you want flushing money down the toilet.

Why do I say that? Nicely, if you are going to buy from CodeCanyon, you’ll pay a whopping $299. Then again, if you are going to buy straight from the developer’s web site, you’ll solely pay $59. So yeah – fairly an enormous distinction!

With that worth, you get one yr of help and updates for a single website. There are also two other licenses for:

  • three sites – $109
  • Limitless sites – $249

There’s also a lite version listed at WordPress.org, though it’s fairly limited and I feel there are better free desk plugins in the event you’re on a finances.

More Information / Obtain Demo

League Table

League Table is one other well-liked WordPress Table plugin obtainable on the market at CodeCanyon.

It provides you an Excel-like editor where you’ll be able to create responsive, sortable tables. One factor it doesn’t do, although, is create charts and graphs, which is something to recollect.

In response to CodeCanyon, it’s been bought over 2,000 occasions with a 4.78-star score on 95+ evaluations.

Key Features

  • Excel-like editor for modifying table knowledge
  • Tables are responsive by default
  • Type your tables based mostly on criteria that you simply apply to multiple columns
  • Use primary math formulation in cells
  • Plenty of type options for tables, rows, cells, and so forth.

Table Editor Interface

League Table’s editor is straightforward, however it makes straightforward to set the whole lot up:

League interface

To edit knowledge, you’ll be able to just click on in a cell and sort.

So yeah – nothing too flashy, but in addition straightforward to use.

Knowledge Import Options

You don’t want to make use of a devoted import function with League Table because you’ll be able to truly copy and paste straight from Excel or Google Sheets.

Nevertheless, this does mean you miss out on a few of the superior import choices that something like wpDataTables provides you, and it also means you possibly can’t maintain your desk synchronized with an exterior source.

Pricing and Details

League Table is sort of reasonably priced, coming in at just $23 with commonplace Envato licensing.

Extra Information / Download Demo

TablePress

TablePress is a popular free WordPress table plugin that’s lively on 800,000+ websites whereas maintaining a powerful 5-star score on over 3,500 critiques at WordPress.org.

One of the causes for this reputation is that it really is 100% free – even the various extensions you’ll find on the developer’s web site (although the developer does ask for donations when you’d wish to help the undertaking).

Beyond that, it’s just usually quite flexible and gives a variety of knowledge import options.

Key Options

  • Edit desk knowledge in Spreadsheet-like interface
  • A number of import options for Excel, CSV, HTML, JSON, Google Sheets
  • Choice to add front-end sorting, filtering, and pagination
  • Make tables responsive, together with selecting which columns to break down
  • Routinely sync your desk with an exterior source

Table Editor Interface

If you create a desk, you’ll first be capable of select the variety of rows/columns. Then, you’ll be able to enter content material in an Excel-like editor:

TablePress interface

It’s also possible to open an Advanced Editor for an individual cell, which lets you use more of a visible editor interface so as to add content material to that cell:

Advanced editor

Knowledge Import Options

TablePress enables you to import content material from:

You possibly can either upload a file or enter a URL, which helps you to import desk knowledge from Google Sheets.

With the Automated Periodic Table Import extension, you may also routinely sync your desk with an external source, like Google Sheets.

Pricing and Particulars

The core TablePress plugin is accessible free of charge at WordPress.org, and you may obtain all the extensions free of charge from the developer’s website.

With that being stated, the developer does specifically mark some extensions as premium with a beneficial donation amount. When you still can download these extensions free of charge, you must think about donating the advisable donation to assist help the undertaking.

Extra Information / Obtain Demo

data tables generator

Knowledge Tables Generator is another fashionable freemium WordPress table plugin. It could possibly assist you create responsive tables, along with accompanying diagrams, charts, and graphs.

You’ll be able to import from Excel, Google Sheets, and more. Or, you possibly can even generate a desk of your WooCommerce merchandise.

Key Options

  • Excel-like editor interface
  • Add custom knowledge formats, as well as dropdowns and date pickers in your table
  • Responsive tables, together with choices to regulate which columns collapse on cellular
  • Create charts and diagrams from desk knowledge
  • Search, type, and pagination options
  • A number of import options, together with direct database imports
  • Routinely sync with Google Sheets

Table Editor Interface

To edit your tables, Knowledge Tables Generator provides you an Excel-like editor along with wealthy media buttons so as to add textual content formatting, change alignments, insert pictures, and more.

To edit a person cell, you just click in and sort:

data tables generator interface

You can too insert dropdown selectors, date pickers, and extra into fields.

Knowledge Import Choices

With the free model, you’ll be able to only create your personal tables from scratch. Nevertheless, should you go Professional, you’ll get a bunch of knowledge import choices together with:

You can too generate knowledge straight from a database – either your WordPress website’s database or an external database.

And there’s also a built-in function that allows you to question WooCommerce products to create a WooCommerce product table.

Pricing and Details

The core version of Knowledge Tables Generator is out there without spending a dime at WordPress.org.

After that, there are three plans for the premium plugin:

  • 1 website – $39
  • 5 websites – $69
  • Unlimited websites – $149

Extra Information / Obtain Demo

Ninja Tables Pro

Ninja Tables is a freemium WordPress table plugin that has a well-liked itemizing at WordPress.org, in addition to a premium model with much more functionality.

Although wpDataTables has my #1 favourite interface, I also discover the Ninja Tables interface to be really nice to make use of. Nevertheless, it does not use an Excel-like editor. So if you’d like to be able to click on into particular person cells like you’ll be able to in Excel, you may choose a special plugin.

Key Features

  • No Excel-like interface – as an alternative, you’ll add your knowledge in a popup
  • Responsive breakpoint controls
  • Six totally different knowledge varieties for columns
  • Conditional formatting
  • Plenty of built-in fashion options
  • An excellent number of import choices, including the power to write down your personal SQL queries
  • Choice to attach table to the Fluent Type plugin
  • Frontend modifying

Table Editor Interface

Once you create a brand new desk, you’ll first use the Add Column button so as to add all of the columns in your desk and choose:

  • Knowledge varieties
  • Responsive settings

Add column

Then, you’ll be able to click on the Add Knowledge button so as to add your knowledge in a popup, where you’ll enter the data for every column:

Add data

With the Professional version, you can too add frontend table modifying based mostly on consumer position.

Knowledge Import Choices

Ninja Tables Professional provides you an excellent variety of options for getting knowledge into your tables.

You possibly can:

  • Add your personal CSV or JSON file
  • Hook up with the Fluent Type plugin
  • Query any publish sort
  • Hook up with Google Sheets or an external CSV file and routinely sync knowledge
  • Write a customized SQL question

Pricing and Particulars

Ninja Tables has a limited free model obtainable at WordPress.org.

After that, there are three full-featured plans, depending on how many websites you need to use it on:

  • 1 website – $39
  • 20 websites – $79
  • Limitless sites and lifelong license – $199

Extra Information / Download Demo

Posts Table Pro

Posts Table Professional is a bit totally different from the other desk plugins on this listing as a result of it doesn’t offer you an interface where you possibly can edit your desk’s knowledge. That is, it’s not like working in Excel.

As an alternative, it helps you’re taking any WordPress submit sort and display knowledge from that publish sort in a table, which opens up a variety of prospects.

When you particularly need to work with WooCommerce products, the identical developer additionally gives a dedicated WooCommerce Product Table plugin that helps you show products in a table format, identical to the Knowledge Tables Generator plugin above.

Key Features

  • Query any WordPress publish sort
  • Select which columns seem, including the power to question customized area knowledge
  • Use embrace/exclude rules to regulate exactly what content appears
  • Add search, type, and filter options
  • Add lazy loading to improve efficiency

How You Create Tables

I’ll combine these two sections for Posts Table Professional as a result of they’re really the same.

First, you’ll select what submit sort you need to query. Then, you’ll be able to select which columns you need to embrace. There are many built-in options, and you may also embrace custom fields and taxonomies:

After that, you possibly can configure other settings – like filters, lazy loading, and so on – and then embed your publish desk with a shortcode.

Pricing and Particulars

Posts Table Pro has three full-featured plans depending on how many sites you need to use it on:

  • 1 website – $65
  • 5 sites – $115
  • 20 sites – $215

More Information / Obtain Demo

Visualizer

In contrast to pretty much all the opposite plugins, Visualizer is a charts and graphs plugin that added desk functionality, relatively than a table plugin that added charts and graphs performance.

So in case your focus is on with the ability to flip desk knowledge into lovely charts and graphs, that may be a cause to choose Visualizer over the others.

It presents a restricted free model at WordPress.org, as well as a premium version with extra functionality.

Key Features

  • Create charts/diagrams based mostly on Google Visualization API and DataTables.internet
  • 9 chart varieties at no cost, with three more within the Pro model
  • Excel-like interface for modifying desk knowledge behind charts
  • Routinely synchronize chart knowledge with an external source, like Google Sheets
  • Let users create their own charts
  • Create charts by querying any publish sort at your website

Table Editor Interface

Once you create a new chart, you’ll first choose what sort of visualization you need to create:

Visualizer chart types

Then, you’ll be able to edit your chart knowledge using the in-dashboard editor. Or, you’ll be able to import from an exterior source:

Knowledge Import Options

The free version enables you to import knowledge by importing a CSV file or getting into an external URL (.e.g to Google Sheets). You can too hook up with a distant JSON/REST supply.

In case you go Professional, you’ll additionally be capable of:

  • Mechanically sync with an external supply (like Google Sheets)
  • Import straight from a database
  • Question a WordPress submit sort

Pricing and Particulars

Visualizer has a limited free model at WordPress.org. Then, to unlock extra chart varieties, import choices, and different features, you’ll be able to go Pro.

There are three totally different variations, depending on the features you want and what number of sites you propose to use it on:

Visualizer pricing

More Information / Download Demo

What’s the Best WordPress Table Plugin for You?

As with all plugin roundup, there’s really by no means a single “best” plugin that’s right for 100% of conditions.

As an alternative, this section is extra about discovering one of the best WordPress desk plugin on your particular needs.

To try this, let’s run by way of some situations…

For the most effective general desk plugin that ought to work for many situations, I’d advocate wpDataTables due to its user-friendly interface and deep function record. Whether you’re building tables, charts, or both, you’ll have plenty of options to create one thing that may work nice in your users. It also has probably the most import choices, especially if you want to work instantly with a MySQL database.

In case you’re in search of the most effective free WordPress desk plugin, TablePress is all the time going to be a superb place to start out. For those who want charts on prime of your tables, you may need to think about Visualizer as an alternative, or you’ll find some third-party charts extensions for TablePress.

In the event you don’t particularly want that Excel-like editor, Ninja Tables Pro still has a very nice interface and provides you plenty of choices. And for those who’re particularly trying to create a desk from present submit content at your website, think about Posts Table Professional for generic publish varieties, or Knowledge Tables Generator in the event you particularly need to query WooCommerce merchandise.

Any questions about these desk plugins? Ask away in the comments!

Colin Newcomer

Colin Newcomer is a contract author for hire with a background in search engine marketing and affiliate marketing online. He helps shoppers develop their net visibility by writing primarily about digital advertising and WordPress. You possibly can hire him to write down in your web site.

Disclosure: A number of the hyperlinks on this submit are affiliate hyperlinks, which means that should you click on one of the links and purchase an item, we might receive a fee. All opinions nevertheless are our own and we do not accept payments for constructive critiques.