Applies ToOneNote for Microsoft 365 OneNote 2024 OneNote 2021 OneNote 2016

Sometimes, to improve the look of a table on a page, you might format a table to resemble a simple spreadsheet. In OneNote 2016, you also have the option to convert it to a fully functioning Microsoft Excel spreadsheet.

  1. In OneNote, open the page that contains the table you want to convert.

  2. Activate the table by clicking inside any of its cells and reveal the hidden Table Tools tab.

  3. In the Table Tools tab, choose Convert to Excel Spreadsheet.

    Screenshot of the Convert to Excel Spreadsheet button in OneNote 2016.

OneNote converts the table to an Excel spreadsheet and inserts a icon on the page and an embedded dynamic preview of the file. When you change or update the spreadsheet, the preview on the notes page automatically updates.

If your data is already in a spreadsheet, you can add an Excel spreadsheet to your page.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.