Data Import & Export

How to Connect a OneNote Table to Excel for Automatic Updates

Maira Mehtab Sep 30, 2026 871 views

Question details

The user wants to establish a live data connection between a shared OneNote table and an Excel spreadsheet to enable automatic updates using the 'Refresh All' feature.

How to Connect a OneNote Table to Excel for Automatic Updates

Product: Microsoft Excel and OneNote
Device & OS: not provided
Scenario: Attempting to import and automatically sync data from a shared OneNote notebook table into an Excel database.
Observed behavior: Standard Web and SharePoint data connection methods fail to import the OneNote table data as expected, preventing automatic refreshing.

Before you start

Check if your OneNote table contains highly structured data, as you may need to export it to a more database-friendly format like CSV or maintain it directly in a spreadsheet to achieve automated syncing.

Solution 1Recommended

Understand the Limitation and Submit a Feature Request

Currently, Microsoft Office does not support a direct, built-in data connection between OneNote tables and Excel for automatic refreshing.

Because OneNote is not structured as a relational database, standard 'Get Data' (Power Query) connections from Web or SharePoint cannot parse OneNote tables as live data sources.

Open Excel or OneNote

Launch either your Excel spreadsheet or the OneNote application where your data is stored.

Navigate to the Help tab

Click on the 'Help' tab located on the top ribbon menu of the application.

Submit Feedback

Select 'Feedback' to inform Microsoft about your need for a live OneNote-to-Excel data connection feature so they can track this request for future updates.

Understand the Limitation and Submit a Feature Request

Alternative approach: Consider maintaining your primary data in an Excel workbook first, then embedding or linking that Excel file inside OneNote to keep everything synchronized.

Solution 2

Manually Copy and Paste Data from OneNote to Excel

Since automatic refresh isn't available, you must manually transfer the table data when significant updates occur.

Free Microsoft Office alternative

Manage Your Spreadsheets Efficiently with WPS Office

While direct syncing from note-taking apps can be restrictive in traditional Office suites, WPS Office offers a powerful, lightweight, and completely free alternative for all your spreadsheet and data management needs. Enjoy seamless compatibility with Microsoft formats without the heavy subscription fees.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the application: Run the installer and follow the simple on-screen instructions to set up WPS Office on your device.
3. Open and edit files seamlessly: Launch WPS Spreadsheets and directly open your existing .xlsx or .csv files to continue managing your data without formatting loss.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) and CSV data importsAdvanced data filtering, sorting, and pivot table capabilities for heavy data managementLightweight software that installs quickly and runs smoothly on older devicesFree to use with a familiar, easy-to-navigate tabbed user interface

microsoft office alternative - wps office

Frequently Asked Questions

Can Power Query connect to a OneNote notebook?

No, Power Query does not currently have a native connector for OneNote notebooks. OneNote files use a proprietary structure that cannot be directly parsed as web tables or SharePoint lists by Excel's 'Get Data' feature.

Is there any third-party tool to sync OneNote tables with Excel?

While direct native syncing isn't possible, some automation platforms like Power Automate or Zapier can trigger actions based on new OneNote pages. However, they struggle to dynamically parse and update specific cell data within an existing OneNote table.

What is the best way to display an Excel table in OneNote instead?

The most reliable method is to reverse the process: create and maintain your data in Excel, then insert the Excel spreadsheet into OneNote by going to Insert > Spreadsheet > Existing Excel Spreadsheet. This allows you to edit the file directly and keep the data in sync.

Excel & Data Problems