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: