How can I organise my Gmail Contacts?

Lewis Lebentz December 21, 2012
Pinterest Stumbleupon Whatsapp

I have an iPod touch and a BlackBerry, and have my Contacts synced between them using Google Contacts. A while ago, I stupidly added all of my Facebook friends emails to my Contacts list, so I now have ~800 Contacts, mostly just names and emails.

I am getting a new BlackBerry soon, and would like to somehow only keep the contacts that have phone numbers on my phone, and possibly have all the emails in the same account, or backed up somewhere else that I can access them if I need them.

So how can I do this? I attempted it before, by exporting to CSV then just trying to delete every row that didn’t contain a number, but it was too hard to automate and would take too long to do manually. Someone please give me a solution!

Ads by Google

  1. Joel Thomas
    April 4, 2013 at 6:54 am

    http://lifehacker.com/5499575/the-complete-guide-to-fixing-google-contacts

    I came across this and it seems to suit your purpose

  2. ha14
    December 22, 2012 at 8:14 pm

    adding zero at the start of number
    http://www.mrexcel.com/forum/excel-questions/297466-adding-zero-start-number.html

    How to Insert 0 Before Any Number in Excel
    http://www.articlesbase.com/data-recovery-articles/how-to-insert-0-before-any-number-in-excel-339538.html

    How to add one digit "0" in the front of a number
    http://www.excelforum.com/excel-programming-vba-macros/488198-how-to-add-one-digit-0-in-the-front-of-a-number.html

    1.Highlight the column/array you want to style.
    2.Click ctrl + 1 or Format -> Format Cells.
    3.In the Number tab, choose Custom.
    4.Set the Custom formatting to 000#. (zero zero zero #)
    http://stackoverflow.com/questions/3992541/add-leading-zeroes-0s-to-existing-excel-values-to-certain-length

  3. Lewis Lebentz
    December 22, 2012 at 4:12 pm

    I exported to CSV, organised them to just have mobile numbers and names, but I cannot get it to have a 0 at the beginning of the numbers, so they are all just '745678914' or '123982302'. I have tried doing Find and Replace, and formatting the cells but can't work out how to add it, or even +44 instead. (I'm in the UK btw)

  4. Lewis Lebentz
    December 22, 2012 at 4:12 pm

    I exported to CSV, organised them to just have mobile numbers and names, but I cannot get it to have a 0 at the beginning of the numbers, so they are all just '745678914' or '123982302'. I have tried doing Find and Replace, and formatting the cells but can't work out how to add it, or even +44 instead. (I'm in the UK btw)

  5. Jose Paolo Gonzales Otico
    December 22, 2012 at 3:11 pm

    Create groups. Also make sure when you import them that you go through all your contacts, and see that it imported them right. Organization takes time to make sure it's all be done properly.

  6. Atman Shah
    December 22, 2012 at 11:39 am

    Simple create groups...

  7. Lisa Santika Onggrid
    December 21, 2012 at 1:47 pm

    If contacts that are truly important to you aren't that many, may I suggest you to purge the current contacts and input those who are important again?

  8. Nevzat Akkaya
    December 21, 2012 at 10:15 am

    Note : I just mistyped, you should sort by numers, not e-mail.

  9. Nevzat Akkaya
    December 21, 2012 at 10:11 am

    First export your Google Contacts as CSV, then open it in Excel or other spreadsheet program. Sort them using e-mail adress column and find the empty ones easily, delete those unwanted rows (lines). Save the CSV file. Now go to Google Contacts, either delete all the contacts or move them to another group, after that import your CSV file and voila, you're done.

  10. Douglas Mutay
    December 21, 2012 at 6:54 am

    In Blackberry App world you will be able to find a tons of apps that can automatically do the job for you. Try to make a search using contact and you will have list of free and paid apps that can help.
    Good luck.

  11. Micheal
    December 21, 2012 at 3:29 am

    group them. like friends, family, classmates and so on.

Ads by Google