Simon

DB Sync for Microsoft Excel is a powerful admin tool for syncing WordPress database tables with Excel files. Import <code>.xlsx</code> 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.
<h4>🔑 Key Features</h4>
<ul>
<li>Excel import – Upload <code>.xlsx</code> files to update existing tables. Preview and confirm before saving.</li>
<li>Excel export – Download one or multiple tables as Excel files, bundled in a single ZIP.</li>
<li>Live editing – Browse tables, edit cells inline, save changes instantly or cancel them.</li>
<li>Backups & restore – Automatically back up tables before imports. Restore or delete backups as needed.</li>
<li>Action logging – All data-changing operations are logged with timestamps.</li>
<li>Lightweight & secure – No external API connections. Everything runs locally inside WordPress.</li>
</ul>

DB Sync for Microsoft Excel


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.


Super useful plugin.

Sync database tables with Excel for easy import/export, backups, and live editing directly from the WordPress dashboard.

docxpresso

If you are used to write all your documents using a Office Suite Word Processor or Spreadsheets like the ones available in MS Office, Libre Office or Open Office <a href="http://www.docxpresso.com" title="PDF, Word and ODF documents from HTML5" rel="nofollow ugc">Docxpresso</a> is the WordPress plugin you are looking for!
<blockquote>
This plugin will allow you to publish content that has been generated with your favourite Office Suite (MS, Libre or Open Office) preserving all of its structure, design and format:
<ul>
<li>Nicely formatted text</li>
<li>Headings</li>
<li>Tables (sortable and responsive)</li>
<li>Links and bookmarks</li>
<li>Nested lists with sophisticated numberings</li>
<li>Images</li>
<li>Charts</li>
<li>Textboxes</li>
<li>Footnotes and endnotes</li>
<li>Headers and Footers</li>
<li>Tables of contents (TOCs)</li>
<li>Comments</li>
<li>Math equations</li>
<li>Drop caps</li>
<li>Office SmartArt and forms (partial)</li>
<li>Support for Right-To-Left languages</li>
</ul>
</blockquote>
You may even create sortable tables or even export your charts in a browser friendly manner.
This plugin is a spin-off of our <a href="http://www.docxpresso.com" title="Generate dynamically all your documents online" rel="nofollow ugc">Docxpresso API</a> library designed to generate all kind of dynamical documents on your web server (PDF, Word, ODT, RTF).
If you use our plugin we would be very thankful if you fulfill this simple <a href="http://en.docxpresso.com/documents/preview/346" title="Docxpresso online survey" rel="nofollow ugc">online survery</a>.
<h4>How to use it</h4>
NOTE: If you have updated to WP5.* or you are using the Gutenberg editor plugin you should also have a look at the Gutenberg – WP5 Block editor section of this page.
<ol>
<li>Create a standard document with the content that you want to insert in your Post or Page using your favourite Word Processor or Spreadsheet (MS Word, Libre Office or Open Office).</li>
<li>IMPORTANT: Save your document in .odt (or .ods format for spreadsheets) format. In MS Word choose OpenDocument (.odt) in your Save As dialogue (in Libre or Open Office is the default format). If you are working with Excel you may equivalently save it in Open Document Format (.ods in this case).</li>
<li>Create or edit a Post or Page in your WordPress interface.</li>
<li>Click the Insert Document button located over the text editor.</li>
<li>A standard WordPress media window will open. You may upload a new document with the required contents or use a previously uploaded document.</li>
<li>After choosing a file click on the Insert button.</li>
<li>A [docxpresso] shortcode will be included within your text editor. </li>
<li>You may then add or not any additional content to your post but do not try to modify by hand the contents of the Docxpresso shortcode unless you really know what you are doing.</li>
<li>You may insert as many documents as you wish in a single Post or Page.</li>
</ol>
NOTE: You may use also Docxpresso plugin in conjunction with other plugins that allow to retrieve documents from cloud storage repositories like Amazon S3.
Check this video tutorial where you will find a detailed example of all the above:
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/wu_pi8FOrUs?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
In case you want to make any of your tables sortable you also should:
<ol>
<li>Declare the first row of your table as a header row within your Office document</li>
<li>insert a “@” symbol as the first character in every column that you wish to be sortable</li>
<li>If you want to sort columns by numbers that do not follow the en-US standard, i.e. 3,576.45, you should modify the number format for sorting in your plugin options panel under the Settings section of your WordPress installation</li>
</ol>
You may check how to do it with the help of this video:
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/Zv7lw_EliA8?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
Since v2.1 you may also insert in your document a link to a yotube video, a Google form or a Google doc to render it in your WordPress post or page:
<ol>
<li>Go to youtube, Google forms or Google docs interfaces and copy the offered share link</li>
<li>Always use, if available, the short URL format</li>
<li>Insert it into your office document as a link</li>
<li>By default the videos are fluid and the forms and docs take all available width space. But you can set custom width and height by adding, for example, ‘?width=600&height=400’ to the link URL</li>
</ol>
You may see an example in the following video:
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/dWl-RbFmcRE?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
<h4>Gutenberg – WP5 Block editor</h4>
Since v2.3 this plugin is compatible with the new “WP block editor”, also known as Gutenberg:
<ol>
<li>Click on the Docxpresso block that is available together with all the standard widget blocks within your block editor interface.</li>
<li>A new block will appear in the editor interface with a button inviting you to select a file.</li>
<li>Clicking on that button a standard WordPress media window will open. You may upload a new document with the required contents or use a previously uploaded document.</li>
<li>After clicking on the “Select button” a shortcode will be inserted in your editor.</li>
<li>As before, if you wish, you may insert multiple documents with Docxpresso in the same page or post and combine them with all other available blocks.</li>
</ol>
NOTE: With this new editor you need to save the edition before being able to visualize the uploaded document in the preview page.
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/q4pflMSiNsg?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
If you prefer to use the “Classical editor” in your WP5 installation you may proceed as described in the previous section.
<h3>Licensing</h3>
This work is licensed under GPLv2 or later.
This plugin comes bundled with the D3 and C3 JavaScript libraries for chart rendering, the webui-popover library for comment rendering and the MathJax library for rendering of math equations in a web browser. D3 (http://d3js.org) is distributed under the BSD license, MathJax (https://www.mathjax.org/) and dropcap.js (https://github.com/adobe-webplatform/dropcap.js) under the Apache license v2.0 , C3 (http://c3js.org/) and webui-popover (https://github.com/sandywalker/webui-popover) are distributed under the MIT license .

Docxpresso

"Copy and Paste" from MS Word, Excel, Libre Office or Open Office.

DB Sync for Microsoft Excel vs Docxpresso