10

I've used Gmail since 2004, and now I have about 3000 Gmail contacts. I don't recognize the vast majority of them and many of my contacts are just email addresses. Over the years I've synced my contacts with every social network and cloud sync service out there and now my address book is a real mess. I only use my address book for personal mail. I have less than 200 people that I actually keep in touch with - I don't exactly know how the other 2800 contacts got there. I sync my Gmail with iCloud, so my iPhone's contact list is a mess too.

Is there some technique, application or service to magically clean up my address book? Perhaps I could delete everyone who I have not sent any email to.

3 Answers 3

5

You should have a look at Lifehacker full guide to clean up Gmail Contacts.

Some topics they cover that could help you:

  • clean up duplicates
  • export and import csv

I'd say that for 200 contacts, the easiest way is to:

  1. export to CSV
  2. keep the contacts you want (delete the unwanted rows)
  3. delete all your gmail contacts
  4. import the clean and fresh CSV to Google Contacts
5

The easiest way to accomplish this would be to use Conxt.

All you have to do is start your free account and auto-import from gmail (and other platforms). Most of the duplicates will be auto-merged during this import process. No data is lost during this. Then, starting at that point, simply check the checkbox next to the ones you wish to delete and click the delete button. If the auto-merge missed any duplicates, just select those contacts and choose 'manual merge'.

At this point, you now have a clean, duplicate free address book online. You can then export your address book (or just a subset of it) in gmail format. Before you upload it to gmail, I would first delete ALL of your existing google contacts. Then upload the CSV that was exported from conXt.

Disclaimer: I'm a co-founder.

1
  • I tried conXt yesterday, after finding your description and apparently not much else on the market. Some quick feedback: really like the intelligent merge features, as well as the manual merge. The relaxed approach to fields, multiple entries is great. A few things could be better: Right now it's only only keyboard/mouse usable. Could do with better smartphone integration (app for Android?). And if not, then at least the website should work with smartphone/tablet format. If you're still developing it, is there a place to leave detailed feedback on features / bugs? Jun 2, 2013 at 9:25
1

It's not possible anymore in the user interface to delete all contacts with a few clicks. You're limited to the 250 contacts shown per page.

But you can use Google Apps Script to achieve this result if you have a lot of contacts:

  • Create a new document (any type) in Google Drive;
  • Go to ToolsScript Editor;
  • Copy and paste this text:
 function deleteContacts() {
    var myContactGroups = ContactsApp.getContactGroups();
     for(var i = 0; i < myContactGroups.length; i++) {
        var myContacts = ContactsApp.getContactsByGroup(myContactGroups[i]);
        for(var j = 0; j < myContacts.length; j++) {
            ContactsApp.deleteContact(myContacts[j]);
        }
     }
 }
  • Open RundeleteContacts;
  • If the execution time limit is exceeded, run again as many times as necessary to remove the remaining contacts.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.