Title: HTML tables and SQL queries
Last modified: August 30, 2016
---
# HTML tables and SQL queries
* Resolved [Mads Phikamphon](https://wordpress.org/support/users/madsphi/)
* (@madsphi)
* [10 years, 11 months ago](https://wordpress.org/support/topic/html-tables-and-sql-queries/)
* Hi,
* 1) On the description page it says that HTML tables can be imported. Does that
mean that my normal HTML tables in posts/pages are automatically converted to
Tablepress? (it would be awesome if the plugin does that).
* 2) Can the table data be based on SQL query, so I can fill the table based on
the results of a SELECT SQL query.
* Thanks,
Mads
* [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)
Viewing 5 replies - 1 through 5 (of 5 total)
* Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
* (@tobiasbg)
* [10 years, 11 months ago](https://wordpress.org/support/topic/html-tables-and-sql-queries/#post-6277022)
* Hi Mads,
* thanks for your post, and sorry for the trouble.
* 1) No, those tables will not be converted automatically, but you can import the
HTML code into TablePress manually and then replace it with the Shortcode of
the imported table.
* 2) Sorry, but I’ll have to disapppoint you here. TablePress does not support
making SQL queries, it uses a custom data storage.
* Regards,
Tobias
* Thread Starter [Mads Phikamphon](https://wordpress.org/support/users/madsphi/)
* (@madsphi)
* [10 years, 11 months ago](https://wordpress.org/support/topic/html-tables-and-sql-queries/#post-6277120)
* Thanks a lot for the reply.
* 1) That’s fantastic. Then it will not be a problem at all.
* 2) Guess I can use CSV instead. Will the table contents change automatically
when the data in the associated CSV change?
* Thanks again,
Mads
* Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
* (@tobiasbg)
* [10 years, 11 months ago](https://wordpress.org/support/topic/html-tables-and-sql-queries/#post-6277129)
* Hi,
* yes, you could import CSV files, by either uploading them or retrieving them
from a URL. The table will however not update automatically when the CSV file
changes, it’s a one-time import. You can of course import the file again and
replace the existing table.
Doing this in an automated fashion is also possible
with a TablePress Extension (see [https://tablepress.org/extensions/table-auto-import/](https://tablepress.org/extensions/table-auto-import/))
but in most scenarios where tables rarely change, that would be overkill.
* Regards,
Tobias
* Thread Starter [Mads Phikamphon](https://wordpress.org/support/users/madsphi/)
* (@madsphi)
* [10 years, 11 months ago](https://wordpress.org/support/topic/html-tables-and-sql-queries/#post-6277138)
* Thanks.
* Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
* (@tobiasbg)
* [10 years, 11 months ago](https://wordpress.org/support/topic/html-tables-and-sql-queries/#post-6277139)
* Hi,
* no problem, you are very welcome! 🙂
* Best wishes,
Tobias
Viewing 5 replies - 1 through 5 (of 5 total)
The topic ‘HTML tables and SQL queries’ is closed to new replies.
* 
* [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
* [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
* [Support Threads](https://wordpress.org/support/plugin/tablepress/)
* [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
* [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
* [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)
## Tags
* [html](https://wordpress.org/support/topic-tag/html/)
* [sql](https://wordpress.org/support/topic-tag/sql/)
* 5 replies
* 2 participants
* Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
* Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/html-tables-and-sql-queries/#post-6277139)
* Status: resolved