{"id":246475,"date":"2025-08-28T09:49:23","date_gmt":"2025-08-28T09:49:23","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/excel-sync-for-wp\/"},"modified":"2026-03-12T17:19:02","modified_gmt":"2026-03-12T17:19:02","slug":"db-sync-for-excel","status":"publish","type":"plugin","link":"https:\/\/lug.wordpress.org\/plugins\/db-sync-for-excel\/","author":23132215,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"1.1.1","stable_tag":"1.1.1","tested":"6.9.4","requires":"5.6","requires_php":"7.4","requires_plugins":null,"header_name":"DB Sync for Microsoft Excel","header_author":"STec","header_description":"DB Sync for Microsoft Excel enables importing, exporting, backing up, and restoring WordPress database tables via Excel with preview, validation, and logging.","assets_banners_color":"343851","last_updated":"2026-03-12 17:19:02","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"","header_author_uri":"https:\/\/stec-online.com","rating":5,"author_block_rating":0,"active_installs":10,"downloads":508,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":{"1.0.1":{"tag":"1.0.1","author":"slm0n","date":"2025-08-28 09:49:13"},"1.0.4":{"tag":"1.0.4","author":"slm0n","date":"2025-08-28 15:56:12"},"1.0.5":{"tag":"1.0.5","author":"slm0n","date":"2025-08-28 16:00:39"},"1.0.6":{"tag":"1.0.6","author":"slm0n","date":"2025-08-28 17:15:10"},"1.0.7":{"tag":"1.0.7","author":"slm0n","date":"2025-08-28 18:06:09"},"1.0.8":{"tag":"1.0.8","author":"slm0n","date":"2025-08-28 18:26:08"},"1.0.9":{"tag":"1.0.9","author":"slm0n","date":"2025-09-08 10:16:31"},"1.1.0":{"tag":"1.1.0","author":"slm0n","date":"2025-11-05 14:14:02"},"1.1.1":{"tag":"1.1.1","author":"slm0n","date":"2026-03-12 17:19:02"}},"upgrade_notice":{"1.1.1":"

Improves import safety, updates compatibility metadata, and refreshes dependency requirements.<\/p>","1.0.4":"

Adds visual polish, enhanced editing features and better plugin directory integration.<\/p>","1.0.2":"

Fixes export functionality and ZIP packaging problems.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":1},"assets_icons":{"icon-128x128.png":{"filename":"icon-128x128.png","revision":3352115,"resolution":"128x128","location":"assets","locale":""},"icon-256x256.png":{"filename":"icon-256x256.png","revision":3352115,"resolution":"256x256","location":"assets","locale":""}},"assets_banners":{"banner-1544x500.png":{"filename":"banner-1544x500.png","revision":3352115,"resolution":"1544x500","location":"assets","locale":""},"banner-772x250.png":{"filename":"banner-772x250.png","revision":3352115,"resolution":"772x250","location":"assets","locale":""}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0.1","1.0.4","1.0.5","1.0.6","1.0.7","1.0.8","1.0.9","1.1.0","1.1.1"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":3352174,"resolution":"1","location":"assets","locale":""},"screenshot-2.png":{"filename":"screenshot-2.png","revision":3352174,"resolution":"2","location":"assets","locale":""},"screenshot-3.png":{"filename":"screenshot-3.png","revision":3352174,"resolution":"3","location":"assets","locale":""},"screenshot-4.png":{"filename":"screenshot-4.png","revision":3352174,"resolution":"4","location":"assets","locale":""}},"screenshots":{"1":"Main interface with Excel file upload and database restore from backups. Select a target table and import .xlsx<\/code> files or restore a previous state.","2":"Export interface for downloading one or more selected database tables as Excel files.","3":"Live Edit view for editing WordPress database tables directly in the browser, with full control over option values.","4":"Settings page showing debug info, writable path check, and options for deleting backups."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[151,153,6590,1859,87],"plugin_category":[59],"plugin_contributors":[246981],"plugin_business_model":[],"class_list":["post-246475","plugin","type-plugin","status-publish","hentry","plugin_tags-backup","plugin_tags-database","plugin_tags-excel","plugin_tags-export","plugin_tags-import","plugin_category-utilities-and-tools","plugin_contributors-slm0n","plugin_committers-slm0n"],"banners":{"banner":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/banner-772x250.png?rev=3352115","banner_2x":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/banner-1544x500.png?rev=3352115","banner_rtl":false,"banner_2x_rtl":false},"icons":{"svg":false,"icon":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/icon-128x128.png?rev=3352115","icon_2x":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/icon-256x256.png?rev=3352115","generated":false},"screenshots":[{"src":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/screenshot-1.png?rev=3352174","caption":"Main interface with Excel file upload and database restore from backups. Select a target table and import .xlsx<\/code> files or restore a previous state."},{"src":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/screenshot-2.png?rev=3352174","caption":"Export interface for downloading one or more selected database tables as Excel files."},{"src":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/screenshot-3.png?rev=3352174","caption":"Live Edit view for editing WordPress database tables directly in the browser, with full control over option values."},{"src":"https:\/\/ps.w.org\/db-sync-for-excel\/assets\/screenshot-4.png?rev=3352174","caption":"Settings page showing debug info, writable path check, and options for deleting backups."}],"raw_content":"\n

DB Sync for Microsoft Excel<\/strong> is a powerful admin tool for syncing WordPress database tables with Excel files. Import .xlsx<\/code> files, export tables, restore backups, and edit data live \u2014 all directly from the WP dashboard.<\/p>\n\n

Perfect for site administrators, developers, and data-heavy use cases. No external services. No manual SQL. Just Excel and WordPress \u2014 in sync.<\/p>\n\n

\ud83d\udd11 Key Features<\/h4>\n\n
    \n
  • Excel import<\/strong> \u2013 Upload .xlsx<\/code> files to update existing tables. Preview and confirm before saving.<\/li>\n
  • Excel export<\/strong> \u2013 Download one or multiple tables as Excel files, bundled in a single ZIP.<\/li>\n
  • Live editing<\/strong> \u2013 Browse tables, edit cells inline, save changes instantly or cancel them.<\/li>\n
  • Backups & restore<\/strong> \u2013 Automatically back up tables before imports. Restore or delete backups as needed.<\/li>\n
  • Action logging<\/strong> \u2013 All data-changing operations are logged with timestamps.<\/li>\n
  • Lightweight & secure<\/strong> \u2013 No external API connections. Everything runs locally inside WordPress.<\/li>\n<\/ul>\n\n\n
      \n
    1. Upload the plugin files to the \/wp-content\/plugins\/db-sync-for-excel\/<\/code> directory, or install it via the WordPress plugin screen.<\/li>\n
    2. Activate the plugin through the \"Plugins\" menu in WordPress.<\/li>\n
    3. Open \"DB Sync for Microsoft Excel\"<\/strong> in the admin menu and start importing\/exporting.<\/li>\n<\/ol>\n\n\n
      \n

      Does it require any special permissions?<\/h3><\/dt>\n

      Yes. The plugin needs write access to the following folder:
      \n \/wp-content\/uploads\/db-sync-for-excel\/
      \nThis is where backups and temporary Excel files are stored.<\/p><\/dd>\n

      Can I use it with custom database tables?<\/h3><\/dt>\n

      Yes. All tables in your database are accessible \u2014 including custom tables added by plugins or themes.<\/p><\/dd>\n

      Does the Excel file need a specific format?<\/h3><\/dt>\n

      Yes. The file must:\n- Be in .xlsx<\/code> format\n- Contain column headers in the first row\n- Use column names matching those in the database table (case-insensitive)<\/p><\/dd>\n

      Can I undo a failed import?<\/h3><\/dt>\n

      Yes. A backup of the affected table is created automatically before every import, and you can restore it via the \"Restore from Backup\" section.<\/p><\/dd>\n

      Does the plugin support multisite?<\/h3><\/dt>\n

      Currently, the plugin supports single-site installations only<\/strong>. Multisite compatibility is planned for a future release.<\/p><\/dd>\n

      Is this plugin affiliated with Microsoft?<\/h3><\/dt>\n

      No. DB Sync for Microsoft Excel is developed independently and is not affiliated with or endorsed by Microsoft<\/strong>.<\/p><\/dd>\n\n<\/dl>\n\n\n

      1.1.1<\/h4>\n\n
        \n
      • Hardened sheet validation so invalid or mismatched sheets cannot trigger destructive imports.<\/li>\n
      • Fixed selected-sheet handling during import and improved live-edit support for non-integer primary keys.<\/li>\n
      • Updated WordPress compatibility metadata and refreshed bundled Excel library requirements.<\/li>\n<\/ul>\n\n

        1.0.4<\/h4>\n\n
          \n
        • Added screenshot support and improved readme.txt<\/code>.<\/li>\n
        • Improved Live Edit UI responsiveness.<\/li>\n
        • Minor bugfixes and text improvements.<\/li>\n<\/ul>\n\n

          1.0.2<\/h4>\n\n
            \n
          • Fixed export errors and restored Excel generation.<\/li>\n
          • Adjusted file paths for new vendor structure.<\/li>\n
          • Improved build process to fix plugin ZIP installation issues.<\/li>\n<\/ul>","raw_excerpt":"Sync database tables with Excel for easy import\/export, backups, and live editing directly from the WordPress dashboard.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/246475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=246475"}],"author":[{"embeddable":true,"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/slm0n"}],"wp:attachment":[{"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=246475"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=246475"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=246475"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=246475"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=246475"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/lug.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=246475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}