Extract address book from iPhone backup, convert AddressBook.sqlitedb to CSV for import to contacts free

This solution is for extracting from a backup on your mac. there are other option out there if you are trying to extract from a “live” iPhone or using a PC but i wanted to share a process that worked for me. No need to pay $30 or $99 for an app you only need to use for a few minutes.

1. start by using this free tool to extract AddressBook.sqlitedb from the backups stored on your mac: iPhone Backup Extractor from supercrazyawesome.

you will want to extract the last item on the list called “iOS Files” – it might take a while to download all those item.  open the iOS Files folder and  you will find a folder called “AddressBook” (it might be in the Library folder). that is the folder that contains AddressBook.sqlitedb

2. Open AddressBook database:

There are many paid options out there but here’s a free one: Open Firefox and install the SQLite Manager add-on for Firefox, restart firefox. Goto Web Developer->SQLite Manager. On SQLite Manager window click the open icon and selected AddressBook.sqlitedb.

3a. Open the Execute SQL tab and execute the following query

select ABPerson.prefix, ABPerson.first,ABPerson.last, ABMultiValue.value from ABPerson,ABMultiValue where ABMultiValue.record_id=ABPerson.ROWID

3b. if you want to get more details (notes, birthday +) use the following query

select ABPerson.prefix,ABPerson.suffix, ABPerson.first,ABPerson.middle,ABPerson.last, ABMultiValue.value, ABPerson.note, ABPerson.nickname, ABPerson.organization, ABPerson.department, ABPerson.jobtitle, ABPerson.birthday from ABPerson,ABMultiValue where ABMultiValue.record_id=ABPerson.ROWID

4. Hit the Actions button and choose Save Result(CSV) to file

now you can import that CSV into the contacts app using the ‘import’ function. it even has a ‘look for duplicates’ option that can help if anything went wrong in this process.

via: http://yogeshd.blog.com/2011/04/10/v…sqlitedb-file/


4 thoughts on “Extract address book from iPhone backup, convert AddressBook.sqlitedb to CSV for import to contacts free

  1. Arsalan October 27, 2013 / 4:57 pm

    Thank you very much sir, i have been going around the internet searching for a solution and this has finally worked.

  2. iphone4@gmail.com January 27, 2014 / 8:35 am

    You’re the man! Thanks.

  3. jaruwat September 9, 2014 / 4:26 am

    Thank you

  4. Apache December 23, 2015 / 4:49 pm

    Best way ever….

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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