Please wait...

Creating a table in WordPress using the Wizard

Video versionA video overview of Table Creation Wizard

Step 1First step - choose the type of table that you would like to create

Table Creation Wizard in WordPress

In the first wizard step, you are shown the different ways of creating a table in WP – which lead to different table types. An explanation of the differences is provided under each option. There is no configuration on this step, you simply need to choose one of the options and click “Next“.

If you choose the first option, you’ll  be redirected to the Configure table page, where you can choose the data source (MySQL, Excel, CSV, Google Spreadsheet, JSON, XML, Serialized PHP array) and create the table – read more about it here.

Step 2, manually created tablesConfigure the table and column structure

If you choose to create a table manually, on the second step, you’ll be able to configure the table structure by setting the table name, number of columns, each column name, column data type, and defining possible values (if necessary), and the default value for the editor.

Once you configure the structure and press ‘Create the table’, your table will be created, and you will be redirected to the table configuration editor.

You can read the full instructions on creating this type of table here.

Step 2, importing table dataProvide the CSV/Excel file or link to Google Spreadsheet with the data to import

If you choose to create a table by importing table data from a given data source (Excel or CSV file, or Google spreadsheet), will be asked to provide a file, if you use Excel or CSV, or paste a URL if you use Google Spreadsheet.

Read here for the full instructions for creating this type of tables.

Step 2, generate a WordPress DB queryChoose the posts and post properties that you would like to add to the query

If you choose to create a table based on a query to the WordPress database, you will see a screen where you’ll be asked to choose the posts and post properties that you will use in the table.

The first column displays all the post types registered in your WordPress. When you select the ones you want to use, and click “Add”, they will appear in the second column. The third column displays the list of post properties available to be displayed in the table – you can then add the post properties you’ve selected to the fourth column, to create a list of your table fields.

In the bottom part you can configure conditions for the query, and the grouping rules.

You can read the full instruction on creating such tables here.

When you’ve defined all the query parameters, click ‘Next‘ to go to the table preview step.

Step 2, generate a MySQL DB queryChoose tables and columns that you would like to add to the query

Table Creation Wizard - create MySQL query

If you choose to create a table based on a query to MySQL database, you will see a screen where you can choose the tables and columns you want to use in the table.

The first column shows all the tables registered in your MySQL database. Select the ones that you want to use, and click “Add”. They will appear in the second column. In the third column, you’ll see a list of available post columns to be displayed in the table. You can then add these post columns to the fourth column by clicking “add”. The fourth column will now contain the list of your table fields.

In the bottom part, you can configure conditions for the query and the grouping rules.

You can read the full instruction on creating such tables here.

After you’ve defined all the query parameters, click ‘Next‘ to go to the table preview step.

Step 3, Configure table importChoose which columns to import and set the new column types

When you are creating a table by importing data from a data source, in Step 3, you will preview the columns that wpDataTables fetched in the provided file or URL; see the ‘guessed’ data type (change it if necessary), preview the data, and remove some columns from import if necessary, or optionally add new ones.

You can find the full instructions on how to create wpDataTables based on importing data from different data sources here.

When you finish configuring, and click ‘Next‘, the table will be created, the data will be imported, and you will be redirected to the table configuration page.

Step 3, Preview generated querySee the query that has been generated and the preview the result

wpDataTables generated query preview

When you are creating a table by generating a query to the WordPress database, or the MySQL database, the third step of the wizard is to preview the query, with the option to edit it if necessary, and to preview of first rows of the future table.

You can click on refresh button to refresh the preview if you edit the query.

Once you are satisfied with the preview, you can click ‘Next‘ to create a wpDataTable based on this query.

You can read full instructions about creating this type of tables here for MySQL, and here for WordPress databases.

Never miss new features!

Join 3000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

By clicking "subscribe" you consent that the information you provide via this form will be securely processed and stored in compliance with EU privacy laws (GDPR).
This  information will be used to send you newsletters as well as pre-populate any forms, should you want to edit your newsletter preferences.
You can always use this link to unsubscribe from the newsletter. You can see our Privacy Policy here.