19. Februar 2018

Automatically create pages from a list of names

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.

This tip is based on OneNotes so-called wiki links. They are usually created manually by placing a term in square brackets in the OneNote editor, e. g.“[[new page name]]“. This also works with the Windows-10-App (UWP). Now might consider to place these double brackets around the list terms in Word or Excel, for example with search and replace or by a macro, and then copy them to OneNote. Don’t waste your time, it won’t work. The double brackets must be entered directly into the OneNote editor and even in the correct order. So first „[[„, then the name, then „]]“. If you type parentheses first and then the name in between won’t work. The OneNote-Editor interprets the parentheses directly during input, but not afterwards. So you can’t just import premade lists with parentheses.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht.