Please wait...

Creating tables showing data from CSV files

Video versionA video overview of CSV-based wpDataTables

Example of a CSV-based tablewpDataTables supports CSV data source

CSV, or “comma-separated-values” format is very wide-spread, because it’s very simple, lightweight, and almost any software can generate it, or users can even create it manually. Basically, it’s just a text file, where cells are separated with commas, rows are separated with new lines, and first line contains table headers. CSV was supported by wpDataTables from the very first release.

You can download the file that was used to generate this table from this link. The table rendered from this file is below.

See the step-by-step tutorial below the table.

This format is fine only till a certain limit (no exact limit, but let’s say 3000-5000 cells), if you have a larger file, the page load time will increase. For large data sets it makes sense to import the data to MySQL, you can use “Create a table by importing data from data source” option to do this.

Instructions to create the table

Creating Tables in WordPress from CSV files instructions

The first thing you would need to do to create a CSV-based table in WordPress is to create the CSV file with your data set in your favourite software. It can be MS Excel, OpenOffice, LibreOffice, Numbers, Google Spreadsheet, or any other.

Save it at some location where you can easily find it later.

Create a wpDataTable and upload your CSV file

After you saved the CSV file with your data, the next step is to go to your WordPress admin and create a new wpDataTable from CSV data source.

Please open your WordPress admin, and:

Create a table linked to an existing data source

1. Go to wpDataTables -> Create a Table and choose Create a table linked to an existing data source option.

Creating Tables in WordPress from CSV

2. Set some name for your new wpDataTable that will help you to find the table later.
3. Choose CSV file as the Input data source type.
4. Click Browse… near the Input file, the WordPress Media Library pop-up will appear.

Creating Tables in WordPress from CSV

5. Upload the CSV file that you prepared in the Step 1, and click the Use selected file button.
6. Click Apply so that wpDataTables would read the CSV file that you uploaded, and initialize the columns metadata.

(Optional) - Define additional column and table settings

At this point table is already prepared. But to improve the usability we need to define some additional settings for the table and for its columns. In this case we defined these settings:

1. Enabled Limit table width checkbox and disable Table title checkbox on “Display” tab.
2. Set the Filter type for “Country“, “Region” and “Color” columns as “Select box”.
3. Set the Filter type for “Grape” and “Sweetness” columns as “Checkbox“.

Insert the wpDataTable in your page or post

Inserting wpDataTables shortcode on page or post

When configuration of your CSV-based wpDataTable is finished, you just need to insert it to your post or page.

Open (or create a new) a WordPress post or page, place the cursor in the position where you would like to insert your table, click the “Insert a wpDataTable” button in the MCE editor panel, and choose the CSV-based table that you prepared.

Or, if you prefer to do things manually, you can just copy&paste the wpdatatable shortcode (you can find it in the wpDataTables browse page, or in wpDataTable edit page).

Never miss new features!

Join 2000+ 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.

We never spam or disclose your address to anyone.