Title: DB Sync for Microsoft Excel Author: Simon Published: 28 Ogos 2025 Last modified: 27 Mei 2026 --- Search plugins ![](https://ps.w.org/db-sync-for-excel/assets/banner-772x250.png?rev=3352115) ![](https://ps.w.org/db-sync-for-excel/assets/icon-256x256.png?rev=3352115) # DB Sync for Microsoft Excel Oleh [Simon](https://profiles.wordpress.org/slm0n/) [Download](https://downloads.wordpress.org/plugin/db-sync-for-excel.1.1.4.zip) * [Details](https://ms.wordpress.org/plugins/db-sync-for-excel/#description) * [Reviews](https://ms.wordpress.org/plugins/db-sync-for-excel/#reviews) * [Pemasangan](https://ms.wordpress.org/plugins/db-sync-for-excel/#installation) * [Pembangunan](https://ms.wordpress.org/plugins/db-sync-for-excel/#developers) [Support](https://wordpress.org/support/plugin/db-sync-for-excel/) ## Description **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.⌉⌊Main interface with Excel file upload and database restore from backups. Select a target table and import .xlsx files or restore a previous state.⌉[ 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.⌉⌊Export interface for downloading one or more selected database tables as Excel files.⌉[ 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.⌉⌊Live Edit view for editing WordPress database tables directly in the browser, with full control over option values.⌉[ 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.⌉⌊Settings page showing debug info, writable path check, and options for deleting backups.⌉[ Settings page showing debug info, writable path check, and options for deleting backups. ## Installation 1. Upload the plugin files to the `/wp-content/plugins/db-sync-for-excel/` directory, or install it via the WordPress plugin screen. 2. Activate the plugin through the “Plugins” menu in WordPress. 3. 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 `.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**. ## Reviews ![](https://secure.gravatar.com/avatar/6fcddb3a3c63bb2cea4954bd267fe41c3aefe35f24611e4e7e1d4e8da97f36ea? s=60&d=retro&r=g) ### 󠀁[Super useful plugin.](https://wordpress.org/support/topic/super-useful-plugin-54/)󠁿 [Simon](https://profiles.wordpress.org/slm0n/) 28 Ogos 2025 Makes it easy to sync Excel files with the database without messing with phpMyAdmin. Import, export, even edit live — all from the dashboard. Works smoothly. [ Read all 1 review ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/) ## Contributors & Developers “DB Sync for Microsoft Excel” adalah perisian sumber terbuka. Orang-orang berikut telah menyumbang kepada pemalam ini. Penyumbang * [ Simon ](https://profiles.wordpress.org/slm0n/) [Translate “DB Sync for Microsoft Excel” into your language.](https://translate.wordpress.org/projects/wp-plugins/db-sync-for-excel) ### Berminat dalam pembangunan? [Layari kod](https://plugins.trac.wordpress.org/browser/db-sync-for-excel/), periksa [repositori SVN](https://plugins.svn.wordpress.org/db-sync-for-excel/), atau langgani [log pembangunan](https://plugins.trac.wordpress.org/log/db-sync-for-excel/) dengan [RSS](https://plugins.trac.wordpress.org/log/db-sync-for-excel/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 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. ## Meta * Version **1.1.4** * Last updated **1 bulan lalu** * Active installations **10+** * WordPress version ** 5.6 or higher ** * Tested up to **7.0** * PHP version ** 7.4 or higher ** * Language * [English (US)](https://wordpress.org/plugins/db-sync-for-excel/) * Tags * [backup](https://ms.wordpress.org/plugins/tags/backup/)[database](https://ms.wordpress.org/plugins/tags/database/) [excel](https://ms.wordpress.org/plugins/tags/excel/)[export](https://ms.wordpress.org/plugins/tags/export/) [import](https://ms.wordpress.org/plugins/tags/import/) * [Paparan Lanjutan](https://ms.wordpress.org/plugins/db-sync-for-excel/advanced/) ## Ratings 5 out of 5 stars. * [ 1 5-star review ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/) ## Penyumbang * [ Simon ](https://profiles.wordpress.org/slm0n/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/db-sync-for-excel/)