wpDataTables – WordPress Tables & Table Charts Plugin WordPress 插件
描述
wpDataTables is a popular WordPress table plugin used to quickly create 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 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. In other words, the same website can be presented differently on a laptop, mobile phone or a tablet.
Any wpDataTable can be responsive table, it doesn’t matter which data source do you use – CSV, JSON , Excel, or any other. In this WordPress responsive table plugin you can choose which columns do you want to be visible or hidden on tablets and/or mobiles. The hidden columns’ data will be still available for the users that would like to see it in a dropdown; it will collapse under an expandable block in the first visible column. 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 WordPress table from Excel
Microsoft Excel is a very powerful tool and one of the most efficient software for graphic-analytical and tabular data processing. It speeds up and make work in the workplace tables easier, easy to learn, easy to use and fast in displaying work results. It is awesome analysis spreadsheet for many business users. 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. wpDataTables is deeply integrated with Excel. In just a few clicks you can create awesome WordPress tables with search, sort, pagination, custom skins and lot more. 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 WordPress 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 create responsive, searchable and sortable WordPress tables quite easy. You can find detail instructions on the link How to create WordPress tables from CSV files.
Generate WordPress table from XML
XML – (Extensible Markup Language) is a universal standard for presenting data. It is one of the most widely used standards for data transfer between the server and the client. It is increasingly used as a standard in which documents are saved (Libre Office and Microsoft Office). Finally, the HTML standard for creating web pages is derived from the SGML or XML standard. 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 (JavaScript Object Notation) is a popular interlingual data exchange format. Many server applications provide public data in JSON format. JSON is based on the syntax of Javascript objects. Since most web applications use client-side JavaScript, 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 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 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. As you know, in this case, you will upload the file and initialize the table, whereupon it will be read every time the page loads. Before this version of wpDataTables, if the source file was larger than 3.000 – 5.000 rows, the page load and generation time was slow. But not anymore!
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. It will update table cached data based on the source file following the time interval that you will set in the cron job. 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, that previous input data sources (Excel, CSV, XML, JSON or Nested JSON) are not flexible enough for dynamic data presentation. We didn’t want to limit your freedom in wpDataTables, so we implemented serialized PHP arrays as one of data sources, so you are able to create dynamic datatables. You can prepare data from some private or public API, or use WP Query to get data from your posts, get data by depending on some variables in the URL, or use some other complex logic. 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. On each step you can go back to change the settings with huge number of customization options. In the “Formatting and preview” step, you can see a live chart preview, so you can check if you’re satisfied with the look of the chart before saving it and inserting it to a WordPress post or page. 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. The editing steps are the same as the steps used to create the chart. 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. It is quite easy to set the grouping for a chart with single option “Group chart” in chart wizard. More in our docs about Grouping data in WordPress Charts.
wpDataTables allows creating 14 different chart types using the Google Charts rendering engine:
- Google Line Chart – Live example
- Google Column Chart – Live example
- Google Pie Chart – Live example
- Google Area Chart – Live example
- Google Stepped area Chart – Live example
- Google Histogram – Live example
- Google Bar Chart – Live example
- Google Stacked Bar Chart – Live example
- Google Bubble Chart – Live example
- Google Donut Chart – Live example
- Google Gauge Chart – Live example
- Google Scatter Chart – Live example
- Google Candlestick Chart – Live example
- Google Waterfall Chart – Live example
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:
- Chart.js Line Chart – Live example
- Chart.js Column Chart – Live example
- Chart.js Area Chart – Live example
- Chart.js Stacked area Chart – Live example
- Chart.js Radar Chart – Live example
- Chart.js Polar Chart – Live example
- Chart.js Pie Chart – Live example
- Chart.js Doughnut Chart – Live example
- Chart.js Bubble Chart – Live example
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, 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
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:
- Avada Page Builder,
- Divi Page Builder,
- WPBakery Page Builder or
- Elementor.
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“. Beside those export buttons, it is available column visibility button as well, with which you are able easily to control the visibility of columns in a WordPress table on back-end and front-end as well.
All these functionalities are configurable, and it is your decision whether to toggle these on or off. More info in our docs about Table tools in wpDataTables and Table and column settings (simple table has own customization panel).
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. When the sorting is enabled, each column header will become “interactive”. If you need to sort by multiple columns, it is possible with “Shift” button on the keyboard. While holding it you are able to click on other columns’ header(initially, the ordering will be done based on the first column, and after that, based on the second column).
Detail explanation you can find in our documentation about Creating a sortable table in WordPress.
Column types and features
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:
- String – Text and video documentation
- Integer – Text and video documentation
- Float – Text and video documentation
- Date – Text and video documentation
- DateTime – Text and video documentation
- Time – Text and video documentation
- Image – Text and video documentation
- URL link – Text and video documentation
- E-mail link – Text and video documentation
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.
Please note some limitations compared to the Premium version of the wpDataTables plugin:
- MySQL-query based tables support is not included.
- Creating tables from the Google Spreadsheet files is not included.
- Create a datatables manually is not included.
- Server-side processing is not included.
- Table filters are not included.
- Front-end table editing is not included.
- Excel-like editing is not included.
- Advanced HighCharts and ApexCharts are not included.
- Table Constructor Wizard (step-by-step table generator) is not included.
- Customize options for each table are not included.
- 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 60,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, 3 or unlimited years of updates and support
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.
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.
- Huge Amount of Data – wpDataTables Premium can create huge tables (millions of rows) 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 4 powerful engines (Google, Highcharts, Chart.js and NEW ApexCharts) 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 tables from 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 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.
For Developers
This section is intended for advanced users to extend or change wpDataTables functionality. At least a basic understanding of coding in PHP and JavaScript is required.
- wpDataTables Actions
- wpDataTables Filters
- Front-end Table callbacks
- Front-end Chart callbacks
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
Useful links
- Official Page – wpDataTables – WordPress Table Plugin
- Documentation – How to use wpDataTables?
- Learn from our tutorials on Youtube channel
- Showcases for every industry
- Facebook Page
- Instagram Feed
- Twitter Profile
