Unfortunately, it’s not currently possible to use a file stored on OneDrive or SharePoint as a data source for wpDataTables via a direct URL.
As explained in our documentation: Creating wpDataTables from Excel
There are two supported methods for using CSV or Excel files as data sources:
You can upload your file directly to the WordPress Media Library.
The file must be hosted on the same domain as your WordPress website.
You can also link to a file hosted on another domain, as long as it meets the following conditions:
The file is publicly accessible (no login or authentication required)
The URL must end with the file name and its extension, such as:
https://example.com/files/data.xlsx
https://example.com/files/data.csv
URLs that end with query parameters (e.g.,
...?id=123
) or don’t include the file extension will not work.
Files stored on OneDrive or SharePoint often:
Require login/authentication
Use URLs that do not end in a direct file name with .csv
or .xlsx
Include redirects or session-based access tokens
Because of these limitations, they are not supported by wpDataTables at this time.
You’re welcome to submit a suggestion on our official Feature Request page:
Submit a Feature Request
The more votes a request receives, the more likely it is to be prioritized by our development team.
To stay up to date with new features, fixes, and announcements: