wpDataTables Lite

plugin banner

This plugin allows you to create interactive sortable tables on your site based on a number of input sources – Excel, CSV, XML, JSON, PHP array.

Author:TMS-Plugins (profile at wordpress.org)
WordPress version required:4.0
WordPress version tested:5.8.3
Plugin version:2.1.24
Added to WordPress repository:30-11-2015
Last updated:10-01-2022
Rating, %:88
Rated by:221
Plugin URI:https://wpdatatables.com
Total downloads:476 576
Active installs:50 000+
plugin download
Click to start download

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
  • Font family and font size
  • Undo/Redo
  • Add star rating
  • Custom links
  • Add media
  • Custom HTML
  • Shortcode in cells
  • NEW Border options

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 (except simple table) 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 (Data 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. Customize options for each table are not included.
  12. 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.6 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:

  • NEW! Customize options for each table – Now you can customize each table with different skin, font, background , colors and lot more.
  • NEW! Create Tables via Google Spreadsheet API – Instant synchronization in wpDataTables after changes in Google sheets. Create tables from Private Google Spreadsheets.
  • 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.

Extend wpDataTables functionality with add-ons

wpDataTable Lite and Premium users have the option to extend wpDataTables functionality with FREE add-ons such as:
1. Forminator Forms Integration – that allows you to create wpDataTables from Forminator Forms submissions.

wpDataTable Premium users have the option to extend wpDataTables functionality with premium add-ons such as:
1. Master-detail tables** – which allows you and your site visitors to see details for each row with a simple click (view on popup or custom page/post)
1. Powerful Filters** – to filter table data in the WordPress Tables frontend with Cascade filters; it also allows you to hide the table before the filter is applied; show search button;
1. Report Builder** – Generate Word or Excel reports from tables in your WP in 1 click
1. Gravity Forms integration** – allows you to create editable wpDataTables from Gravity Forms entries data.
1. Formidable Forms Integration** – that allows you to create wpDataTables from Formidable Forms entries data.

**Those add-ons are not included in the premium plugin. They have to be purchased separately.

What do people say about wpDataTables?

★★★★★

Great plugin, great features, great support. Highly customizable and performing. – mirkolofio

★★★★★

This plugin is very useful and has save me countless hours. The support is top-notch as well. Literally one of the most impressive plugins that I use. – heatherlsi

★★★★★

This is the best plugin for displaying tables and charts! And the support is the best one I had on WordPress. Responses within hours and problem fix the same day ! – ldeschenes

★★★★★

I don’t do many reviews, but my experience with wpDataTables has been awesome; from using the plugin to interacting with customer service and their support team. I was pretty amazed that even through the holiday season the support team replied quickly to my request. – tekv

★★★★★

I am impressed. I thought this would be a basic plugin, but it is a very powerful and versatile plugin that offers many tools and settings. And if you need a hand using the plugin, their support is ready to help. Very professional. – mycamgirl


Screenshots
FAQ
ChangeLog