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

Article Continues Below
  • 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!

Derek Zeller draws from over 20 years in the recruiting industry. The last 16 years he has been involved with federal government recruiting specializing in the cleared IT space under OFCCP compliance. Currently, he is the Director of Recruiting Solutions for Engage Talent. He has experience with both third-party agency and in-house recruiting for multiple disciplines. Using out-of-the-box tactics and strategies to identify and engage talent, he has had significant experience in building referral and social media programs, the implementation of Applicant Tracking Systems, technology evaluation, and the development of sourcing, employment branding, and military and college recruiting strategies. Derek currently lives in the Portland area. Now, he is the Director of Recruiting Solutions and Channels with Engage.


Leave a Comment

Your email address will not be published. Required fields are marked *