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:6.5.5
Plugin version:3.4.2.19
Added to WordPress repository:30-11-2015
Last updated:08-07-2024
Rating, %:90
Rated by:401
Plugin URI:https://wpdatatables.com
Total downloads:1 520 744
Active installs:70 000+
plugin download
Click to start download

wpDataTables is a popular WordPress table plugin used to quickly create data tables & table charts from Excel, CSV, XML, JSON, 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.

The main benefits wpDataTables provides to its users are saved time (as it automates displaying data in website and allows to do so without investing time in coding) and no need to learn coding (creating a WordPress table like in wpDataTable would require development without it).

Amazing WordPress Table Builder

New table builder is introduced in wpDataTables – Creating simple WordPress 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, media 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 editor
  • Shortcode in cells
  • Border options

Create responsive data table very easy

Responsiveness is a feature that allows presenting the same content differently depending on the display size of device that is used to view it. More about process of creating a responsive table in our docs Responsive table in WordPress.
Your tables will be 100% functional, and they will look great on all screen and devices.

Create datatable from Excel

Microsoft Excel is a very powerful tool and one of the most efficient software for graphic-analytical and tabular data processing. With wpDataTables, it’s even more powerful in WordPress environment. .XLS and .XLSX formats are also so common for storing data simpler, faster and more intuitive. Checkout more details in our documentation about How to create WordPress tables from Excel files where you can find and video tutorials as well.

Make data table from CSV

The CSV, or “comma-separated-values” is a widely used format; It is lightweight, simple, can be generated by almost any software, and created manually by users. Beside ‘comma’, wpDataTables support ‘colon’, ‘semicolon’, ‘vertical bar (pipe) and ‘TAB’ as CSV delimiter. You can find detail instructions on the link How to create WordPress tables from CSV files.

Generate data table from XML

XML – (Extensible Markup Language) is a universal standard for presenting data. A lot of web services “run” on XML, and wpDataTables supports XML as an input data source as well. Find in our docs How to create WordPress tables with XML.

Build WordPress table from JSON

JSON has become the ‘de facto’ standard for packing data on the web and wpDataTables also supports the JSON format as an input data source.
Learn How to create WordPress tables from JSON in our documentation.

NEW! Create data table from Nested JSON

As you know, with wpDataTables you are able to create a table linked to an existing JSON file that need to contain a one-level array of same-structured objects, but not any more. Now you are able to choose root path where is your data with or without JSON Authentication. More info in our docs about Creating data tables in WordPress from nested JSON

NEW! JSON Authentication

Most of JSON APIs are locked, password protected, and can’t be accessed without some authentication. wpDataTables support basic authentication and also custom headers where you can provide details needed for authentication for that specific JSON (for example API keys, tokens, etc.). More info in our docs about JSON Authentication.

NEW! Cache tables data

We are introducing a new feature that will dramatically increase the loading performance of your tables created from existing data sources like CSV, Excel, XML, JSON, Nested JSON and PHP array. More details in our docs about Caching tables in WordPress.

NEW! Auto update table cache from source file

This new option is related with previous option caching tables. If you are updating your source file frequently, and want to keep the data in the table updated after a custom interval, the new feature Auto update cache from the source file will be perfect for you. You can read more in our docs about Auto update cache from source and cron job instructions.

Develop dynamic WordPress table from Serialized PHP array

For developer users, or users who are at least somewhat familiar with PHP language. Learn how you can prepare a PHP file and How to create WordPress tables based on serialized PHP arrays in our docs.

Create Responsive Charts

Responsive Charts in wpDataTables can be created with a step-by-step chart creation wizard in WordPress admin. More about chart wizard and chart customization options in our docs about How to create responsive charts in WordPress.

Editing charts

Editing charts with wpDataTables plugin is very easy – everything is done with the same wizard used to create them – the only difference is, the data is already prefilled. More on link Editing charts in WordPress.

NEW! Grouping data in Charts

Charts in wpDataTables have a very useful feature: grouping – the values of the rows with the same label will be summed up and rendered as a single series. More in our docs about Grouping data in WordPress Charts.

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

NEW! And now 9 more awesome chart types with Chart.js engine, that renders simple and flexible WordPress charts with a lot of customization options:

Creating tables, datatables 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, Nested JSON, XML or Serialized PHP array, or you will create simple table from scratch with new WordPress table builder.

Step 2 – Customization

You can customize and configure the columns of your WordPress table (rename, reorder, add CSS classes, add prefix or suffix, set visibility, hide on mobile or tablet, change colors, set text alignment for cells and header, sort) 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

All tables (except simple table) will become sortable and will have pagination, global search, display length and export table buttons by default. 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:

Export table data and column visibility (Table tools)

Additionally, each table (except simple table) can have a search bar, display length, table info, pagination and can have the following export functions: “Copy to Clipboard”, “Export to CSV”, “Export to PDF”, “Export to XLS”, “Print“. More info in our docs about Table tools in wpDataTables and Table and column settings (simple table has own customization panel).

Full front-end WCAG compatibility

wpDataTables includes full compatibility with Web Content Accessibility Guidelines (WCAG), ensuring that it is accessible to all users, including those with disabilities.

Global, individual and multiple columns sorting

wpDataTables can act as a sortable table plugin by supporting sorting for all the data types. Tables rendered by the wpDataTables plugin are sortable by default (except simple tables). It means that the content of the datatables can be ordered by the values of one of its columns. Detail explanation you can find in our documentation about Creating a sortable table in WordPress.

Row grouping

If one column of your table contains similar values for many rows, it often makes sense to use it as a “group column”.This means it will not be displayed as a column, but its values will be used to group the rows.
For detail explanation check out How to set up row grouping in WordPress tables.

Single cell shortcode

Most of the users need to show a single value from their tables. wpDataTables presents dynamic single-cell shortcodes that you can use in many options. There are differences in shortcode parameters depending on the table type. More about Single cell shortcode you can read in our docs.

Showcases how it is commonly applied

  • Pricing tables
  • Amazon product comparison table
  • Searchable catalogs of car parts, books, etc.
  • Currency and crypto rates
  • Financial and investment rates
  • Customer lists
  • Statistics data (weather for example)
  • Scientific data
  • Monitoring of data
  • Tourist agency – rating hotels and trips
  • Game popularity comparison
  • Gamers statistics
  • Monthly employee statistics
  • Product lists
  • Product lists with links to online stores
  • Pedigree tables
  • Historical data
  • Country population statistics
  • Datatables
  • and all other cases or industries where data need to be shown as tabular or chart format.

Premium features include:

  • NEW! Folders/Categories – Organize Tables and Charts in WordPress Using Folders.
  • NEW! Transform Value – Allows you to transfer some of the values in your columns into links, mailing triggers, phone triggers, and images.
  • NEW! Fixed/Sticky headers – Now you can freeze headers after scroll very easy for each datatable.
  • NEW! Fixed/Sticky Columns – Now you can freeze left and right columns very easy for each datatable.
  • 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.
  • Manual tables – how to create a wpDataTable based on a query to a MySQL table.
  • Update manual tables from source files – dramatically improve the updating process of manual tables from existing data sources like CSV, Excel, and Google sheets.
  • Editable Tables – you or any other WordPress user with access will be able to edit and/or adjust the published tables at any point
  • Excel-like editing – Excel-like spreadsheet editing interface is available both for back-end and front-end editing
  • 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
  • Highcharts – excellent charts library which allows exceptional rendering and animated charts
  • HighCharts Stock – advanced financial charting library that empowers users to generate sophisticated and interactive visualizations for financial data on websites
  • ApexCharts – create beautiful and interactive visualizations on the website
  • 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 tables from SQL Queries and use it through the shortcodes and as predefined values in filters and editing.
  • MySQL based tables – how to create a wpDataTable based on a query to a MySQL table.
  • SQL query builder – built-in SQL query constructor with graphical user interface which allows a user to pick and jon other tables from database
  • WPDB query builder – built-in WPDB query constructor with graphical user interface which allows a user to pick the post types, custom/meta fields, and taxonomies
  • Foreign key – wpDataTables also has method for connecting several tables to each other by the Foreign key concept
  • Multiple databases support – wpDataTables is the only WordPress table plugin that can display the data from MySQL, MS SQL or PostgreSQL databases.
  • Handle large tables with millions of rows – wpDataTables Premium can create huge tables (millions of rows) in a matter of minutes. All the operations will be handled by the MySQL server.
  • Users can see and edit only their own data – allowing front-end users to see and edit only their own data
  • and much more…

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

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 datatables 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** – The Best WordPress report builder plugin that generate Word or Excel reports from 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 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

Useful links


Screenshots
FAQ
ChangeLog