OneNote Gem Add-Ins

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.

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.

5. Finally, click “Start” button to start export.

 

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.

 

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.