Beskriuwing
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.
Skermôfbyldings
Main interface with Excel file upload and database restore from backups. Select a target table and import .xlsxfiles 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.
Ynstallaasje
- 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.
Resinsjes
Meiwurkers & amp; Untwikkelders
“DB Sync for Microsoft Excel” is iepen boarne software. De folgjende minsken hawwe bydroegen oan dizze plugin.
Meiwurkers
Oersette “DB Sync for Microsoft Excel” yn jo taal.
Ynteressearre yn ûntwikkeling?
Blêdzje troch de koade , besjoch de SVN-repository , of abonnearje op it ûntwikkelingslogboek troch RSS .
Feroaringslog
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.