This WordPress plugin lets you automatically schedule the export of a table from a MySQL query made on the WordPress database, and save it as a CSV file. You can then use this CSV file anyway you want

Works with the TablePress Automatic Periodic Table Import extension, so you can show/view/display any database table on a WordPress page.

Version 1.0.0 has no settings page yet, so all changes need to be made in the /wp-content/plugins/auto-export-db-table-to-file/auto-export-db-table-to-file.php file directly.

Download from here:
auto-export-db-table-to-file-v1.0.0.zip