Data Import & Export

Convert OneNote Table Lines to Line Breaks in Excel Cells

Bushra Parveen Oct 10, 2026 870 views

Question details

The user needs to maintain OneNote table formatting when exporting to Excel, specifically keeping multi-line text within a single cell rather than splitting it across multiple rows.

How to Convert OneNote Table Lines into Line Breaks in Excel

Product: Microsoft Excel, Microsoft OneNote
Device & OS: not provided
Scenario: Exporting or copying a formatted table from OneNote into an Excel worksheet.
Observed behavior: When the OneNote table is pasted into Excel, each line of text is placed into a separate worksheet row instead of appearing as multiple lines separated by line breaks within a single cell.

Before you start

Before proceeding, note that OneNote and Excel use fundamentally different table structures. Direct copy-pasting will often result in formatting loss, so workarounds using embedded sheets or formulas are required.

Solution 1Recommended

Use an Embedded Excel Spreadsheet in OneNote

The most reliable way to maintain Excel formatting and native in-cell line breaks within OneNote is to create or insert an actual Excel spreadsheet object.

Since there is no direct format conversion that preserves the exact OneNote table structure upon export, managing your tabular data using Excel's native engine inside OneNote prevents the issue entirely.

Insert Spreadsheet

Open your OneNote notebook, navigate to the Insert tab on the top ribbon, and click on 'Spreadsheet'.

Choose Spreadsheet Type

Select 'New Excel Spreadsheet' to start from scratch or 'Existing Excel Spreadsheet' to import a file you have already created.

Edit with Line Breaks

Click the 'Edit' button on the spreadsheet placeholder in OneNote. This opens a native Excel window where you can type your data and use 'Alt + Enter' to create proper in-cell line breaks.

Save and Update

Save your changes and close the Excel window. The table in OneNote will automatically update and retain the correct line formatting.

Use an Embedded Excel Spreadsheet in OneNote

100% Formatting Preservation: Because this method uses Excel's actual application engine within OneNote, you will not lose any structural formatting when extracting or updating the data.

Solution 2

Combine Exported Rows Using Excel Formulas

If you have already copied the OneNote table and the lines are split into multiple rows in Excel, you can merge them back into a single cell with line-feed characters.

Efficient Data Management with WPS Office

Easily Combine Split Rows into Single Cells with WPS Spreadsheet

WPS Spreadsheet offers powerful text functions and an intuitive interface to easily fix messy exported data. Merge split rows back into formatted single cells effortlessly.

1. Open Your Data: Launch WPS Spreadsheet and open the document containing the pasted OneNote table.
2. Enter the Merge Formula: Click a blank cell and type =TEXTJOIN(CHAR(10), TRUE, [Select Your Cells]) to combine the split rows.
3. Enable Text Wrapping: Select the formula cell, go to the 'Home' tab on the ribbon, and click 'Wrap Text' to correctly display the multi-line format.

Fully compatible with Microsoft Excel (.xlsx) file formats.Easily apply TEXTJOIN, CONCATENATE, and Wrap Text features.Lightweight alternative with a familiar, user-friendly interface.Completely free to use for daily data processing and formatting tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why does pasting a OneNote table to Excel split the lines?

OneNote and Excel handle paragraph breaks differently in their underlying code. When you copy text with paragraph breaks from OneNote, Excel interprets those breaks as commands to start a new row rather than staying within the same cell.

How do I manually insert a line break in an Excel or WPS cell?

To manually insert a line break inside a single cell, double-click the cell to enter edit mode, place your text cursor where you want the break, and press Alt + Enter on your keyboard.

Can I export a OneNote table directly to a CSV file?

No, OneNote does not have a native feature to export tables directly to CSV. You must copy the table into a spreadsheet application like Excel or WPS Spreadsheet, clean up the formatting, and then save the file as a .csv format.

Excel & Data Problems