wpDataTables - Tables and Charts Manager for WordPress

wpDataTables is a powerful responsive Tables, Spreadsheets and Charts Data Manager in a form of a WordPress Plugin.

If you want to join the testers team just open a support ticket here and we will add you to the list. You will always get the newest features first. Please note that you must be among existing users of wpDataTables.

User reviews

Plugin listed in WP catalogs

wpDataTables in social networks

For the people who want to request support: please make sure that you check the FAQ, documentation first. If your question isn’t there feel free to contact our support manager through the support system. We receive a lot of requests nowadays, so we ask you for understanding in case of delayed replies.

MANUAL UPGRADE PROCEDURE (when a new version is released)

Go to your FTP and open WordPress plugins folder.

Delete the old wpDataTables version folder.

Upload the new version of wpDataTables.

Go to WP-admin panel, open Plugins section.

Deactivate wpDataTables, and then activate it again.

DO NOT DELETE THE OLD VERSION FROM WP-ADMIN IF YOU DON’T WANT TO DELETE YOUR TABLES

Please note that minimum PHP version required is 5.4

Version 2.1 (released 20.11.2017)

A significant update with a couple of new features, stability improvements, and other.

Feature: New Multi-selectbox filter type;

Feature: checkbox filter when the filter is rendered above the table can appear in a popup, instead of rendering checkboxes directly on the page;

Feature: New settings for URL link columns – now it is possible e.g. to make them display as buttons, configure if the links should open in a new tab, or change the default text;

Feature: support for new addon added (Powerful Filters – to be released on CodeCanyon soon);

Fix: removed “All” when table displays all of the entries, and if you have less entries than selected displayed length;

Bugfix: Problems with checkbox filters resolved (weird display in modal, not remembering the selection in modal);

Bugfix: custom roles for editable tables support;

Stability and security improvements.

Compatibility with WordPress 4.9 approved.

Version 2.0.2 (released 24.08.2017)

A minor update mostly with stability improvements.

Feature: Checkbox for including Bootstrap on the front-end added on the Settings page – now if there is a JS conflict in Bootstrap files with your theme it can be resolved by disabling the checkbox.

Version 1.7.2 (released 08.03.2017)

HTML tags in Excel-like tables – this didn’t work properly in previous versions, now fixed;

Fix for custom CSS classes – some changes in 1.7.1 caused this feature not to work properly, now fixed;

Timepicker in Excel like tables fixed – an issue appeared in 1.7.1, now fixed;

Google spreadsheet links works from publish dialog as well as address bar;

Adding and removing columns fixed;

Editing IMG and link columns (no more HTML tags in editor);

Add wpDataChart callback for Chart.js;

Conditional formatting works with responsive option;

Fixes for the selectbox editor input type;

A number of other minor bugfixes;

Compatibility with WP 4.7.3 confirmed.

Version 1.7.1 (released 09.01.2017)

A minor update, introducing 2 new features and a number of minor fixes and improvements:

Chart.js - Now wpDataTables plugin has third chart rendering engine. Beside Google Charts and Highcharts we have added Chart.js that renders simple and flexible charts with a lot customization options.

Chart live preview - In wpDataTables Chart Wizard now there is no Preview step anymore. Chart changes are instantly visible and shown on the chart that is rendered in the right side of the screen.

Support for NULL/empty values - Now when editing editable wpDataTable it is possible to leave a blank cell for integer and float columns.

Fix for Row Grouping - Row Grouping feature was causing a JavaScript error in version 1.7.

Version 1.7 (released 23.09.2016)

A major update, starting some new sub-modules, massively improving existing functionalities:

Excel-like table editing – Now tables can be shown and edited not only with DataTables library, but also with Handsontable library, which has a nice Excel-like interface which supports bulk selection, drag’n’fill, duplicate, bulk delete, convenient inline editing, and many other features. Read more here.

Lots of improvements for charts – more formatting and styling options for both engines, group feature. Read more in the blogpost, check the video part showing the new features.

DateTime and Time column types – proper displaying of DateTime and Time (till minutes till now), as well as editing, sorting, filtering, etc. See the blogpost for more details.

Import Google Spreadsheets to WP database with Table Constructor – see the blogpost for more details, or see this video part showing the feature.

Version 1.6.2 (released 12.05.2016)

A regular update, adding some functionalities, stability improvements, and several features:

HTML editor for editable tables – now for columns which have string column type you can edit the data using a HTML WISYWYG editor (TinyMCE), both for editor dialog and for in-line editing.

Addons support – from now on plugin supports addons, each addon brings some unique feature which extends the core functionality. The first addon launched is the Report Builder, which is a tool for generating individualised Word DOCX and Excel XLSX documents in real-time from WordPress.

Responsive Charts – this was a highly requested feature: now each chart (both Google and Highchart) can be responsive – just tick the “responsive” checkbox near the width input. Responsive chart will occupy 100% width of the container, instead of having fixed width, therefore always render correctly on any device types, and when you resize browser window.

Auto-read possible values for column - if the table has server-side processing enabled you don’t need to type in possible values manually any more. See video demo.

Realtime auto-refresh for tables and charts – Tables which have server-side processing enabled can auto-reload in front-end with defined interval. See video demo.

No-flash Table Tools, and advanced configuration for Table Tools – the export functionality is now Flash-independent, works on HTML5, also you can define from the admin panel which buttons to show or hide per each table. See video demo.

Auto-generate thumbs for image columns in editable tables. When you upload a new image, a thumb with a link to full picture will be inserted automatically.

Skip thousands separator for integer columns. If your column is an integer, but you don’t want formatting (e.g. for years or product codes), you can disable it.

Fixed filter rendered in header. It was looking clumsy before when you chose to render the filter in header, now it is rendered in a separate row.

Non-UTF8 names for columns in Table Constructor. This was causing trouble before, but now it’s allowed.

DataTables front-end renderer library upgraded to 1.10.10

PHPExcel updated to latest version

Lots of stability and UX improvements and bugfixes

Version 1.6 (released 23.07.2015)

A major update. A lot of different changes and improvements. Basically the biggest change to wpDataTables since launch. Check this document for more info on new functions.

Version 1.5.6 (released 13.02.2015)

Just another patch on a long way to Table Constructor module. No new features, just bugfixes.

False update notification fixed – in the previous version there was a tiny bug that caused plugin to report that there’s a new version available all the time, also to throw a notice in the update list; this is fixed now.

Attachments title not displayed – refactoring in the previous version caused an attachments title (uploaded from front-end editor) not to be displayed; this is fixed now.

XML parsing errors – a bug which caused a problem with XML format parsing is fixed; also added a check if XML elements have attributes for correct parsing.

Table ID notice in shortcode fixed – in some cases when ID was empty it thrown a notice; it is fixed now.

New filter added for the table title (wpdatatables_filter_table_title) – you can use it to change the title dynamically, or hide it when you don’t need it

Custom JS was multiply escaped (‘\\\\’). Now it’s fixed.

EU date format sorting issue – when there was an empty cell in a date column with EU-formatted date (dd.mm.yyyy) it crushed sorting; now it’s fixed – empty cells will always be treated as the earliest date possible.

Preview with charts fixed. Now you can preview your charts in the backend along with the table, which didn’t work in earlier versions.

Even rows color picker didn’t work. Now it’s fixed and you can choose the color of the even rows.

Font color picker for table header didn’t work. fixed now.

Version 1.5.5 (released 08.12.2014)

Auto updates – we planned this for 1.6, but since there were already a couple of unplanned releases, we decided not to postpone it any more to make life easier for users. Starting from current version, if you enter your Envato Purchase Code, plugin will tell you when the new version is released, and do the auto update. To prevent piracy, maximum number of downloads of one version per purchase code is 2. But you can always download new versions directly from Envato and install in the good old-fashioned manual way.

File-based tables speedup – for large tables based on files you should have a significant improvement in speed now.

Version 1.5.4 (released 23.11.2014)

Security patch. A couple of minor bugfixes also included. New in this version:

Uploader security issue fixed.

Number range filter issue fixed. There was an issue in version 1.5.3 that broke number range filtering because of number formatting, for non server-side processing tables. Fixed now.

utf8_general_ci collation added to wpDataTables created tables. Chinese, Japanese, Vietnamese and other UTF-8 characters in column names shouldn’t be a problem any more.

Video tutorials

Overview

wpDataTables 1.6 is a mighty data manager in a form of a WordPress plugin. It helps you to create dynamic responsive tables, charts in your WordPress site edit and allow your front-end users to edit data in them. See the video features overview or the text features overview if you’re interested.

Features

A short list of wpDataTables features:

Cute interactive multi-functional front-end jQuery tables with filtering, sorting and pagination features rendered by DataTables library. You can manipulate all features easily from the WordPress administrator panel.

Server-side processing for MySQL-based tables.

Charts based on Google Chart and Highcharts libraries. Easily render charts from the same dataset as your table. Charts can be updated in realtime together with the table, as you filter the data set.

Front-end editing for MySQL-based tables.

Table constructor which allows to create the tables from back-end.

MySQL query generator. Builds all the “SELECT FROM, JOIN, WHERE, GROUP” for you – just click the correct buttons!

Row grouping based on RowGrouping extension. If a lot of rows have same values of some column you can group them based on the value of this column. The sorting will be performed inside of these groups.