Power Query Problems

How to Connect OneNote to Excel Using Power Automate

Phi Hung Vo Oct 9, 2026 869 views

Question details

The user wants to extract or connect data from OneNote into Excel using Power Query or an automated workflow.

How to Connect OneNote to Excel Using Power Query or Automation

Product: Microsoft Excel, OneNote
Device & OS: not provided
Scenario: Attempting to build automated workflows or reliable reports in Excel using notes, tables, or unstructured data originally captured in OneNote.
Observed behavior: Excel Power Query does not offer a native built-in connector for OneNote, making direct data extraction impossible without third-party services or workarounds.

Before you start

Before setting up an automation workflow, ensure you have an active Microsoft 365 subscription with access to Power Automate, and verify that your OneNote notebooks are stored on OneDrive or SharePoint so they can be accessed online.

Solution 1Recommended

Use Microsoft Power Automate to Extract OneNote Data to Excel

Since Power Query lacks a direct connector, Power Automate is the most accessible Microsoft 365 workaround for moving data from OneNote to Excel.

Power Automate can act as a bridge between the two applications. By creating a flow, you can monitor OneNote for specific updates or pull data on a schedule, parse it, and write it directly into an Excel table hosted on OneDrive or SharePoint.

Create a New Flow

Log in to Microsoft Power Automate online. Click on 'Create' from the left sidebar and choose either an 'Automated cloud flow' (to trigger on a specific event) or a 'Scheduled cloud flow' (to run at regular intervals).

Set Up the OneNote Trigger or Action

In the flow builder, search for the 'OneNote (Business)' connector. Depending on your needs, select an action like 'Get page content' to extract the HTML data from a specific OneNote page.

Parse the Extracted Data

Because OneNote stores data in HTML format, add a 'HTML to text' action or use data parsing expressions in Power Automate to extract the specific text or table values you need.

Add Data to Excel

Search for the 'Excel Online (Business)' connector and select the 'Add a row into a table' action. Choose the SharePoint site or OneDrive folder where your target Excel file is saved, select the table, and map your parsed OneNote data to the corresponding Excel columns.

Use Microsoft Power Automate to Extract OneNote Data to Excel

Excel Formatting Requirement: The destination Excel file must contain a formatted Table (Insert > Table) for Power Automate to recognize where to insert the new rows.

Solution 2

Store Structured Data Directly in Excel or SharePoint

The best practice for data management is to bypass the connection issue entirely by keeping structured data natively in robust databases rather than a note-taking app.

Solution 3

Connect via Microsoft Graph API and Power Query

For advanced users and developers, the Microsoft Graph API can retrieve OneNote page data which can then be queried by Excel.

Free Microsoft Office alternative

Looking for a Lightweight, Reliable Office Alternative?

Navigating complex integrations like Power Query, APIs, and Power Automate in Microsoft Office can be overwhelming. If you prefer a simpler, lightweight suite with powerful spreadsheet capabilities and an intuitive interface, try WPS Office.

1. Download the Installer: Visit the official WPS Office website and download the free installer for your specific operating system (Windows, Mac, or Linux).
2. Install WPS Office: Run the downloaded file and follow the simple on-screen prompts to complete the installation in minutes.
3. Open Your Existing Spreadsheets: Launch WPS Spreadsheets. You can instantly open, edit, and save your existing Microsoft Excel documents without losing formatting or formula calculations.

Free to use with a familiar, easy-to-learn interfaceHighly compatible with Microsoft Excel formats, ensuring seamless handling of .xlsx dataLightweight design ensures fast loading and smooth performance on any deviceAll-in-one suite combining documents, spreadsheets, and presentations in a single tabbed window

microsoft office alternative - wps office

Frequently Asked Questions

Can I use Power Query to get data directly from OneNote?

No, Excel's Power Query does not currently feature a native OneNote connector. You must rely on intermediary tools like Power Automate or the Microsoft Graph API to extract the data first.

How do I export a OneNote table to Excel manually?

For one-off tasks, manual copying is the fastest method. Simply highlight the entire table in OneNote, press Ctrl+C to copy, click on a cell in your Excel worksheet, and press Ctrl+V to paste the table.

Can I link an Excel spreadsheet inside OneNote instead?

Yes. In OneNote for Windows, you can go to the Insert tab, click on 'Spreadsheet', and choose 'Existing Excel Spreadsheet'. This embeds the file and allows you to view dynamic previews of the tables and charts directly within your notes.

Does Power Automate require a premium license for OneNote integrations?

No, the standard OneNote (Business) and Excel Online (Business) connectors are usually included with most standard Microsoft 365 business or enterprise subscriptions and do not typically require a standalone premium Power Automate license.

Excel & Data Problems