Skip to main content
  Saturday, August 29, 2026
  1 Replies
  12 Visits
  Subscribe
I currently have a client who uses a Google Sheet to update a table on their website using the WP plugin Wpdatatable.
This works perfectly, but they would like to use Microsoft Excel Sheet instead. Before we go ahead and change, please can you confirm all the following:

OPERATION:
WP Table manager operates in a similar manner to the above. The Excel file lives in the client’s Microsoft 365/OneDrive account. When they update it, the website table updates automatically.

This is my understanding:

Step-by-Step: What Needs to Happen

Step 1 — Purchase WP Table Manager
One-time plugin cost: $49 USD (unlimited sites, 1 year support and updates, no recurring fee). This is from JoomUnited and is the only WordPress table plugin with confirmed, built-in Office 365/OneDrive live sync.

Step 2 — Confirm the Excel file is in OneDrive/SharePoint
The file must live in their Microsoft 365 OneDrive (not a local computer). If it's already auto-saving to OneDrive as part of their internal workflow, it's already there.

Step 3 — Set the file sharing to allow read access via link
In OneDrive, generate a shareable link for the specific Excel file — set to "anyone with the link can view" (read-only). This is what the plugin uses to pull data. No login required for the website to read it.

Step 4 — Install and configure WP Table Manager on the WordPress site
Install the plugin, create a new table, and use the Import & Sync > OneDrive Excel option. Paste the OneDrive share link, fetch the data, and enable automatic synchronisation.

Step 5 — Style the table and replace the existing wpDataTables shortcode
The existing table on the Resources page will need to be recreated in WP Table Manager, styled to match, and the shortcode on the page swapped out.

Step 6 — Test and verify
Update a number in the Excel file and confirm it flows through to the website within the sync interval (typically a few minutes).

SECURITY:
There are no security issues with having a sheet connected to our subscription directly feeding the website? The Excel file is saved on the company’s group OneDrive (i.e. not on a local computer nor an individual's OneDrive).

This is my understanding:

The file is shared via a read-only link — the website can only pull data, never write to or alter the spreadsheet. The link gives access to that one file only, not the broader Microsoft 365 account. No credentials or tokens are stored in WordPress. This is actually more secure than a full OAuth connection, because there are no account credentials involved at all — just a public read link to a single file.

The only thing to be mindful of: make sure that spreadsheet contains only the data intended for the public website. If there are extra tabs or internal notes in the same file, those should be moved to a separate file.
A
1 week ago
Hi,

Thank you for the detailed breakdown!

You have a great understanding of the setup, and your security assessment is 100% correct (read-only access, no credentials stored in WordPress, and isolated file access).

However, we want to clarify one key point: this setup only imports data from OneDrive. It is not possible for the website table to automatically update when changes are made in OneDrive.
Whenever you edit the spreadsheet in OneDrive, a manual re-import/sync will need to be triggered in WordPress for the new data to show up on the website.

Please let us know if this import workflow works for you, and we’ll be happy to get started!

Best regards,
  • Page :
  • 1
There are no replies made for this post yet.