WPDataTables- Best Table and Chart maker Plugin for WordPress

By on October 11th, 2021

WPDataTables is a popular table plugin used to create tables and table charts from Excel, CSV, JSON, XML, and any other data source. You can easily add tables and charts to your posts and pages in a matter of minutes. More than 50,000 companies and individuals already trust the plugin to work with statistical, financial, commercial, scientific, and other data.

The plugin takes care of responsiveness; it doesn’t matter which data source, you can use- Excel, MySQL, or any other. In other words, your website can be responsive on any device you want. You can also structurize the column of the table by using the dropdown.

The plugin offers server-side processing for MySQL-based tables. It will assign all the operations like filtering, sorting, pagination, and other data processing routine to the MySQL engine, and that’s why the plugin will work with millions of rows without any server load.

Its advanced filter and search let you create individual filters for your dataset, which helps you narrow down the filter of your WordPress table. If you handle a large amount of data, it is difficult to find and estimate the number of cells and values you are looking for. With the conditional formatting(highlight) feature, it is easy to find any data within a matter of minutes. You can also create a chart for a particular data source of the table.

Let’s take a look at some of the cool features provided by the plugin:

Features

  • Advanced filtering
  • Conditional formatting
  • Multiple DB engine connections support
  • Row grouping
  • Multiple integrations(Elementor, Gutenberg, Visual composer, etc.)
  • Making dynamic SQL queries with placeholders
  • Pre-filtering tables through URL
  • Table export tools
  • Add-ons to increase functionality(Formidable forms, Gravity forms, etc.)
  • Multiple chart types
  • Multiple databases support
  • Advanced calculating tools

Let’s look at practically how to configure the plugin by installing the plugin on WordPress.

Plugin Configuration

Install And Activate The Plugin

In your WordPress admin area, go to “Plugins >> Add New” and search wpDataTables on the search box. The plugin should look like the following image.

You can also download the zip file of the plugin and upload it by navigating “Plugins >> Add New >> Upload”. Once this process is complete, install and activate the plugin.

Settings

The Settings tab includes four tabs: Main settings, DB connection, Color and Font settings, and Custom JS and CSS. We will discuss each tab and its settings step by step.

Main settings

The “main settings” tab includes base skin, data format, time format, and other primary settings.

  • Interface language: You can choose the language among 45 different languages for the primary interface features.
  • Date format: This option allows you to choose 17 standard date formats for the date columns.
  • Time format: Here, you can choose between a 12H time format and a 24H time format. We will use it in the time column and for all time pickers.
  • Base skin: The plugin offers different built-in skins that you can use to set the general look. You can use Aqua, Graphite, Material, Purple, Dark, and light skin for your table front-end.
  • Render advanced filter: This tab allows you to enable advanced filter position in a table header or footer.
  • CSV delimiter: This tab allows you to choose the delimiter that matches the one in your CSV file. Delimiters are comma, semicolon, slash, etc.
  • Tables per admin page: This tab allows you to determine how many tables and charts will be visible on the “Browse wpDataTables” admin page.

There are many other options to set, which you can use in the pro version of the plugin.

Separate DB connection

You can enable these settings if you want to add more than one separate database(MySQL, MS SQL, etc.) connection. Keep in note that this feature is available only in the premium version of the plugin.

If you enable this feature, you will also need to provide the data(connection name, host, port, driver, etc.) to query the database.

Colour and font settings

This tab allows you to change the look of the tables. The following image shows you what you can change in this tab.

Custom JSS and CSS

This tab allows you to configure JavaScript and StyleSheet for the plugin.

  • Custom wpDataTables JS: Here, You can define custom JS as an inline script block on pages with wpDataTables.
  • Custom wpDataTables CSS: Here, you can define custom CSS rules you applied to the pages with wpDataTables.
  • Use minified wpDataTables JavaScript: The minified files are attached to the pages by default for better performance, but you can uncheck it if you would like to make some changes to the main wpDataTables JS file.

Pricing

The plugin comes with three pricing plans: Basic, Pro, and Developer plan. The Basic plan costs you $61/year in which you can use the plugin in one WordPress site. Pro plan costs you $111/year with premium support, and you can use the plugin on three WordPress sites. The developer plan costs you $253/year and uses the plugin in unlimited domains.

The plugin also offers lifetime subscription plans: Basic Lifetime, Pro Lifetime, and Developer Lifetime, which costs you $193, $397, and $601, respectively. If you are unhappy with any of the above premium plans, you can get your money back within 15 running days.

Conclusion

wpDatatables is the best plugin for displaying data tables and charts with its great features. You can extend the functionality with its free and premium add-ons. The customization allowed us to create an intuitive interface for clients for input and editing data.

If you use the pro version of the plugin, you will get lots of powerful features such as feeding data into tables using front-end form, building a table from your custom database queries, and more.

You can make your tables responsive without harming your website’s design. It helps you best user experience for your readers.

That’s it. We hope this article helped you configure the settings of the plugin.

Leave a Reply