It’s incredible how much we can do with an online table in WordPress! Among all the configurations, designs, and customizations, we’re here to tell you how to create a data table with imported files. The only thing you need to do is selecting either a CSV or JSON file format using a quality WordPress table plugin.
Lately, table plugins have appeared as one of the most worthwhile tools for website owners. As a result, table creation online is nothing high-end anymore. Importing a table in CSV or JSON format is next to a zero-hassle task now.
Ways to create a data table with imported files
You only need to have a bit of knowledge about table plugins to understand this section. For example, if you have heard about Ninja Tables, you’re good to go!
We have picked Ninja Tables because it’s easier to demonstrate and already has a built-in “Import From Other WP Table Plugin” option. From here, you can pull out table data from TablePress, Ultimate Tables, and Data Tables Generator by Supsystic. However, you need to create a table beforehand using these plugins if you want to import and show it on Ninja Tables.
In this article, we’ll show you two ways to create a data table with imported files.
You must be feeling a bit flustered now. Don’t worry. We’ll walk you through it all.
1. Ninja Tables table data import
First of all, go to the All Tables panel in the Ninja Tables dashboard and open the table you want to import. Hover over it or click-open to edit.
Now, move over to the Import-Export tab and click “Export”. We need to export a CSV or JSON file first and save it in the device.
Here’s the table “Import-export example” we chose to export.
Once you go to Import-Export and click “Export”, a format option will show a dropdown for whether you want CSV or JSON.
Note: When you export CSV, you are only exporting the data. On the other hand, when you export JSON, you get the table style and all other customization ready.
Proceed to click export and save it on your computer. Try the documentation if you want.
Secondly, click on the green “Import Table” button from the Ninja Tables dashboard to import the recently saved CSV file.
You can also go to the “Tools and Settings” tab on the top panel or “Tools” on the sidebar. After you click on the green button, the window will show you the way to import.
Precisely, that’s all you have to do to create a table from the imported CSV/JSON file! Choose the file as directed. For our demo, we have chosen the previously exported and downloaded CSV file “Import-export example.csv”.
Finish the step by clicking “Import”. You will see a notification popup saying- Successfully added a table.
Here’s the table from the CSV file.
Since it isn’t a JSON file, it needs customization and styling from scratch. Editing an imported data table in Ninja Tables is the same as the default table.
Take a peek at the documentation to learn how to create a table from a CSV file.
2. Import from TablePress
To import from the other WordPress table plugins, you simply have to move to “Tools and Settings” in the Ninja Tables dashboard. Or click on the green import button to get a window like the following.
Earlier on, we decided to show the process with TablePress. So, that’s what we’re going with.
Note: You should have a table ready in other table plugins to import it.
Here’s the “Import demo” data table made with TablePress.
Now, go to “Tools and Settings” in the Ninja Tables dashboard and click “Import” for the corresponding plugin.
A window popup will open with all the current tables. You can move on by selecting a specific one. Even if the table is already imported, you can do it again.
The table title mentions that it’s imported from TablePress. Now you can customize and stylize the table with the features of Ninja Tables.
Have a look at the documentation.
In this short piece, we have listed two ways to create a data table with imported files-
- Using Ninja Tables import-export function and
- By importing data from TablePress plugin.
Whichever way you choose, the shortcode generated by Ninja Tables is all you need! Simply paste the code anywhere on your WordPress Posts/Pages, and the table will appear.
Let’s stop dragging it for now. You can knock us anytime for any query. And since you’re here, check out How To Embed Online Data Tables.