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.
Plugin general information and related linksInstallation, configuration, backend and frontend overview
These sections cover how to install wpDataTables, settings on the configuration page, overview of the front-end and back-end parts of the plugin to help you get started
- Installing wpDataTables plugin
- Configuring wpDataTables
- Upgrading wpDataTables manually
- Front-end overview
- Back-end overview
- Plugin support
- Contact us (for non-support inquiries)
- Our Newsletter subscription (news about the plugin version, promotions, discounts, giveaways)
- Free Lite version download
- What’s New / Versions Changelog
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 based on Excel files
- Creating tables based on CSV files
- Creating tables based on Google Spreadsheets
- Creating tables based on MySQL queries
- “Lazy load” (Server-side processing) for very large MySQL tables
- Creating tables based on serialized PHP arrays
- Creating tables based on JSON feeds
- Creating tables based on XML feeds
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.
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.
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:
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: