DerDiver - Recruiting with a sense of humor.
5 Quick Tips To Help You Gather, Clean, And Verify Data By @Derdiver

5 Quick Tips To Help You Gather, Clean, And Verify Data By @Derdiver

Finding data online is great. However, knowing how to manipulate it once you have it is just as important. Last week, at SourceCon Dallas, Kameron Swinton and Mike Wolford showed us how. Below are a few tips from their lab session:

Tips for gathering data into Excel:

  • Use Mozenda to parse data so you don’t have to click on every link. Mozenda will x-ray a site and pull the data into Excel.
  • Use Tabula to extract data from .PDF lists.

Data Cleanup Tips

  • Use text to columns to split a persons name from one cell to two cells which allows you to alphabetize.
  • Concatenate the data in order to merge the cells and add in a email domain name.

Verify the Data

  • Use Full Contact to verify email addresses within your excel spreadsheet.

The session was 45 minutes long and there were a lot of demonstrations and explanations given. Nothing compares to being in the room at the event but hopefully, this short summary will send you in the right direction so you can apply these techniques to your sourcing.  Look for more SourceCon Dallas session summaries from me later this week!


  • Follow Me:
  • Follow me on Twitter.
  • Follow me on Facebook.
  • Follow me on Facebook.
  • Follow me on Facebook.
  • Follow me on Twitter.


Pop Perry; a Story of a Fourth Son

Hey Guys, Advice on Interviewing; A Satire

Hospitals, Sushi, and a Powerful Evening

The Four Horseman; Mourning the Loss of a Friend

If I Only Had A Brain, Part II: Rise Up

#Noise; Can’t Stand the Noise

If I Only Had A Brain: Why It’s Time To Rethink College Recruiting Part One

Without Bias: Pride and Prejudice and Recruiting

Wish You Were Here: The Fishbowl Approach to Candidate Sourcing.

Purple Rain…

A Tribe Called Quest: How To Fix What’s Really Broken In Recruiting

Cash Is King: How (And When) To Have That Compensation Conversation

Be Here Now: Making Candidate Experience Live Forever

Happy Hour: A Recruiter’s Guide To Hooking Up

The Grifters: Con Artists and Agency Recruiting

Why Your Job Postings Suck (And What You Can Do About It)

5 Quick Tips To Help You Gather, Clean, And Verify Data By @Derdiver

Risky Business: Why You Should Own Your Own Recruiting Data

Recruiters In Name Only: Why Real Recruiters Should Be Hunting for RINOs

The Nine Circles of Recruiting Hell: A Divine Comedy

Social Recruiting: You’re Doing It Wrong

Recruiters: Stop Talking And Learn How To Listen

Building A Global Recruiting Association: Why It’s Time To Fix What’s Broken

Born Into This: Recruiting Isn’t Always What You Think

Recruiting, It’s a Matter of Trust

Bad Influence Why Industry Lists Should Kick the Bucket

Don’t Ask Me How I Know Life Lessons Learned From A Life in Recruiting

How To Prove You’re A Real Recruiter

You’re Not Really A Recruiter.

Redemption Song: Why Recruiters Deserve A Little Respect

Stop the Recruiting Spam Seriously


Recruiter Experience: What Every Candidate Needs To Know

What About The Recruiter Experience?

It is ALL in the Intitle:Sourcer OR Recruiter

When Reqs Go Wrong: My True Recruiting Story

Sourcer or recruiter? It’s all about the intitle: via @derdiver

Why I’m (Still) A Recruiter: My Take From the Talent Trenches

#Talent 42 a Tech Conference for Recruiters by Recruiters

10 Recruiters Who Should Be On Your Radar #SundayShoutOut

It’s NOT All in a Name When You Are Recruiting

#truestory Friday

D-Day 70 years later

#trueStory 2

Faking it on LinkedIn

#truestory Tuesday

I wish you a tolerable Thursday.

An unexpected thank you

Where the new OFCCP rules are going to take us

Still learning after all these years

Increasing Your Marketability Through IT Certifications

Welcome to the Show