5-23 2018

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 another text list.

I am frequently being asked: “How can I automatically create pages in a OneNote notebook based on a name list in an Excel spreadsheet (or in a Word 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 clipboard.
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.

 

(Clip content in German. But you should get the idea. The command with the red frame is “Link to pages” in English versions)

That’s all. Now two things have happened: The current notebook and section now contain 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.

Check Also

Reduce Storage Size of OneNote Notebooks

Onenote notebooks take up to four or five times the space of their actual content …

Leave a comment