OneNote Gem Add-Ins

How to Export OneNote Pages to a CSV File?

OneNote's pages can be exported to a CSV file through OneNote Batch. It can be easily imported into the database.
 

Pages of OneNote

 
There is a OneNote notebook that want to export to a .csv file.


Pages of OneNote

Export OneNote Pages into a CSV File

 
In OneNote Batch:
  1. Click Export tab.
  2. Click “Export to CSV” feature.
  3. In the notebook tree on the left, check the notebook or section to be exported.
  4. Click "..." button to choose which folder to save onenote.csv, specify the folder because it is saved as a onenote.csv file and export the pictures in the notes.
The separator (the symbol used to split the column) is ","
The enclose (the symbol that encloses the string) is """
The escape (the symbol used to escape ") is ""”.
  1. Finally, click “Start” button to start export.
 
Export OneNote Pages into a CSV File

Exported onenote.csv and its Images

When OneNote Batch export succeeds, it generates:
  1. onenote.csv file
  2. Export pictures of each OneNote page according to the structure of the My Notebook tree. (Import back for convenience using OneNote Batch's Import CSV feature). "My Notebook" as a subfolder.
 
A record in the CSV contains the following fields:
  1. id: The ID of the page in OneNote
  2. datetime: The date and time the page was created
  3. title: The title of the page
  4. path: The path of the page in OneNote, Notebook\Section group\Section\Page
  5. link: An internal link to a OneNote page that takes you directly back to the page in OneNote.
  6. content: The body.
 
Exported onenote.csv and its Images

Open onenote.csv in Excel


Open onenote.csv in Excel


Import onenote.csv Back to OneNote

 
You can use the Import CSV function of the Import tab of the OneNote Batch to import onenote.csv back into OneNote.
If the "My Notebook" subfolder still exists, OneNote Batch will import the images back into OneNote.
 


Download OneNote Batch