Turning OneNote tables into Excel worksheets

OneNote on Windows Desktop offers the ability to convert tables you have created into Excel workbooks.  If you’re using OneNote to capture basic information for calculation or data analysis, this is a great way to make the leap from the quick capture structure of OneNote tables to something more functional with Excel.

How do I convert from a table to an Excel spreadsheet?

Luckily enough, this process is a very simple one. Just right click on your table and select Convert to Excel Spreadsheet from the quick menu. That’s all it takes. You can now edit the worksheet from within OneNote by clicking on the new Edit tab at the top of the sheet.  Updates and changes are saved in the copy of the worksheet stored in OneNote.

So what’s the catch?

This is a one way trip for your table. Once you’ve converted a OneNote table into a worksheet you can’t go back.  Based on that I make a copy of the table I’m going to convert first, convert the copy, make any changes and updates, and decide if I’m going to keep the Excel version.  It’s a little clunky, but it’s the fastest way to make sure you aren’t going to have to rebuild your table from scratch.