Title: DB Sync for Microsoft Excel Author: Simon Published: 2025 年 8 月 28 日 Last modified: 2026 年 5 月 27 日 --- 搜尋外掛 ![](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 由 [Simon](https://profiles.wordpress.org/slm0n/) 開發 [下載](https://downloads.wordpress.org/plugin/db-sync-for-excel.1.1.4.zip) * [詳細資料](https://tw.wordpress.org/plugins/db-sync-for-excel/#description) * [使用者評論](https://tw.wordpress.org/plugins/db-sync-for-excel/#reviews) * [安裝方式](https://tw.wordpress.org/plugins/db-sync-for-excel/#installation) * [開發資訊](https://tw.wordpress.org/plugins/db-sync-for-excel/#developers) [技術支援](https://wordpress.org/support/plugin/db-sync-for-excel/) ## 外掛說明 **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. ## 螢幕擷圖 * [[ * 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. ## 安裝方式 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. ## 常見問題集 ### 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**. ## 使用者評論 ![](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/) 2025 年 8 月 28 日 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. [ 閱讀全部 1 則使用者評論 ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/) ## 參與者及開發者 以下人員參與了開源軟體〈DB Sync for Microsoft Excel〉的開發相關工作。 參與者 * [ Simon ](https://profiles.wordpress.org/slm0n/) [將〈DB Sync for Microsoft Excel〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/db-sync-for-excel) ### 對開發相關資訊感興趣？ 任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/db-sync-for-excel/)、 查看 [SVN 存放庫](https://plugins.svn.wordpress.org/db-sync-for-excel/)，或透過 [RSS](https://plugins.trac.wordpress.org/log/db-sync-for-excel/?limit=100&mode=stop_on_copy&format=rss) 訂閱[開發記錄](https://plugins.trac.wordpress.org/log/db-sync-for-excel/)。 ## 變更記錄 #### 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. ## 中繼資料 * 版本 **1.1.4** * 最後更新 **15 小時前** * 啟用安裝數 **20+** * WordPress 版本需求 ** 5.6 或更新版本 ** * 已測試相容的 WordPress 版本 **7.0** * PHP 版本需求 ** 7.4 或更新版本 ** * 語言 * [English (US)](https://wordpress.org/plugins/db-sync-for-excel/) * 標籤: * [backup](https://tw.wordpress.org/plugins/tags/backup/)[database](https://tw.wordpress.org/plugins/tags/database/) [excel](https://tw.wordpress.org/plugins/tags/excel/)[export](https://tw.wordpress.org/plugins/tags/export/) [import](https://tw.wordpress.org/plugins/tags/import/) * [進階檢視](https://tw.wordpress.org/plugins/db-sync-for-excel/advanced/) ## 評分 5 星，滿分為 5 星 * [ 1 個 5 星使用者評論 ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=5) * [ 0 個 4 星使用者評論 ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=4) * [ 0 個 3 星使用者評論 ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=3) * [ 0 個 2 星使用者評論 ](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/?filter=2) * [ 0 個 1 星使用者評論 ](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) [查看全部使用者評論](https://wordpress.org/support/plugin/db-sync-for-excel/reviews/) ## 參與者 * [ Simon ](https://profiles.wordpress.org/slm0n/) ## 技術支援 使用者可在技術支援論壇提出意見反應或使用問題。 [檢視技術支援論壇](https://wordpress.org/support/plugin/db-sync-for-excel/)