Extracting highlights & notes from iBooks (IPad or iPhone) via online tool

11 Jul

Note : Following tool is no longer available as I couldn’t pay for its Virtual server hosting. I would like to thank few generous users who donated for few months to keep it alive. Those who know codding can download and use code from GitHub.

Thanks again for using it guys.

please donate to support our server(where this tool is hosted) cost     

Hi guys if you use iBooks on Ipad or iphone than you also highlight some important text while reading ,and you wondered how good it can be to extract only highlighted part of that book which you want to revise in future …

I wondered same I would like to demonstrate a way to extract your all your highlighted text to a ebook (.epub)

so what we have

Software required

  1. Download DiskAId portable from Windows users Click here ( then jump to step 5 now),                                                                           MAC users please follow this link to download (
  2. Once DiskAid set up is done, Connect your iPhone or iPad with Pc/Mac and open DiskAid.
  3. Open DiskAId ->; Preferences from menu-bar
  4. Go on Advanced Tab and check option Display All Apps.
  5. Expand Apps in left Navigation pane.
  6. Select iBooks and expand Documents->;BkLibrary_database , select iBooks_v10252011_2152.sqlite and drag and drop to Desktop
  7. Select Documents->;storeFiles and select AEAnnotation_v10312011_1727_local.sqlite and drang and drop to Desktop
  8. Then go and open   extract tool by clicking here
  9. choose both files ( AEAnnotation_v10312011_1727_local.sqlite & iBooks_v10252011_2152.sqlite) from desktop and press Extract my highlights button
  10. Wait for movement and on next page you can see your highlights which you can copy to word file or you can click on link to download ebook of your highlights (.epub file) which you can put it back in ibooks on your ipad and iphone

….Enjoy summary of books you read ….let me know any feedbacks and ideas…


Posted by on July 11, 2012 in Gadgets, Solutions


55 responses to “Extracting highlights & notes from iBooks (IPad or iPhone) via online tool

  1. Zack

    May 12, 2012 at 11:35 pm

    The websites in step 9 do not work….

    • parthiv777

      May 13, 2012 at 1:18 pm

      Please use one with ip address , i have to fix website address

  2. anthonyroper

    May 28, 2012 at 8:24 pm

    Hi Parthiv777, Great work man. I posted this question on Quora today – I wonder if you have some ideas? :

    I use mindmaps to summarize book reviews and apply creative thinking around the book content.

    Increasingly I am reading epub eBooks on my Ipad2 and highlighting information/typing notes as I read instead of making physical notes.

    I want to be able to :

    Export my highlights/notes, in a structured way that links them to the headings/chapter sections of each book, in a format that can be summarised in a text doc and/or the template of a mindmap format.(e,g, Freemind, IthoughtsHD)

    Anyone know of an app or simple workaround that would work with iBooks, Stanza or any popular Ipad eBook reader?

    • parthiv777

      May 29, 2012 at 10:39 am

      well i don’t think so that such app would exist on ios
      ,as Apple don’t like other Apps to mess around with there apps(fetching data from ibooks .sqlite files) …except this kind of software made externally (like tool above) and used by manually feeding database files (.sqlite)…
      and about chapters i have to drill more in and get one more cached .sqlite file ..(they made it more complicated structure after iBooks .1.5)
      if you read book from start (ch 1 , ch 2 , ch 3 and so on) than i have sorted bookmarks according date and time….

  3. Mario

    July 12, 2012 at 1:31 am


    I follow all the steps and when I upload the two files to, after a few minutes, I get this error. Step 9

    Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

    Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.

    Notes: The current error page you are seeing can be replaced by a custom error page by modifying the “defaultRedirect” attribute of the application’s configuration tag to point to a custom error page URL.


    • parthiv777

      July 12, 2012 at 7:39 am

      I am not sure how u came across this error as i tried it myself and worked for me…
      have u tried it second time

  4. Matt

    July 20, 2012 at 5:35 pm is unavailable, is this temporary??

    • parthiv777

      July 21, 2012 at 12:07 pm

      its up again …..well its humble request please donate if you guys like and use my tool as i can’t keep it up for more time now as i have to pay 40$ per month for its virtual private hosting to godaddy…

      • Mario

        July 21, 2012 at 6:55 pm

        i still with the same problem:

        could you send files by mail for you to try your with your system.


        When upload files is 100% after two minutes tell me:

        Server Error in ‘/EEP’ Application.

        Runtime Error

        Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

        Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a “web.config” configuration file located in the root directory of the current web application. This tag should then have its “mode” attribute set to “Off”.

      • parthiv777

        July 21, 2012 at 7:59 pm

        Ok Mario i get it , i guess u r with older version of ibooks so , update it first then try once more , i tried this morning it worked for me

  5. Mario

    July 22, 2012 at 6:28 pm

    I use the April version ibook , is the last that is in iTunes. I tried with mac osx and windows with chrome and explorer and tell me the same. The files sizes are 115 Kb for iBooks_v10252011_2152.sqlite , and 4 MB for AEAnnotation_v10312011_1727_local.sqlite

    • parthiv777

      July 22, 2012 at 6:34 pm

      If u dont mind then send me ur files on i will test system with them

  6. Greg Waddell

    July 23, 2012 at 8:25 am

    Thank you. Worked like a charm!

  7. Michael

    August 19, 2012 at 9:46 pm

    Worked fabulously. Any chance you could turn it into a stand-alone application to run on Windows and charge a small fee for it?

    Many thanks for doing this!

    • parthiv777

      August 20, 2012 at 9:32 am

      thanks , i guess it can be done for sure ,but right now i am out of time as running around between uni and job …will think about it in future…

  8. Rick

    September 4, 2012 at 12:53 pm

    a fantastic guide and tool! Many thanks

    • parthiv777

      October 2, 2012 at 9:10 am

      thanks Rick…

  9. TS

    October 1, 2012 at 10:28 pm

    Hi Parth, does this work with .iBooks files?

    • parthiv777

      October 2, 2012 at 9:15 am

      I afraid it doesn’t work with ibooks file……… except ibooks file’s highlights are saved in same .sqlite database as other epub ebooks ….

  10. brian fox

    October 3, 2012 at 1:29 pm

    pretty impressive. Thanks.

  11. David Pimentel

    October 18, 2012 at 6:06 am

    “You have not specified a file.” Any guess?

    • parthiv777

      October 18, 2012 at 6:53 am

      Which file u r talking about ? Where it applies in above process?

      • David

        October 18, 2012 at 8:57 am

        Sorry. I get that error after selecting the two files and clicking on “Extract my Highlights”.

      • parthiv777

        October 18, 2012 at 9:00 am

        Can you send me screenshot of error on

      • parthiv777

        October 18, 2012 at 9:05 am

        r u checking “Terms and conditions” checkbox?

      • David

        October 18, 2012 at 9:10 am


      • parthiv777

        October 18, 2012 at 10:08 am

        i don’t know whats happening here as its working fine for my files
        if you don’t mind send me your sqllite files on my email id above…
        i will try to get u ur highlights and will also troubleshoot this tool…

      • David

        October 18, 2012 at 10:26 am

        It’s OK. I found another way to do it. Thanks anyway.

  12. John Smolenski

    October 22, 2012 at 4:05 am

    I am a scholar who is in the midst of replacing my paper library (1000+) books with e-books. I would be very interested in donating money to keep the website going, and *very* interested in buying a standalone app. If donating more helps, I’d be willing to do that!

  13. Alex

    January 18, 2013 at 8:36 am


  14. golf school phoenix arizona

    April 21, 2013 at 4:36 pm

    You made some really good points there. I looked
    on the internet for more info about the issue and found
    most people will go along with your views on this web site.

  15. nataliedwilson

    May 7, 2013 at 6:46 am

    Is DiskAid free? Shareware? Limited Use Trial? I see that I can download it, but there’s also information about buying a license.

    • parthiv777

      May 7, 2013 at 7:16 am

      Hi Natalie there are 2 versions of diskaid free and premium. I did put free version here on my site , so no need to buy it. If you want to use diskaid for copy things back on phone then u need full version.

  16. nataliedwilson

    May 7, 2013 at 7:54 am

    Ah, thank you for your reply and clarification! I think this will work perfectly for what I need.

  17. Heiko

    May 12, 2013 at 2:46 am

    … Do you think it works also with kindle highlights, silly question probanly … The kindle highlights are stored online on amazon servers & you can extract them with, but some books have restrictions – for example: after 30 highlights you can’t highlight anymore … So it would be nice to export kindle highlights directly from the app “database” … What Do you think?
    Heiko Idensen, @web2write

    • parthiv777

      May 12, 2013 at 8:36 am

      Hi my knowledge about kindle highlight is limited , now if u r saying that some kindle books restricts u to 30 highlights.
      I think that can be removed by killing its DRM try to search on this topic some free open source software will help u to do that.

  18. Refugio

    June 8, 2013 at 3:33 pm

    Hello, its nice paragraph about media print, we all be familiar with
    media is a enormous source of information.

  19. Eric

    July 3, 2013 at 12:46 pm

    Anything that can be done to keep this going? Can we donate money to cover the cost? What can be done to make you reconsider? This is such a great service and hate to see it go away.

    • parthiv777

      July 3, 2013 at 1:57 pm

      thanks Eric,
      for last 2 month i have not seen much usage ,and it needs Virtual private server from windows (doesn’t run on normal hosting account) which are expensive ,so i thought to shut it down.
      at this point my virtual server is deleted (in hosting account) ,so have to setup all over again.
      little donation will also help it live (i am happy to pay 50% from my pocket),
      if i get at least 7 comments in next 10 days ,saying they want it up and running (I am putting words on top of blog post to comment below) with some donations then I am happy to set it up again.
      otherwise are you familiar with IIS and ? (i can give you code to set it up at home would be bit tricky though)

      • Eric

        July 20, 2013 at 12:36 am

        parthiv777, know we didn’t get the response we were looking for but wondering if there’s something we can still work out? I would be willing to help support the expense to get this back up and running. Let me know what you need to restart this service. Thanks!

      • parthiv777

        July 22, 2013 at 9:46 am

        thanks a lot Eric for your support , if you guys can donate 15$ per month then I am happy to bare rest of expense…
        we can get it up running in august(1st week)….


    July 8, 2013 at 7:05 am

    This tool has been *invaluable* to my work and I would be happy to donate to bring it to life again. Many thanks!

  21. nataliedwilson

    July 16, 2013 at 4:59 am

    I do hope you will put this back up as it was valuable to me as an author to get notes from beta readders.

  22. Eric

    July 24, 2013 at 9:40 am

    Sure. What’s the best way to donate?

    • parthiv777

      July 24, 2013 at 1:39 pm

      hi Eric i have updated post , please find donate button on top of post …thanks

    • parthiv777

      August 2, 2013 at 3:37 pm

      hi Eric it’s up and running on…..
      thanks once again for your generous donation

      • eric

        August 3, 2013 at 10:44 am

        Thank you! Appreciate your willingness to reactivate. Hope others will continue to support as well. Take care!

  23. curlyandblonde

    August 21, 2013 at 6:02 pm

    Thank you very much man! If you’re not counting on making money out of it, why don’t you release it as open source?

    • parthiv777

      August 22, 2013 at 3:16 pm

      do you think doing so will help it, in further development ?

      • curlyandblonde

        December 9, 2013 at 1:38 am

        Mostly, I think it would free you of the responsibility to update it in the future, or pay for its hosting, while still keeping your work around. Also, don’t underestimate the effect of open-sourcing!

  24. Pratik

    August 6, 2014 at 3:05 am

    Step 8 website doesnt work anymore –
    Can you fix this?

    • parthiv777

      August 6, 2014 at 8:06 am

      As mentioned above, I needed financial support to run server where step 8 website resided. I couldn’t get enough support so I closed it


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: