wpDataTables is a WordPress table plugin that lets you create data tables and charts from multiple data sources including Excel, CSV, XML, JSON, MySQL, and PHP arrays. Unlike simple table plugins, wpDataTables handles large datasets with advanced features like sorting, filtering, pagination, and search. The plugin supports 23 chart types powered by Google Charts and Chart.js. The Premium version adds MySQL query builder, WooCommerce product tables, and conditional formatting. wpDataTables is a more powerful alternative to TablePress Premium for users who need advanced data handling and MySQL integration. It pairs well with WP Rocket for caching and performance optimization.
Competitive Features
- Multiple data sources — import from Excel, CSV, XML, JSON, MySQL, PHP arrays, and serialized PHP
- Advanced filtering — column-based filtering with dropdowns, checkboxes, date range pickers, and text search
- Table charts — create 23 chart types from table data using Google Charts and Chart.js
- MySQL query builder — connect to external MySQL databases and build custom queries (Premium)
- WooCommerce product tables — display products in sortable and filterable table layouts (Premium)
- Conditional formatting — apply custom styles to cells based on values and conditions (Premium)
- Formula support — use SUM, AVERAGE, COUNT, and custom formulas in table cells (Premium)
- Caching — cache table data for faster loading with auto-update intervals
Key Features
- Responsive design — tables automatically adjust to screen size with horizontal scroll and collapsed modes
- Excel-like editor — edit table data directly with merge cells, star ratings, and custom formatting
- Column types — text, number, date, time, email, URL, image, file, and custom HTML columns
- Foreign key support — link columns to other tables and display related data
- User roles — control who can view and edit tables
- Inline editing — allow users to edit table data from the front-end
- Export to PDF and Excel — export tables to PDF, Excel, CSV, and print formats
- Shortcode support — embed tables anywhere using
[wpdatatable id=1]or[wpdatachart id=1]
Comparison with Competitors
wpDataTables Premium vs TablePress Premium
| Feature | wpDataTables Premium | TablePress Premium |
|---|---|---|
| Data sources | 8+ (Excel, CSV, JSON, MySQL, etc.) | Excel, CSV, HTML, JSON |
| MySQL query builder | Yes | No |
| Charts | 23 chart types | No |
| Conditional formatting | Yes | No |
| Formulas | Yes | Yes |
| WooCommerce tables | Yes | No |
| Learning curve | Moderate | Minimal |
wpDataTables Premium vs Visualizer
| Feature | wpDataTables Premium | Visualizer |
|---|---|---|
| Table creation | Yes | Yes |
| Chart creation | Yes | Yes |
| Data sources | 8+ | CSV, Excel |
| MySQL integration | Yes | No |
| Frontend editing | Yes | No |
| Conditional formatting | Yes | No |
| WooCommerce integration | Yes | No |
Recommended Stack — pair wpDataTables Premium with image optimization plugins like Imagify to ensure your data tables and charts load quickly alongside optimized images.
Official Changelog
Version 6.5.1.6
Release Date: August 28, 2026
- Fixed: MCP Compatibility issue throwing an error message.
- Other small bug fixes and stability improvements.
Version 6.5.1.5
Release Date: August 10, 2026
- Security: Fixed reflected XSS vulnerability in Browse Tables pagination.
- Security: Hardened search-parameter handling.
- Other bug fixes and stability improvements.
Version 6.5.1.4
Release Date: July 25, 2026
- Minor CSS improvements.
- Other bug fixes and stability improvements.
Frequently Asked Questions
What data sources does wpDataTables support?
The plugin supports Excel, CSV, XML, JSON, Nested JSON, MySQL, PHP arrays, and serialized PHP data sources.
Can I create charts from table data?
Yes, wpDataTables includes 23 chart types powered by Google Charts and Chart.js, including line, column, pie, bar, and area charts.
Does wpDataTables support MySQL queries?
Yes, the Premium version includes a MySQL query builder that connects to external databases and creates tables from custom queries.
Can I use wpDataTables with WooCommerce?
Yes, the Premium version includes WooCommerce product tables that display products in sortable and filterable table layouts.
Is wpDataTables responsive?
Yes, tables are fully responsive and automatically adjust to different screen sizes with configurable responsive modes.
Leave a Reply