Import Kindle Highlights into OneNote

If you've been using your Kindle to highlight text for assigned class readings (PDFs) I've found a way to take highlights from the 'my clippings' and turn them into OneNote notes via Word.

First find your 'my clippings.txt' file in your kindle. Connect it via USB, open the drive, click on documents, scroll down till you find the file named my clippings. I like to copy a shortcut from it to my desktop.

Next

1. Highlight all entries from one source wanted from 'my clippings' (Make sure you only do one PDF/book at a time
2. paste into Word doc
3. Find and Replace, click More>>, enable wildcards
4. find what: ==========
    replace with: ^p
5. Find what: copy the exact title from the entry
    replace with: ^p
6. This next step is complicated, to remove the time stamps Find what: (\- Y)(*)(\PM) for entries made in the PM or (\- Y)(*)(\AM) for entries made in the AM, if mixed you will need to separate the PM and AM entries into separate docs and go through the process with each.
    Replace with: ^p
7. Find what: ^13{2,}
    Replace with: ^p

I also edit paragraph spacing and use the 'Sentence Case' hotkey (under the third button to the right of font size) to clean it up. Then you can paste into OneNote and add bullets if you like. Very Handy