Visitor
•
1 Message
My Cox phone "address book" on VoiceTools
VoiceTools (logging in on my desktop PC) has an "Address Book" in the top right corner. To be more accurate, it should be called a "phone book." Regardless, it ties in with Call History. I use it to add clarity to my Call History, such as adding a name when only a number appears, or tying a work phone and a cell phone to one person. I use this to identify and track business call activity.
My "address book" data could be useful to me for another project. Would there be a way for me to export it as .csv or .xlsx?

CurtB
Honored Contributor
•
2.1K Messages
2 months ago
Voice Tools doesn't provide an Address Book contacts export function. Copying data into Excel and formatting it isn't as easy as an export, but it's not hard. Option 1: Copy contacts one letter at a time A to Z. This allows more than the nine contacts maximum that can be copied from the multi-line grid (and is easier to manage). Option 2: Mark every contact as a favorite, then click the "Favorites" link on the top row. This displays a single-spaced list of all contacts flagged as favorites. That would now be ALL your contacts. You can then select all contacts at once to copy and "Paste Special" into the Excel worksheet at cell "B2".
When all contacts have been copied into column "B":
=IF(LEFT($B3,4)<>"Name","",PROPER(RIGHT($B3,LEN($B3)-5)))
=IF(LEFT($B4,14)<>"Phone Number: ","",IF(RIGHT($B4,6)="Office",MID($B4,16, LEN($B4)- 21),MID($B4,16,LEN($B4)-19)))
=IF(RIGHT($B4,6)="Office",RIGHT($B4,6),IF(RIGHT($B4,4)="Cell",RIGHT($B4,4),IF(RIGHT($B4,4)="Home",RIGHT($B4,4),"")))
Note: If a contact has more than one phone number, it will have a small down arrow to the right of the type in the webpage list. Multiple phone numbers are only visible using webpage functionality to display the additional numbers and are therefore not available for copying. Those additional numbers would have to be processed manually.
(edited)
1
0