Sync database tables with Excel for easy import/export, backups, and live editing directly from the WordPress dashboard.
| Author: | Simon (profile at wordpress.org) |
| WordPress version required: | 5.6 |
| WordPress version tested: | 6.9.4 |
| Plugin version: | 1.1.1 |
| Added to WordPress repository: | 28-08-2025 |
| Last updated: | 12-03-2026 |
| Rating, %: | 100 |
| Rated by: | 1 |
| Plugin URI: | |
| Total downloads: | 497 |
| Active installs: | 10+ |
Click to start download
|
DB Sync for Microsoft Excel is a powerful admin tool for syncing WordPress database tables with Excel files. Import .xlsx files, export tables, restore backups, and edit data live — all directly from the WP dashboard.
Perfect for site administrators, developers, and data-heavy use cases. No external services. No manual SQL. Just Excel and WordPress — in sync.
???? Key Features
- Excel import – Upload
.xlsx files to update existing tables. Preview and confirm before saving.
- Excel export – Download one or multiple tables as Excel files, bundled in a single ZIP.
- Live editing – Browse tables, edit cells inline, save changes instantly or cancel them.
- Backups & restore – Automatically back up tables before imports. Restore or delete backups as needed.
- Action logging – All data-changing operations are logged with timestamps.
- Lightweight & secure – No external API connections. Everything runs locally inside WordPress.
Screenshots
Main interface with Excel file upload and database restore from backups. Select a target table and import .xlsx files or restore a previous state.
Export interface for downloading one or more selected database tables as Excel files.
Live Edit view for editing WordPress database tables directly in the browser, with full control over option values.
Settings page showing debug info, writable path check, and options for deleting backups.
Does it require any special permissions?
Yes. The plugin needs write access to the following folder:
/wp-content/uploads/db-sync-for-excel/
This is where backups and temporary Excel files are stored.
Can I use it with custom database tables?
Yes. All tables in your database are accessible — including custom tables added by plugins or themes.
Does the Excel file need a specific format?
Yes. The file must:
– Be in .xlsx format
– Contain column headers in the first row
– Use column names matching those in the database table (case-insensitive)
Can I undo a failed import?
Yes. A backup of the affected table is created automatically before every import, and you can restore it via the “Restore from Backup” section.
Does the plugin support multisite?
Currently, the plugin supports single-site installations only. Multisite compatibility is planned for a future release.
Is this plugin affiliated with Microsoft?
No. DB Sync for Microsoft Excel is developed independently and is not affiliated with or endorsed by Microsoft.
ChangeLog
1.1.1
- Hardened sheet validation so invalid or mismatched sheets cannot trigger destructive imports.
- Fixed selected-sheet handling during import and improved live-edit support for non-integer primary keys.
- Updated WordPress compatibility metadata and refreshed bundled Excel library requirements.
1.0.4
- Added screenshot support and improved
readme.txt.
- Improved Live Edit UI responsiveness.
- Minor bugfixes and text improvements.
1.0.2
- Fixed export errors and restored Excel generation.
- Adjusted file paths for new vendor structure.
- Improved build process to fix plugin ZIP installation issues.
