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: