WP Manifestindependent plugin directory
manifest / admin / wordpress-export-database-table-to-csv

Simple Table Exporter

Export database tables from WordPress to CSV files directly from wp-admin.

by David Odhiambo · github.com/dvdopi/wordpress-export-database-table-to-csv · website

★ 0stars
0forks

Install

No release zip yet. The repository archive installs, but the folder name will carry the branch suffix and updates will not flow:

wp plugin install https://github.com/dvdopi/wordpress-export-database-table-to-csv/archive/refs/heads/main.zip
Readme github.com/dvdopi/wordpress-export-database-table-to-csv ↗

A lightweight WordPress plugin that lets administrators export any database table as a comma-separated values (CSV) file from the familiar wp-admin interface.

Features

  • Lists every table the WordPress database user can access and exports on demand.
  • Streams large tables in configurable batches to keep memory usage predictable.
  • Respects granular WordPress capabilities via a filter so you control who can export.
  • Ships with full internationalisation support and follows core security best practices.

Requirements

  • WordPress 5.0 or newer
  • PHP 7.4 or newer

Installation

  1. Copy the simple-table-exporter directory into wp-content/plugins/.
  2. In wp-admin, navigate to Plugins ▸ Installed Plugins and activate Simple Table Exporter.
  3. Visit Tools ▸ Table Export to start exporting tables.

Usage

  1. Open Tools ▸ Table Export. The plugin lists every table WordPress can see, including custom tables created by other plugins.
  2. Choose the table you want to export and click Export CSV.
  3. Your browser will download a CSV file named after the table and the current UTC timestamp.

Tip: If the table is very large, the export runs in batches to avoid exhausting PHP memory limits. Adjust the batch size using the filter documented below.

Customisation

Change the required capability

add_filter('simple_table_exporter_capability', static function () {
    return 'manage_options';
});

Adjust the export chunk size

add_filter('simple_table_exporter_chunk_size', static function () {
    return 1000; // Fetch 1,000 rows per query instead of the default 500
});

Development

  • The core logic lives in simple-table-exporter.php.
  • Run php -l wp-content/plugins/simple-table-exporter/simple-table-exporter.php to lint changes.
  • Contributions are welcome! Please open an issue or pull request describing the change you would like to make.

Security

Exports are restricted to users who have the export capability by default (Administrators). Always review capability tweaks carefully to ensure you do not expose sensitive data to unintended roles.

License

Released under the GNU General Public License v2 or later. You are free to use, modify, and distribute this plugin as long as derivative work remains GPL compatible.

Credits

Built by David Odhiambo and contributors. Inspired by day-to-day data export needs when working with bespoke WordPress applications.