Comment

Importing Contacts into JibberJobber from [Outlook, Facebook, Yahoo, Verizon, etc.]

June 29th, 2012

On the JibberJobber user webinar on Wednesday I had a number of people ask how to import contacts from other systems, including Verizon (that was a first) and Facebook (it’s been a while since anyone asked that.

The bottom line is that you can import any CSV file.  You just have to figure out how to export your contacts from any of those systems.

The first place I would start is on a Google search, which would look like this:

Just change “verizon” for whatever system you are looking for… here are a few exports you might be interested in:

Get the point?

What do you do once you export?  As long as you remember a csv is simply a file that opens with Microsoft Excel (ie, it’s just a spreadsheet (kind of)), you should be good.  I do the following:

  1. Open the file (in Excel).
  2. Clean the file.  If it’s coming from LinkedIn, I delete about 20+ blank columns.  If it’s coming from other places (like those above), I am not sure what you get.  You don’t have to delete/clean anything, but I’m a nerd for good data, and I like to clean it in the spreadsheet rather than one-by-one in JibberJobber.  This could include making sure the Last Name column only has LAST NAMES, not acronyms, etc.
  3. Add new columns.  If nothing else, add a column titled SOURCE, and then for every record put in _______-Import.  For example, I regularly have contacts with a source of “LinkedIn_Import”, which allows me to know I’ve imported them from LinkedIn. Other columns you might want to add are: tags, notes, rank, initial_contact, birthday, and any user defined fields you have set up in JibberJobber.
  4. Save the file. Make sure you SAVE AS a csv file.

Then, go to JibberJobber and import.  You get there by mousing over the Network drop down and then clicking import/export. More details on that in a later post.

Hope this helps…

See Comments / Leave a Comment »

One response to “Importing Contacts into JibberJobber from [Outlook, Facebook, Yahoo, Verizon, etc.]”

  1. Evelyn says:

    Any plans of automating the integration/connection to FB, LinkedIn the way SimplyHired does?