Descripción
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
.xlsxfiles 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.
Capturas
.xlsx files or restore a previous state.
Instalación
- Upload the plugin files to the
/wp-content/plugins/db-sync-for-excel/directory, or install it via the WordPress plugin screen. - Activate the plugin through the «Plugins» menu in WordPress.
- Open «DB Sync for Microsoft Excel» in the admin menu and start importing/exporting.
FAQ
-
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.xlsxformat
– 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.
Reseñas
Colaboradores y desarrolladores
«DB Sync for Microsoft Excel» es un software de código abierto. Las siguientes personas han colaborado con este plugin.
Colaboradores
Traduce «DB Sync for Microsoft Excel» a tu idioma.
¿Interesado en el desarrollo?
Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.
Registro de cambios
1.1.4
- Restored the dark gradient admin header.
- Fixed multi-select spacing, clear controls, selected table chips, and field width.
1.1.3
- Refreshed the admin interface with a more consistent WordPress-native design.
- Improved button, field, Select2, table, notice, loader, and modal styling.
- Kept the branded admin menu icon visible across the WordPress dashboard.
1.1.2
- Stores temporary import files in protected plugin storage with runtime access guards.
- Uses per-admin preview sessions to avoid cross-user import collisions.
- Restores the original table automatically if an import write fails.
- Blocks incompatible or unrelated backup restores before target tables are truncated.
- Confirms compatibility metadata for WordPress 7.0.
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.