Saturday, May 30, 2009

Bulk Edit Address Book Contacts

The first major step is to export the contacts you want to change. We are going edit directly the .vcf file which is used to store all of the address book data. Select all of the contacts you want to change, either the group of contacts or individually using the command key and click on each one. Then drag these contacts onto the desktop. Your Mac will work its magic and create one big .vcf file (which is actually all of your contacts as one file). This file in essence if a big text file which we can change.



The next step is to right click on the file and select “Open With” select your favourite text editor. TextEdit will do. Inside the file you will see lots of text that looks like a mess. The next step is to simply do a search and replace. Most items will be separated by a semi-colon ( ; ) so bare this in mind if you are changing multi line addresses. If you do a search and replace I recommend going through the items one at a time. Hitting change all could change things you don’t want to.

The final step is to save and drag the vcf file back into Address Book. It will ask if you want to review the differences, hit Import and it will override all of the files.

1 comment:

  1. Unfortunately this does not work for the change I want to make. It is possible to change existing data but I want to insert Work addresses for a set of contacts that do not have one, or else it is incorrect. The VCF file only contains existing contacts. I have over 300 records without a mailing address. I can export them and make changes in a spreadsheet but I cannot import them because it refuses to let me change the fields in question. Very frustrating.

    ReplyDelete