Please wait...

wpDataTables documentation

wpDataTables Features OverviewQuickhand navigation through wpDataTables documentation

wpDataTables is a WordPress Tables and Charts manager, which is designed to make the process of data representation and interaction quick, easy and effective. It allows you to quickly build and put on any of your WordPress posts, or pages interactive tables and charts with such features as multi-criteria filtering, sorting, or export to PDF from almost any possible data source – MySQL query, Google Spreadsheet, PHP array, Excel file, CSV file, JSON and XML input sources; also you can generate MySQL queries to WordPress database, or any MySQL database without any knowledge of SQL at all! And if you like you can create the tables and charts without any predefined source files from WordPress back-end.

This site is running WordPress 4.7.3 – so you can be sure that the plugin works with current version 🙂

Probably you had a situation when you needed to publish a table on your WordPress-based site, which would need to have slightly more features then a simple HTML table: pagination, filters, conditional formatting, charts: for example a catalog, statistics data, financial report, a price list, a list of business locations, a list of users, and so on. And you probably discovered that it would require at least some coding, and keeping it regularly updated means that you would need to do all the coding work again and again. wpDataTables is a plugin which would handle all the work, and you would just need to set it up once – no coding required.

See a shortlist and navigation through documentation pages and examples in the widget below.

Please note that as wpDataTables has direct access to the database (WordPress database, or a remote MySQL DB) the plugin admin pages are restricted to admin users only, and not visible to editors or users with other roles. To allow them to see it you would need to grant them ‘manage_options’ capability.

Please be advised that merged cells aren’t currently supported by wpDataTables.

Plugin general information and related linksInstallation, configuration, backend and frontend overview

Showing table data from data sourceCreating wpDataTables from existing data sources (``Add from Data Source`` page)

Tables can be created from existing files or other sources (Excel files, CSV files, Google Spreadsheets, and other) using the “Add from Data Source“. Tables created this way will be read from the data source on every page load, making it easy to update the table – when you change the underlying data source the table will be auto-updated – but slowing the page down if the table is large (Except for the MySQL-based tables with server-side processing).

Creating tables in WordPress admin using Table ConstructorCreating wpDataTables manually or importing table data to MySQL database using the Table Constructor

Tables can be created from WordPress admin, without pre-defining any data source, by describing the table structure and filling in the values in cells manually through an editor. To do this you can use wpDataTables’ Table Constructor. This module also allows importing CSV, Excel or Google Spreadsheets data to editable wpDataTables. Table data for tables created this way will be be stored in the database and will always be editable, and use benefits of server-side processing.

Table data editingEditing tables from WordPress back-end and front-end

Tables created with wpDataTables can be configured to be editable from WordPress back-end or front-end, if they are MySQL based, or created with Table Constructor. There are several ways of editing tables: editing tables through a popup form, inline-editing, or Excel-like / Spreadsheet editing. In these documentation sections you can find all the details on how to use the editing functionality:

ChartsCreating dynamic charts in WordPress with HighCharts, Chart.js or Google Charts rendering engines

wpDataTables allows creating dynamic charts in WordPress, at the moment it supports 3 rendering engines: Google Charts, Highcharts (allows separate license for commercial usage), and Chart.js. All charts base on wpDataTables as on data sources, and  can be linked to the table filtering, sorting to dynamically redraw in the front-end, which is useful for representation of numeric data.

Advanced featuresAdvanced features of displaying table data

wpDataTables isn’t just a plain table editor – each table can be packed with lots of advanced features – such as responsive design, conditional formatting (highlighting), sorting, calculating totals, and other:

Column types and featuresConfiguring columns in wpDataTables

Each column can have its own type which defines difference between the sorting, or filtering rules. For example, sorting dates and sorting texts has completely different logic. wpDataTables has a built-in autodetect engine, so the column types are detected when the data source is first read, in most of the cases it is done correctly, but you can re-define the column type manually. Different column types and features:

Information for developersCustomizing wpDataTables front-end and back-end

wpDataTables has a lot of features for WordPress tables out of the box – but if you do know PHP and Javascript you can customize both front-end and back-end of the plugin.

Never miss new features!

Join 2000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

We never spam or disclose your address to anyone.