wpDataTables – Tables & Table Charts

Description

wpDataTables is a popular WordPress table plugin used to quickly create tables & table charts from Excel, CSV, PHP and other data sources. Use our WP table plugin to represent vast amounts of complicated data in concise, user-friendly way using tables or charts.

NEW! New table builder is introduced in wpDataTables – creating simple tables from scratch. These tables can be anything but simple, though, as you can now merge cells, style each cell differently, add star ratings to cells, and so much more.

Here is the list of the new functionality in those simple tables:

  • Merge cells
  • Excel like editor
  • Responsive mode
  • Add/Remove columns and rows
  • Resize/Reorder columns and rows
  • Cell custom formatting
  • Undo/Redo
  • Add star rating
  • Custom links
  • Add media
  • Custom HTML
  • Shortcode in cells

wpDataTables allows creating 14 different chart types using the Google Charts rendering engine:

Creating tables and charts with a WordPress tables plugin has never been easier. It only takes 3 basic steps:

Step 1 – Provide table data

You can provide table data for WordPress tables by uploading Excel, CSV , JSON, XML or Serialized PHP array or you will create simple table from scratch with new table builder.

Step 2 – Customization

You can customize and configure the columns of your WordPress table (rename, reorder, add CSS classes, hide, change colors) and also you can customize and configure table Color and Font settings( Font, Header, Table border, Row , Cell and Pagination) in any way you see fit.

Step 3 – Publish in a post or page

Once you are happy with the design of your WordPress table, you can easily insert it on any post or page through Gutenberg, standard WP Editor and shortcode, or through page builders like WPBakery Page Builder, Visual Composer or Elementor. All tables will become sortable and will have pagination by default.

Additionally, each table (except simple table) can have a search bar and can have the following functions: “Copy to Clipboard”, “Export to CSV”, “Export to PDF”, “Export to XLS”. All these functionalities are configurable and it is your decision whether to toggle these on or off.

Following column data types are supported in data tables(tables created from Excel, CSV , JSON, XML or Serialized PHP array). Most column types, except the images, have their own sorting rules:

Please note some limitations compared to the Premium version of the wpDataTables plugin:

  1. MySQL-query based tables support is not included.
  2. Creating tables from the Google Spreadsheet files is not included.
  3. Create a table manually is not included.
  4. Server-side processing is not included.
  5. Responsive mode for the tables is not included.
  6. Table filters are not included.
  7. Front-end table editing is not included.
  8. Excel-like editing is not included.
  9. Advanced HighCharts and Chart.js are not included
  10. Table Constructor Wizard (step-by-step table generator) is not included.
  11. Access to our premium support system is not included.

You can get all of these features by purchasing the Premium version on the plugin’s site.

Please note that wpDataTables requires PHP 5.4 or newer!

wpDataTables vs wpDataTables Premium

If you still can’t decide which wpDataTables version to choose, you should get familiar with the basic features of both of them, and then take it from there. It all boils down to the type of tables in WordPress that you want to create.

wpDataTables

If you don’t require the most advanced features because you only create a table in WordPress every now and then, wpDataTables is perfect for you.

wpDataTables Premium

While the basic version is great for people who create small and simple tables, wpDataTables Premium is the best WordPress table plugin and it comes with a huge set of amazing features.
However, the thing that really sets it apart is the possibility to manage any amount of data and create huge responsive tables in WordPress.

Do I Need wpDataTables?

Well, the short answer is – yes. If you want to create fully functional and great looking WordPress tables, you need wpDataTables. The number of the users currently taking advantage of this plugin is 30,000 and counting.
The major features of wpDataTables include but are not limited to:

  • Building WordPress tables quickly and easily – no complicated configuration; just simple clicking;
  • No coding knowledge required;
  • Fully customizable WordPress tables and charts – from choosing the color palette to inserting elements such as your company logo, wpDataTables allows you to customize your tables and charts in any way you see fit;
  • A WordPress table plugin that works like a spreadsheet app – with all the advanced features and tools, wpDataTables truly stands out from the competition;
  • 1 year of updates and support

Additional useful features include:

  • Multiple databases support – wpDataTables is the only WordPress table plugin that can display the data from MySQL, MS SQL or PostgreSQL databases.
  • Responsive Tables – your WordPress tables will be 100% functional and they will look great on all screen and devices
  • Huge Amount of Data – wpDataTables Premium can create huge tables in a matter of minutes. All the operations will be handled by the MySQL server.
  • Editable Tables – you or any other WordPress user with access will be able to edit and/or adjust the published tables at any point
  • Advanced Filters and Search– you will be able to create individual filters that will help you narrow the search results in the table quickly and easily. You can also configure a cascade filter with the Powerful Filters addon.
  • Highlighting – highlighting the rows, columns, cells of your WordPress tables etc. has never been easier with this plugin’s conditional formatting feature
  • Charts – you can easily turn every WordPress table into a beautiful chart. Charts are rendered by 3 powerful engines (Google, Highcharts and Chart.js) and can change in real-time.
  • Calculating Tools – calculating a sum, average, minimum and maximum of all the values for a given column is easier than ever with the wpDataTables advanced calculating tools
  • Placeholders – make dynamic SQL Queries and use it through the shortcodes and as predefined values in filters and editing.

Screenshots

  • New simple editor
  • Merge cells and customization
  • Reorder/resizing columns and rows
  • Front-end data table preview.
  • Back-end data table editor preview.
  • Data Table preview from the back-end
  • Table browser example
  • General settings
  • Column settings
  • Plugin settings
  • Google charts
  • Google chart settings

Blocks

This plugin provides 2 blocks.

  • wpDataTables - Tables & Table Charts
  • wpDataTables - Tables & Table Charts

Installation

Installation of the plugin is really simple.

  1. Install using one of these options:
    • Install directly from WordPress Admin panel: go to Plugins -> Add New -> Search for “wpDataTables”, and click the Install button.
    • Download the ZIP manually from WordPress’ plugins repository, and upload it through WordPress Admin panel: go to Plugins -> Add New -> Upload Plugin, browse to the downloaded Zip and upload it.
    • Download the ZIP, extract it and manually upload the extracted folder through FTP to the /wp-content/plugins/ directory of your WordPress installation.
  2. Activate the plugin through the ‘Plugins’ menu in WordPress.
  3. That’s it!

FAQ

I added a table but see no sorting, filtering or pagination

Usually this happens when PHP version is older than 5.4 is installed. Please first check this, and upgrade to PHP 5.4 or more, if that’s the issue.

How to hide “Showing X of X entries” in pagination?

Go to display tab of the table settings block and disable the “Info block” setting.

How to disable/enable opening links in a popup?

You can configure how the links will be opened by toggling the “URL target attribute” switch
In the Data tab of the Column Settings popup. It is up to you to define for each URL column if you prefer the link to open in a new or in the same tab.

How to hide “Show X entries” block from pagination?

Go to display tab of the table settings block and disable the “Rows per page” setting.

How to add symbols or text before/after cell values without affecting sorting (currency, percents, etc.)

For every table column in the column settings modal you can find text fields “Cell content prefix” and “Cell content suffix” in Display tab.
Values from those text fields will be appear before or/and after every cell content in a column.
This feature uses CSS for displaying the entered text, therefore sorting of the columns will not be affected.

How to change the format of dates?

Date format can be changed in wpDataTables Settings page using the “Date format” drop-down menu.

How to change thousand and decimal separators for number columns?

This can be changed from the “Number format” drop-down menu in the wpDataTables Settings page.

Reviews

Novambor 27, 2020
The plugin wasen't the right for my specifics needs but Aleksandar from the support helped me a lot to try the differents options. Had no trouble to get a refund.
Novambor 13, 2020
Support sucks! I bought a developer subscription for unlimited domains (which speaks to the plug-in) but I can add anymore and their login won't take my active credentials in order to login for help. I'm VERY frustrated!
Novambor 11, 2020
We spent a lot of time doing research before purchasing this plugin. Look no further! This is the best value money can buy. Initially I was a bit skeptical due to cost but I decided to bite the bullet and no regrets. It does exactly everything we need from it, and more. Our requirements were extremely complex and this plugin managed to address it thanks to Alex's step by step guidance. The support is great and timely as well.
Novambor 10, 2020
We have been using the pro version of wpDataTables plugin to display our prices for products and services, and it has been working great. The support has been prompt, and we look forward to making our table display easier and efficient. I highly recommend the upgrade to the pro version to get the maximum of out of the plugin. we choose wpDataTables over Ninja Tables Pro because of its many features, and also being part of Envato too and Appsumo. thank you.
Novambor 9, 2020
Updates must be downloaded and uploaded manually, goes against best practices for security and keeping your plugins up to date. New updates routinely break and then you are forced to roll back and wait for another update.
Read all 137 reviews

Contributors & Developers

“wpDataTables – Tables & Table Charts” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

2.1.4

A major update with a couple of new features, bug fixes and stability improvements:
* Feature: Elementor integration – Added Elementor Blocks for tables and charts.
* Feature: New option to hide pagination for each table.
* Feature: New option to set pagination position for each table.(Right, center and left)
* Feature: New option to set pagination layout for each table.(Six different layouts)
* Feature: New option to set tables sorting order on browse pages.
* BugFix: Fixed issue for reset options Remove borders.
* BugFix: Fixed issue with showing tables in Internet Explorer browser.
* BugFix: Remove wpdt-c class from admin area on other admin pages
* BugFix: Correct folder name for Slovenian language.
* BugFix: Fixed issue with removing message modals in admin area
* BugFix: Fixed issue for simple tables with random sorting.
* Other small bug fixes and stability improvements.

2.1.3

  • Feature: New table type – Create a simple table with any data, merged cells, styling, star rating and a lot more.
  • Feature: Added Slovenian translation
  • Improvement: Update French translation
  • Improvement: Added new color picker
  • Other small bug fixes and stability improvements.

2.1.2

  • Fixed issue with the slow backend
  • Fixed issue with loader after saving global plugin settings
  • Bug fixes and stability improvements.

2.1.1

  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.5 approved.

2.1

  • Design: New fresh admin UI.
  • New page: New Dashboard page with lots of useful information and guides.
  • New page: New detailed System Info page which simplifies resolving external conflicts.
  • Feature: New Popup First-launch Guide with feature explanations for new users.
  • Feature: New options like Feature suggestion, Subscription and lot more.
  • Feature: Now it is possible to create all Google charts.
  • Feature: Chart Tooltips are enabled.
  • Feature: Global Table Customization are available (Color And Font Settings)
  • Notice: For next update of wpDataTables Lite it will be required 5.6 version of PHP, so the users who have still 5.4 have time to upgrade.
  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.4.2 approved.

2.0.21

  • Bug fix: Issue with Gutenberg hooks
  • Compatibility with WordPress 5.4.1 approved.

2.0.19

  • Bug fix: Issue with padding in container for Aqua skin in backend
  • Bug fix: Issue with padding for ellipsis button in pagination
  • Compatibility with WordPress 5.4 approved.

2.0.18

  • Added option for title on Print button
  • Bug fix: Issue for enabling Apply button on input/paste URL input
  • Bug fixes and stability improvements.

2.0.17

  • Updated Russian translation
  • Bug fixes and stability improvements.

2.0.16

  • A minor update with a couple of small bugfixes:
  • Bugfix: Fixed conflict with WooCommerce product page and Gutenberg
  • Resolved minor security issue – added nonce on Settings page
  • Compatibility with WordPress 5.3.2 approved.

2.0.15

  • A minor update with a couple of small bugfixes:
  • BugFix: Plugin is now compatible with jQuery 3.x.
  • BugFix: Fix PHP notices
  • Compatibility with WordPress 5.3 approved.

2.0.14

  • Feature: Added new date formats
  • Updated French translation
  • Updated core of Datatables library
  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.2.3 approved.

2.0.13

  • Feature: Removed limitation for number of rows in tables
  • Feature: Added functionality for creating Google charts(Line, Column and Pie)
  • Feature: Added options for customizing Google charts(Line, Column and Pie)
  • Bug fixes and stability improvements.

2.0.12

  • Bug fixes and stability improvements.

2.0.11

  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.2.2 approved.

2.0.10

  • Bug fixes and stability improvements.

2.0.9

  • Feature: Added Gutenberg block – the plugin is now Gutenberg optimized.
  • Feature: Added option to choose whether you want to keep the tables after deleting the plugin from the Plugins page (by default the tables will be saved in database after deleting the plugin).
  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.2.1 approved.

2.0.8

  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.1.1 approved.

2.0.7

  • New skins and new UI elements – a new Dark and Purple-style skins for tables front-end, new UI elements;
  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.1 approved.

2.0.6

  • New skin and new UI elements – a new Aqua-style skin for tables front-end, new UI elements;
  • Bug fixes and stability improvements.
  • Compatibility with WordPress 5.0 approved.

2.0.5

  • Added more Date formats
  • Bug fixes and stability improvements.

2.0.4

  • Added French language for translation
  • Bug fixes and stability improvements.
  • Compatibility with WordPress 4.9.8 approved.

2.0.3

  • An option to choose CSV delimiter in the Settings page.
  • Bug fixes and stability improvements.
  • Compatibility with WordPress 4.9.7 approved.

2.0.2

  • The plugin’s design was re-worked from scratch to a more intuitive, smooth and user friendly interface following Material Design guidelines;
  • New skin and new UI elements – a new Material-style skin for tables front-end, new UI elements;
  • Feature: Checkbox for including Bootstrap on the front-end added on the Settings 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;
  • Fix: removed “All” when table displays all of the entries, and if you have less entries than selected displayed length;
  • Under-the-hood improvements
  • Security and stability improvements;
  • A number of other minor bugfixes;
  • Compatibility with WordPress 4.9.1 approved.

1.2.3

  • Security issues fixed for deleting and loading wpDataTable.

1.2.2

  • Security issues fixed for all save actions.

1.2.1

  • Compatibility with WP 4.7 approved
  • Problem with PHPExcel components resolved

1.2

  • DateTime column type added
  • Time column type added
  • Extended multisite support
  • Improved Settings page
  • Compatibility with WP 4.6.1 approved
  • Numerous bugfixes

1.1

  • Migrated Table Tools to use HTML5 instead of Adobe Flash
  • Advanced settings for configuring Table Tools (individually per button)
  • Wide tables can be configured to be horizontally scrollable
  • Upgraded used libraries
  • Compatibility with WP 4.5.2 approved
  • Numerous bugfixes

1.0

  • Initial version for wp.org