After a few days of iPhone use, I can honestly say that I am even happier with it than I could have imagined. The first thing I had to do was figure out how to get all of my contacts off of my old phone and onto the iPhone. Previously I had service with Verizon and took advantage of their Backup Assistant to store all of my numbers for me. I did a quick google search and couldn’t find a good solution for performing the transfer from the Backup Assistant to my iPhone contact list. I was able to login to the Backup Assistant website but unfortunately I could not export the data. However, I was able to print the data, though that really wouldn’t help. So I came up with the following method to manually copy all of the data and get it in to the iPhone.

  1. Select Print Address Book from Backup Assistant website (popup window).
  2. Copy all rows.
  3. Open Excel and paste.
  4. Format in Excel:
    1. Copy and paste the data into another sheet, this should remove the pesky check marks in each row.
    2. Move phone numbers around into separate columns specified by type.
    3. Use find and replace to replace all instances of “Mobile”, “Work”, “Home”, etc. with blank text, leaving only numbers in each cell.
  5. Save the worksheet as a csv file.
  6. Open outlook and create a new sub directory under Contacts.
  7. Under File menu select Import and Export…
  8. Import from another program of file.
  9. Comma Separated Values (Windows).
  10. Browse to the file saved earlier.
  11. Select the sub directory created earlier.
  12. Click Map Custom Fields…
  13. Map Name to Name, Mobile to Mobile Phone, Home to Home Phone, etc.
  14. You can use the Next > button to see how your data will map.
  15. Click Finish.

From there you should be able to use the Outlook Contact syncing in iTunes to send your phone numbers to your iPhone. I think that was all of the steps. I didn’t think to write it all down until after I had successfully performed the sync. But then I realized that my work might actually help someone out. Leave any questions or comments below.

3 Responses to “Verizon Backup Assistant to iPhone Contacts”
  1. Aarti says:

    Good to know ed! I’m contemplating making the move from Verizon to AT&T to get an iPhone, but have to wait until December to do that. Not sure my current phone will hold out that long…

  2. Cyril Murph says:

    Because of this amazing article, I am adding your RSS to my Google Reader :)

  3. Anthia says:

    It can be done rather gently. This lesson still holds today.

Leave a Reply to Aarti