Title: How to import tables from Microsoft Excel Online (Office 365) Author: Tobias Bäthge Published: January 26, 2024 Last modified: September 18, 2025 --- Importing table data from external spreadsheet sources # How to import tables from Microsoft Excel Online (Office 365) TablePress can import tables from a variety of popular spreadsheet applications. This includes XLSX files from Microsoft Excel, CSV (Character-Separated Values), ODS (OpenDocument Spreadsheet), HTML, and JSON files. In addition to uploading files from your local computer, it is also possible to import spreadsheets into your WordPress site by providing a URL (link address) to such a file. **This opens up the possibility to import a table from a [Microsoft Excel Online](https://excel.new/)( part of [Office 365](https://office.com/) and [SharePoint](https://sharepoint.com/)) table into TablePress.** (By the way: The [TablePress Max license plan](https://tablepress.org/pricing/) comes with the [Automatic Periodic Table Import feature](https://tablepress.org/modules/automatic-periodic-table-import/). This allows you to fully automate the table import process, saving you time and effort!) All that you need for this is a link address to the spreadsheet that directly returns an appropriate file, without any user interface or login screen. This can be done by publicly sharing the Excel Online worksheet and then using a generated (secret) URL for the import into TablePress. **Our beginner-friendly step-by-step tutorial will guide you through this process and show you how to find this URL for your Excel Online table.** ## Step 1: Open your Microsoft Excel Online Worksheet Go to the [Microsoft Office 365](https://office.com/) website and sign in to your Microsoft account, if you are not yet logged in. If you are using a corporate version of Excel Online, e.g. via SharePoint, log into that. Create a [new spreadsheet](https://excel.new/) or open an existing one that contains the table you want to share. ## Step 2: Share the Spreadsheet Click the “File” menu (1) in the top-left corner of the navigation bar. ![Opening the "File" menu in Microsoft Excel Online.](https://tablepress.org/wp- content/uploads/2024/01/microsoft-excel-share-menu-1.png) Opening the “File” menu in Microsoft Excel Online. Choose “Share” (1), and click “Share with People” (2). Alternatively, click on the“ Share” button in the top-right corner of the screen, if that’s shown. ![Opening the "Share with People" dialog in Microsoft Excel Online.](https://tablepress.org/ wp-content/uploads/2024/01/microsoft-excel-share-menu-2.png) Opening the “Share with People” dialog in Microsoft Excel Online. In the “Share” dialog, click the “Anyone with the link can edit” text (1) right below the big text field. ![The "Share" dialog in Microsoft Excel Online.](https://tablepress.org/wp-content/ uploads/2025/09/microsoft-excel-share-dialog-1.png) The “Share” dialog in Microsoft Excel Online. In the “Sharing settings”, click “Can edit” (1) right below “More settings” and choose the “Can view / Can’t make changes” option (2). Then, click the “Apply” button( 3). ![Changing the "Sharing settings" in Microsoft Excel Online.](https://tablepress.org/ wp-content/uploads/2025/09/microsoft-excel-share-dialog-2.png) Changing the “Sharing settings” in Microsoft Excel Online. ## Step 3: Obtaining the Sharing URL After configuring the sharing settings, click the “Copy link” button (1) at the bottom of the dialog. You will see the black “Link copied” notification and will then have the shortened Sharing link for the Microsoft Excel Online user interface in your computer’s clipboard. ![Copying the "View" link in Microsoft Excel Online.](https://tablepress.org/wp- content/uploads/2025/09/microsoft-excel-share-dialog-3.png) Copying the “View” link. This Sharing link needs one small addition to be converted into the proper URL for downloading the table as a file. The link normally looks like ```language-xml https://1drv.ms/x/c/{id}?e={authkey}Code language: HTML, XML (xml) ``` where `{id}` and `{authkey}` are long sequences of letters and numbers that internally identify your worksheet. (If you are using Excel Online as part of a corporate Microsoft SharePoint instance, you will have a URL in the scheme ```language-xml https://{company-id}.sharepoint.com/:x:/{some-long-id}?e={key}Code language: HTML, XML (xml) ``` instead, but the procedure will be the same.) To get the appropriate Sharing link for use with TablePress, simply **append `&download =1` to the end of this URL**, like ```language-xml https://1drv.ms/x/c/{id}?e={authkey}&download=1Code language: HTML, XML (xml) ``` for the normal URL, or like ```language-xml https://{company-id}.sharepoint.com/:x:/{some-long-id}?e={key}&download=1Code language: HTML, XML (xml) ``` for the SharePoint version. That’s it! You now have a link address that can be used for importing the Microsoft Excel Online table into TablePress! **A quick tip:** To check if a URL link is suitable, try opening it in a “private”/” incognito” browsing window again. If you are offered an `xlsx` file for download, without seeing a spreadsheet user interface or having to log in first, the URL should work for the import into TablePress. ## Step 4: Import the URL into TablePress Once you have the correct Sharing URL from Step 3, you can use that for importing the Microsoft Excel Online worksheet into TablePress. For that, go to the “Edit” screen of TablePress on your WordPress site. Choose “URL” as the “Import Source” and paste the URL into the “File URL” text field. After clicking the “Import” button, your Excel Online table will be imported into TablePress. You can then edit it as needed and show it on your site by embedding the “TablePress table” block (if you are using the block editor) or the corresponding Shortcode into a post or page. ![Importing a TablePress table from the generated Sharing URL of a Microsoft Excel Online worksheet.](https://tablepress.org/wp-content/uploads/2025/09/microsoft-excel- import-tablepress.png) Importing a TablePress table from the generated Sharing URL of a Microsoft Excel Online worksheet. Note that (just like any other file import in TablePress) this is a one-time import. There is no **automatic synchronization with changes in your Excel Online worksheet**! However, there is a great solution for that as well: **The [TablePress Max license plan](https://tablepress.org/pricing/) comes with the [Automatic Periodic Table Import feature](https://tablepress.org/modules/automatic-periodic-table-import/).** This module can periodically import your tables periodically (e.g. every minute, every hour, etc.). Not only does this help you save a lot of time by not having to repeat the import task manually, but it also allows other people to update tables on your website, e.g. by using a shared Excel Online worksheet for data editing. --- **By the way: This process also works with files uploaded to Microsoft OneDrive!** To open the Sharing dialog, just right-click on the file in OneDrive and find the“ Share” entry. Then, follow the steps above. Tutorials on how to create such a URL for other services like [Google Sheets](https://tablepress.org/tutorials/import-google-sheets/), [Google Drive](https://tablepress.org/tutorials/import-google-sheets/#google-drive), or [Dropbox](https://tablepress.org/tutorials/import-dropbox/) are available on the [Tutorials, Guides, and How-tos page](https://tablepress.org/tutorials/). **On this page** 1. [Step 1: Open your Microsoft Excel Online Worksheet](https://tablepress.org/tutorials/import-microsoft-excel-online/#step-1) 2. [Step 2: Share the Spreadsheet](https://tablepress.org/tutorials/import-microsoft-excel-online/#step-2) 3. [Step 3: Obtaining the Sharing URL](https://tablepress.org/tutorials/import-microsoft-excel-online/#step-3) 4. [Step 4: Import the URL into TablePress](https://tablepress.org/tutorials/import-microsoft-excel-online/#step-4)