macOS 10.9 and later
AddressBookAid is an application for editing AddressBook Database on your Mac which is created by Apple Contacts.
You can edit the AddressBook by this AddressBook Aid directly through the Table View. It has a lot of editing capabilites such as column sort and Find&Replace function and so on.
And this application doesn't communicate with outside servers using the Internet. The Contacts data is only used inside of the app and never be sent to any servers.
Your contacts are protected in your system.
When AddressBook Aid is launched at first time, an alert for enabling access to your contact will be shown. Please allow AddressBook Aid to access your contacts, otherwise AddressBook Aid doesn't work.
AddressBook Aid shows the AddressBook in the table view. You can select the data type of each column such as Phone, Email, Address by the View Type and Columns menu. If the data has a label, the label is shown together with the data, and you can change both label and value at the table view cell during editing.
To edit the data, you need to click the edit button. Then the red line is shown under the title bar to show it is editing mode. And you need to double click the cell to change the value too.
The detail is here.
Each column in the table has a sort button. It will help you finding a duplicate data easily.
The Sort Options menu is for sorting first/lastName in Name Column and ZIP/State/... in Address Column.
When multiple address items such as a "ZIP" and "State" are selected by the Items menu, both column have the same label. But those are connected with each other. For example when you change the label of ZIP, then the label of State will be changed.
And AddressBook Aid uses TextFinder for Find&Replace which is introduced in OSX 10.7. You can find a word by name and by other categories with various options including a pattern, and replace it.
Please note that the way of finding a string in the address is changed from AddressBook Aid 2.5.2. Before 2.5.2 the whole string in the address is used to "find", but now each item in the address is used to "find" a string. For example when State and City are "CA" and "Cupertino", you can not find "Cupertino, CA". However you can replace the string "Cupertino" or "CA". Before 2.5.2 the Address panel is shown when you click the "Replace" button in the Find&Replace bar.
When you select the "Show Find Panel" menu in the edit menu or type Cmd+Shift+F as a short cut, following Find Panel will be shown.
In this panel, the search is performed by narrowing down the items selected by the data type and label. Matching items are listed in the table with their names.
Click the Replace button to replace the orange highlighted text with the string in the Replace field.
Click the "Replace All" button to replace the orange and blue highlighted text.
These operations can be undone by clicking "Undo" in the edit menu.
Also click the "Edit / Lock" button at the top right of the panel to enter edit mode (the button name will be Lock), then double-click a cell in the "Value" column to directly rewrite the value in that cell. This operation can be undoable too.
You can sort the table by each item by clicking the header of the table column.
When you select the "Regex" in the search mode menu, the regex expression is used to find a word. Please refer to the detail of the regex expression at "WiKi Regex expression".
The following example is that the expression, "^.[op]" is used to look for the word which starts with any charcter and the second is "o" or "p".
The compare panel is for comparing arbitral two contacts in the vertical table.
In the edit mode, you can change the value and move/copy between contacts by drag&drop.
In order to copy the value, dragging value with holding option key.
When the cell in the Name column is dobule-clicked, the Contact Info panel is shown as popover. It shows whole items in the selected contact vertically. The popover is closed automatically when you click the outside of it. However when you drag the outer edge of the popoover, it turns to the normal panel. So it will stay in the desktop until you close it. And you can open the other Contact Info popover and even open the multiple Contact Info panels at the same time. This will bring you the other way of comparing and editing contacts. Also you can copy any items by drag and drop between the Contact Info panels or the main window.
When you double-click the address cell, the address list panel will open. The plus button in the lower-left corner is for adding a new address value.
Selecting the Country Code menu enables State pulldown in some countries. You can enter the State name in the State Field by selecting State pulldown.
You can add State pulldown to any country by placing the AddressFormat.json file under the vCard Editor folder in iCloud Drive.
Here is the sample of AddressFormat.json.
You can set the same label or value in the selected cells at once.
Select multiple rows, then change the label of one of the cell, or the value by double clicking the value. An alert will be shown for making sure the operation. When you select OK, the values of selected cells in the same column will be changed to what you enter.
You can do the same thing via the replace menu of the context menu too.
Please note that the change can be undo by the "Undo" menu in the Edit menu.
When you control-click the cell, the context menu will be shown as below. Some cells have a action such as opening a mail message, a map which is depending on the type of the cell.
When you ctrl+click on a cell in editing mode, the context menu of cells will show some editing menus.
As the menu says, it is for replacing/appending/deleting text. You can edit multiple cells at once, when multiple rows are selected.
AddressBook Aid can import/export a vCard and CSV file.
After select a file in the open panel, the import panel will be shown to show the contact information in the file. You can select contacts to import from it through the panel.
The detail is here.
AddressBook Aid can show QRCode of the selected contact with various formats, and you can Copy&Paste the image to other documents.
You can drag and drop contacts between AddressBook Aid and Apple Contact or Apple Mail, and also between the Contact Info Panels.
Please note that you need to click the Edit button in the toolbar in order to unlock the document before you drop contacts from Apple Contacts.
When Groups are visible, Drag&Drop is the way of adding a member to the group.
Please see here about adding/deleting a group
Selecting the "Custom label" in the Navigator menu, the "Custom Label Panel" will open. It is for adding and changin a custom label for each item such as Email, Phone, Address.
Click the plus button is for adding a new label, and click the minus butotn is for deleting the selected label. And dobule-click the label in the table is for changing the label. And the changing refrects to the AddressBook, can't be undone.
You can change font and size in the row of Table.
When you select the "Copy" in the Edit menu, the items of the selected row in the table is copied to the paste buffer in text format. The text is a collection of strings in which the values for each column and separated by tabs. You can paste it into Numbers or Excel as it is. When you select the "Copy as CSV", the strings in the text are separated by commas. And the "Copy as vCard" menu is for copying the contact of selected row as vCard format.
Select a contact and then select “Print” from the File menu. You can select multiple contacts by cmd-click.
When you select the "AddressBook Aid" menu in the print dialog, the configuration pane will be shown for selecting a value to print.
vCard Editor works in Mac OS X 10.7 and later.
How to Install the trial version:
Double click on the zip file that you downloaded, then the vCardEditor-Trial.app is created.
You can just delete this software from the installed folder in order to uninstall this software.