HelloARI's Blog

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

Posted on: May 30, 2013

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/

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

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

You’re the man! Thanks.

Thank you

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Twitter Updates

Follow HelloARI's Blog on WordPress.com

Enter your email address to follow this blog and receive notifications of new posts by email.

Read Me Differently

A Film by Sarah Entine

San Francisco Art Houses

restoring the city's creative culture

Jimmy In Saigon: A Film by Peter McDowell

One can do a lot of living in a short time

Jerry Kurtz

Searching the world for the truth


Oxygen for your company

Dr. Joshua Coleman

Speaker, Author & Psychologist

Ari Salomon: WordPress Expert

Web Design and Development

Rainbow Grocery

Organic Grocery

Claire Mulkey Photography

San Francisco Wedding Photography and more

Michele R. Shields

Only the Spirit

No Nukes Action Committee

Info for/by people in the Bay Area who are against nuclear renaissance. カリフォルニア州ベイエリアで原子力ルネッサンスに反対する人々による、人々のための情報

American Licorice

We really love candy


San Francisco, CA


Get every new post delivered to your Inbox.

%d bloggers like this: