The Easy Way to Manage Tables in WordPress with the wpDataTables Plugin – Websites that are built for business, analytical, financial, corporate and various web purposes such as schools and universities, of course, will never get away from work related to data displayed in tables and charts. It is very much needed and also very often data in the form of tables, charts and graphs will be displayed on these websites.
However, the problem is that data in the form of tables and charts is not easy to display on the website, in contrast to written data, which is certainly very easy for us to enter and organize to make it look good on the website. If we want to create tables, knowledge of html code is needed and if you want to look even better you must also understand CSS. And it makes things feel difficult, takes a long time and not everyone can display tables and charts to look good on the website.
Currently, a lot of websites are built using WordPress for business, personal, online store, companies, schools and universities, this happens because WordPress is very easy to use even for beginners and WordPress has the ability to create various websites for various purposes.
Besides that, WordPress has a lot of plugins that can be added according to the purpose of the website, and these plugins have made WordPress a strong web platform from then on. And if you are a WordPress user who is currently having trouble managing data in the form of tables and charts, then you can easily find plugins that you can use to manage the table and charts data. But a lot of the plugins don’t work very well for your purposes and have very limited features. To shorten your search time to find a plugin that can best manage tables and graphs, here I will introduce a cool plugin with full features to easily manage table and graph data namely wpDataTables.
What is wpDataTables?
wpDataTables is a premium WordPress plugin that can turn your site into a spreadsheet application without requiring any coding skills. With this wpDataTables plugin you can easily do your work in managing data in the form of tables and graphs on the WordPress website and can also process tables generated from various sources such as Excel files, CSV, MySQL queries, XML and JSON. So, with this wpDataTables plugin you can upload files containing table data such as from Excel and then let this plugin to process the data in the table according to the appropriate format for inclusion in posts or pages on your WordPress site.
This plugin is very popular and has been trusted to be used by more than 10,000 companies and individuals to manage table and graph data for financial, scientific, statistical, commercial and many others.
Using wpDataTables is really easy because it doesn’t require complicated configuration and creates tables and graphs with just a click without having to think about any code. And it is proven that 70% of users say that wpDataTables is easy to learn. So you don’t need to worry about having trouble using it. In addition, tables and charts can appear responsively, which means they will appear perfectly on various screen sizes.
WpDataTables Pricing and Features
wpDataTables is not free but it is sold at a very cheap price considering the many features and capabilities this plugin has to manage complex tables and charts. You can get this plugin for:
- $ 35 (Regular License) 1 time pay or lifetime, get free updates forever and free support for 6 months (+11.63 for 12 months support).
- $ 175 (Extendet License) 1 time pay or lifetime, get free updates forever and free support for 6 months (+ $ 58.13 for 12 months support).
The wpDataTables feature cannot be doubted because the number of features that the wpDataTabels plugin brings is very complete and beats all the competition with other similar plugins and by buying this plugin you will still get new features forever.
Here are the excellent features that you can get from wpDataTables:
If we were to write a complete list of features, this page would be too large. So here’re just a few good features:
Tables, charts and graphs created with wpDataTables will be displayed responsively so that they appear perfectly on a variety of devices and screen sizes.
Very Large Table
wpDataTables works very fast with large tables of data even up to millions of rows. All operations will be handled by the MySQL server so that table data is displayed very quickly. And tables you can set to display only a few entries and split by paginations.
wpDataTables mmapu creates, edits and deletes tables as desired and in addition the user can edit the contents of the table from an inline table, or from a form that has been generated.
Advanced Filter and Search
wpDataTables has a search and filter feature that makes it easy for you to find data in a table quickly. This feature is very comprehensive because you can set it with several filtering methods.
wpDataTables generates a shortcode which is used to insert multiple tables on a single page or post. This makes it easier for users to manage table placement in posts and pages.
It is possible to highlight cells, rows, columns depending on their content this feature is like the Conditional Formatting feature like in Excel.
Each table can be used as a data source for charting. The charts are provided by 3 powerful engines (Google charts, Highcarts, carts.js) and can change in realtime. And there are various kinds of chart forms that can be generated from table data such as area, bar, column, line and pie.
The resulting tables can be exported by users easily with various file formats such as Excel, PDF and CSV. Besides that, there is also an option button to print and copy tables quickly.
And those are some of the excellent features of wpDataTables that I can mention, there are many other features that you can find after using this plugin. Now let’s move on to how to use the wpDataTables plugin below.
How to use the wpDataTables plugin
To use the wpDataTables plugin the first thing you have to do is purchase this plugin via -> CodeCanyon. And after making a payment, you can download the wpDataTables file as a zip file.
After that, please install via the WordPress Dashboard by selecting the zip file that you just downloaded, and if you don’t succeed, please install the plugin via FTP. Or if you don’t understand in depth about how to install a WordPress plugin, please read Guide on how to install a complete WordPress plugin.
Furthermore, after the plugin has been installed, don’t forget to activate the wpDataTables plugin. And you will see a new menu in the admin sidebar with the name “wpDataTables“.
Before creating a table, please configure this plugin by going to the wpDataTables »Settings menu. There you will see three tabbed menus consisting of “Main Settings”, “Colors and font settings” and “Custom JS and CSS”.
In section Main Settings This allows you to do settings such as language, number of tables per page, basic skin, date, time and many more. The most important thing in this section is if you want to connect wpDataTables with your WordPress MySQL database then you have to check the “Use separate MySQL connection” option and then fill in your SQL settings.
- MySQL host: MySQL host address, domain or IP-address.
- MySQL database: The name of the database that you want to use.
- MySQL user: Username used to login.
- MySQL password: Password used to login.
- MySQL port: if you are using a non-standard (different from 3306) port on your MySQL server you can specify it here.
- Test MySQL connection: Use this button to check if the settings are correct.
And to get updates automatically, please enter the purchase code wpDataTables from your CodeCanyons in the “Purchase Code”.
Next to Colors and font settings is a section for adjusting colors and fonts for all your table needs, and you can leave this section if you don’t want to use the default settings. And to Custom JS and CSS, You can enter your own JS and CSS code in this section of the settings.
After all the configuration you have done in the settings section, the next step is to create a table on wpDataTables. In this section I will only give an example of making a table taking from a table that has been created from an excel file with the format .XLS or .XLSX.
First, please click the wpDataTables menu »Add from data source.
Please enter the table name in the “Table title” then select the Table type “Excel file”. And then select “Upload file” and please upload the excel file that you will make into a table in wpDataTables which you have uploaded to the WordPress media library.
In the “Additional Settings” section there are many options for the tables displayed in your station such as Responsive, Scrollable, Filtering, Sorting, Limit tables and many more.
If you have selected everything according to your wishes then don’t forget to click the “Save” button to save the configuration you have done.
The last is to insert the table that has been created in the post or on the page. To insert this table is very easy, please create a new post or edit an existing one and place the cursor on the row where the table you want to appear, if you have clicked the “Insert a wpDataTables” icon which is on the editor menu.
Then a wpDataTable popup will appear with a dropdown menu, please select the table name you want to insert. If you have, please press the “OK” button.
After that you will see the shortcode installed in the section you want. If you have, please click Publish or Updates, and see the results. Then the table that you created earlier from the excel file looks like the image below on your website.
And that’s a brief explanation of the wpDataTables plugin, to learn more clearly and completely for how to use wpDataTables such as creating tables like CSV, Google Spreadsheets with the table constructor and creating charts directly on the remsi documentation of wpDataTables here ⇒ Documentations and Demos wpDataTables.
Hopefully this article was useful for you and good luck with the wpDataTables plugin. 🙂