In OneNote 2013 / 2016 you can use the wiki link function to automatically create a whole swing of new pages from an Excel spreadsheet or other text list.
I am frequently being asked: „How can I automatically create pages in a OneNote notebook whose names are listed in an Excel spreadsheet (or Word file, or TXT file, or…)?
Using the Desktop-OneNote (i. e. OneNote 2010/2013/2016) this is quite simple:
First use the clipboard to transfer the list of names to any OneNote page in the notebook and section where the new pages are to be created. In the example below uses an Excel column is used as data source). In OneNote, each page name should be in a separate paragraph, i. e. all entries should end with a [Return] character. Of course, you may also type such a list in OneNote directly instead of pasting it from the clipborad.
In OneNote, select all entries in the list or those that are to become new pages with the respective title. Important: At least two entries must be marked!
Right-click on the selected list and choose Link to Pages from the context menu.
That’s all. Now two things have happened: The current notebook and section now contains a correspondingly large number of new, blank pages with the respective list entry as a title. In addition your original page list in OneNote has changed its appearance. All entries have become internal links to the respective pages. You may keep this list as a table of contents or simply delete the corresponding page.