Convert a table in OneNote 2016 to an Excel spreadsheet

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.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×