Others

How to Parse OneNote Bullet Points into Excel with Power Automate

Steve K Sep 30, 2026 869 views

Question details

The user wants to extract structured bullet points from a OneNote notebook stored on SharePoint and parse them into an Excel Online table using Power Automate.

How to Parse OneNote Bullet Points into Excel using Power Automate

Product: Power Automate / Excel Online
Device & OS: not provided
Scenario: Automating the transfer of project details (Project Name, Developers, Project Notes) from OneNote bullet points into an organized Excel spreadsheet.
Observed behavior: The goal is to automatically detect OneNote page changes, extract the relevant content, parse the bullet structure, and add or update rows in an Excel table.

Before you start

Ensure your OneNote notebook is hosted on SharePoint or OneDrive for Business, and verify that your target Excel Online workbook contains a pre-formatted Table with headers for Project Name, Developers, and Project Notes.

Solution 1Recommended

Build a Power Automate Flow to Parse OneNote Content

Create an automated cloud flow that triggers upon OneNote modifications, retrieves the page HTML, strips formatting, and maps the specific bullet points to your Excel columns.

Power Automate handles OneNote content in HTML format. To map this data to Excel, you will need to retrieve the page content, convert the HTML to plain text, and use string manipulation functions (like split) to isolate the data for each column.

Create the Flow Trigger

Log into Power Automate and create an Automated Cloud Flow. Search for and select the 'When a page in OneNote is modified' trigger, then point it to your SharePoint notebook.

Retrieve Page Content

Add a new action called 'Get page content' (OneNote Business). Use the Page ID dynamic content from your trigger to fetch the latest details of the modified page.

Parse the Bullet Points

Add an 'Html to text' action to strip the rich formatting from the OneNote content. Then, use a 'Compose' action with the split() expression to isolate the specific bullet points containing your project details.

Add Data to Excel

Add the 'Add a row into a table' action from the Excel Online (Business) connector. Select your SharePoint site, Document Library, File, and Table. Map your isolated variables to the corresponding Project Name, Developers, and Project Notes columns.

Test the Automation

Save your flow and click 'Test'. Go to your OneNote notebook, update the bullet points, and check your Excel table to verify the new row has been added correctly.

Build a Power Automate Flow to Parse OneNote Content

Advanced Parsing Help: Since string manipulation and HTML parsing can be complex depending on your exact OneNote structure, consider visiting the official Power Automate Community forums for specialized expression formulas.

Free Microsoft Office alternative

View and Edit Your Exported Excel Data Easily with WPS Office

While Power Automate workflows are tied to the Microsoft ecosystem, you can seamlessly open, manage, and analyze your generated Excel spreadsheets using WPS Office. It provides a lightweight, highly compatible, and free alternative for all your spreadsheet tasks.

1. Download WPS Office: Install WPS Office for free on your PC, Mac, or mobile device.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open the .xlsx file that Power Automate updated.
3. Analyze the Data: Use built-in filters, pivot tables, and formatting tools to review your parsed project data.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight and fast, ideal for managing large exported data tablesFamiliar tabbed interface makes transitioning seamlessBuilt-in advanced data analysis and visualization tools

microsoft office alternative - wps office

Frequently Asked Questions

Can I extract data from a locally stored OneNote notebook using Power Automate?

No, Power Automate requires your OneNote notebook to be hosted on a cloud service like SharePoint or OneDrive for Business in order to securely authenticate, detect changes, and extract content.

Why is my Excel Online connector failing to find the target columns?

Ensure that the data range in your Excel file is formatted specifically as a Table (Insert > Table). Power Automate cannot add rows to standard worksheet cells without a defined Table structure in the workbook.

Are there alternative ways to export OneNote to Excel without Power Automate?

Yes. You can manually copy the bulleted list from OneNote, paste it into an Excel worksheet, and use the 'Text to Columns' tool (found under the Data tab) to separate your structured bullet points into distinct columns.

Office Quick Solutions