Create OneNote Pages from Excel List

Question: I have an Excel spreadsheet with 3000 names that I would like to create folders for on my shared network drive. We need to keep files and other information for these people and would like to have the names stored in folders by As, Bs, etc. . Is there an easy way to do that?

Answer: There may be a procedure to do that, but I think a more efficient way to keep track of names and subsequent information for them would be to create a OneNote2010 notebook on a shared network drive. This is a perfect project to show the powerful capabilities of OneNote.

Create sections of the OneNote notebook with the Letters of the Alphabet and then create pages for each student. Within these pages you can create subpages which can hold files, notes, images, recording, etc. You can create this in just a few minutes by Importing the list from Excel into Outlook 2010 Contacts, and then select the “A” contacts and click OneNote in the ribbon. This will send the Contact information to OneNote pages. Do this for each section. See more detailed steps below:

  1. In your Excel file, make sure your workbook contains only one worksheet with headings at the top. It is best to have headings Name and E-Mail for it to import correctly into Outlook.
  2. Name your data range in Excel and save the file in 2003 (.xls) format.
  3. Go to your Outlook contacts view and and right click on Contacts to create new folder – call it something like “Students”
  4. Click File > Open > Import > Import from another program or file.
  5. Verify that the names imported correctly into your Outlook Contacts.
  6. Create a OneNote Notebook on your shared network drive.
  7. Create sections for the letters of the Alphabet.
  8. Go back to your Outlook contacts and select the names you wish to place in the A section (using Shift or Ctrl to select the names) and click OneNote in the ribbon and place in the appropriate notebook section. Continue this for each section of names. You could also select all Contacts and click OneNote, sending all names at once. Then create new pages for each letter of the alphabet and indent the contact pages by dragging slightly to the right, creating subpages.
  9. You can now add notes, drawings, images, files, Outlook messages, appointments and even recordings into OneNote pages. You can also create lists or tags which you can search on.

Learn more about OneNote 2010 in our basics class coming up 4/22 from 1-3 p.m. which you can sign up for by going to . You can find several other tutorials and resources on OneNote at Microsoft, including:


Excel add-ins and online tools for charting

I wanted to share some excellent tools that I’ve recently learned about. One is a free statistical analysis add-in program for Excel. Greg McFadden from Internal Medicine shared his knowledge with us in a mini-session a couple of weeks ago. To use this add-in:

  1. Select Excel Options (available from the Office button in Excel 2007 or File menu in Excel 2010).
  2. Click Add-ins and select Go (toward bottom of add-ins window)
  3. Place a check on the Analysis ToolPak and click OK. You may get a prompt asking to install it, and you may need the installation disk (although I didn’t with Excel 2010).
  4. After it has been installed, the analysis features are available on the far right of the Data tab. Some of the analysis tools available are: anova, correlation, covariance, descriptive stats (wonderful), F-test, histogram, fourier analysis, regression and more.

This┬ásite recently came to my attention from Teri Hartman, from McGoogan Library. Here you will find described a number of on-line programs that can be used to create charts and graphs of all types, including drawing tools, mind mapping, flow charts, organizational charts, iPhone chart application and more! I haven’t tried any of them yet, but I can’t wait to try out the mind mapping tools!

Thanks Greg and Teri for sharing your great finds!