Office for Mac Issues

How to Insert an Excel Spreadsheet into OneNote for Mac

Phi Hung Vo Oct 20, 2026 870 views

Question details

The user needs to insert formatted data from an Excel workbook into a OneNote page on a Mac device.

How to Insert an Excel Spreadsheet into OneNote for Mac

Product: Microsoft Excel and OneNote
Device & OS: Mac
Scenario: Transferring structured spreadsheet data into a digital notebook for organization or presentation.
Observed behavior: The goal is to have the formatted Excel cells accurately represented as a table within the OneNote notebook.

Before you start

Ensure both Microsoft Excel and OneNote for Mac are open, and that the workbook containing your data is saved so you can safely transfer your latest updates.

Solution 1Recommended

Copy and Paste Formatted Cells

The most direct way to bring Excel data into OneNote on a Mac is by manually copying the desired range of cells and pasting them.

While the Windows version of OneNote offers an 'Insert Spreadsheet' button, OneNote for Mac handles this differently. You must use the clipboard to transfer your data, which will automatically convert your spreadsheet layout into a native OneNote table.

Select the spreadsheet data

Open your workbook in Excel for Mac. Click and drag your mouse to highlight the specific range of formatted cells you want to transfer.

Copy the selected cells

Press 'Command + C' on your keyboard, or navigate to the 'Edit' menu at the top of the screen and select 'Copy'.

Navigate to OneNote

Switch to OneNote for Mac and open the specific notebook and page where you wish to insert the spreadsheet data.

Paste into the notebook

Click on the exact location on the OneNote page where the data should appear. Press 'Command + V' or select 'Edit' > 'Paste' to insert the formatted cells.

Formatting Retained: OneNote will automatically convert your pasted Excel cells into a native table, keeping most of your basic text and cell formatting intact.

Free Microsoft Office alternative

Experience Seamless Data Management with WPS Office for Mac

If you find Microsoft Office for Mac subscriptions costly or the standalone apps too disconnected, WPS Office offers a completely free, lightweight, and highly compatible alternative. Easily manage your spreadsheets, documents, and presentations in a single, intuitive tabbed interface.

1. Download the Mac version: Visit the official WPS Office website and download the free installer for macOS.
2. Install the application: Run the downloaded package and drag the WPS Office icon into your Applications folder.
3. Open existing files: Launch WPS Office and open your existing Microsoft Excel (.xlsx) files directly without losing any formatting or data.

Completely free and lightweight office suite optimized for Mac100% format compatibility with Microsoft Excel (.xlsx) and Word (.docx)Familiar, easy-to-use user interface requiring no learning curveSeamless data transfer and copy-pasting between spreadsheets and documents

microsoft office alternative - wps office

Frequently Asked Questions

Can I embed a fully functional Excel file in OneNote for Mac instead of pasting?

Unlike the Windows version of OneNote, OneNote for Mac does not currently support embedding a live, editable Excel spreadsheet directly into the page. You must copy and paste the cells, which converts them into a static OneNote table.

Why did my Excel formulas disappear when pasting into OneNote?

When you paste Excel cells into OneNote, the application only captures the visible text values and basic cell formatting. It does not carry over underlying mathematical formulas, turning your dynamic data into static text.

How do I update the data in OneNote if the original Excel file changes?

Because the pasted cells on a Mac are not dynamically linked to the original Excel file, any updates made in Excel will not reflect in OneNote. You will need to manually re-copy and re-paste the updated cells.

Office App Problems