How to Clean Up CSV Export

This is a preview. View original post on this site


As Sourcers, we have to work with exported data. LinkedIn Recruiter, Instant Data Scraper, and other scraping tools provide export to CSV with the wrong coding, that may look like this:

Looks familiar? Here is how to straighten it out (thanks to David Galley for the tip!)

Step 1. Open a new Excel file and choose Data/From Text/CSV:

Upload the CSV file.

Step 2. Choose “Unicode (UTF-8)” and load:

Done. The coding is straightened out:

My favorite scraper is the contact finder SalesQL because it provides:

Excellent coverage across industries and locations Private and

Read Complete Article

,

Subscribe to Recruiting Headlines

* indicates required


RECRUITMENT MARKETPLACE


»Need an ATS? Try JazzHR


»Free Rejection Email Templates


»Text Recruiting Software


»RecTech Live Webcasts


»HR Podcast Directory


»Recruiting Newsletters


»HR Tech News


»Freelance HR Jobs


»Diversity Hiring News


»Recruiter Ebooks