How to build a resume database in excel.

Updated: Mar 24



Building a database of resumes is the most effective way to have access to a ready talent pool of candidates. Most recruiters and hiring managers will tell you how difficult hiring has been in certain industry segments where skillsets are a shortage. Many a time candidates are sought after by multiple head hunters and have more than one offer at hand. Candidates doing a no show on the date of joining is quite common these days which can be a nightmare for HR managers and recruiters. Building a database of resumes is a reliable way of storing information, and can always be useful in crunch situations. Moreover it's also easily searchable, which can make it ideal for storing information about job applicants and their resumes. You could quickly sort, match and shortlist candidates even at short notice.


1. Manually convert PDF and word files to excel format.


Building a database of resumes can be a time consuming affair at first, especially if you're accepting resumes as PDF files and Word documents. Now you will have to engage another team to convert them and import the information into your database system such as Excel. However landing pages are a great way to start accepting resumes. Using professional designed landing pages that get higher submissions you could recieve more resumes through web forms on your landing page. you could store all that data directly in your database. You could share the link to your landing page on your job opening section or social networks. Further applicants will be entering their information into the database for you and you wont need any additional support to convert into excel format. There are countless options for building an online resume database. With these solutions, job applicants enter their information in an online form and each entry is placed in a database that you can access and search through to find the best applicants. Click here to read my post "7 Best practices to sourcing candidate resumes"




2. Use Microsoft Office to import and convert files to excel format.


If you're familiar with Excel, you may already know that it can also be used as a database if you link two tables together: a master table and one or more details tables. Also known as slave tables, the details tables are linked to the master table. There are several ways to create a database of resumes you already have in Word or another document format. One of the less labor-intensive ways to use Excel is to put all of your resumes in a folder and convert each to TXT format. You can then import each one into an Excel spreadsheet using the Text/CSV import option under Excel's Data tab. Click Here to view sample files. Copy the cell containing the applicant's name, as well as any other important information like contact information, education and current position, and then paste it as a link to the appropriate cell in the master spreadsheet. You can also paste a link to the original resume document by right-clicking a cell in the master sheet, selecting Link, then Existing File or Web Page and then selecting the resume file. Click here to read my post "Top 3 ways to reduce your hiring cost"



3. Source Candidate resumes as an excel file.


This by far is the most effective strategy to adopt going forward. Using candidate sourcing best practices today you could source candidate resumes as an excel file. Click here to download sample resume data lists. At Valve Solutions we can provide you resumes globally extracted from Linkedin, Indeed, Monster and several other online platforms based on your requirement. We extract, filter and validate all data fields and provide you the same in an excel file with upto 34 data fields which include the first & last name, job title, headline, company, company url, personal and company linkedin profile url, work and personal email ids and phone numbers, personal skills, current and previous companies worked at, educational qualifications, location etc. You could now import hundreds of resumes as an excel file into your CRM/ATS and all the data gets parsed, no need for manual entry. Now you could share this database of resumes with all your teams. Quickly sort, search data columns and match your project requirements in minutes and build a shortlist of candidates that match your requirement. Thus saving you time and money going over a pile of irrelevant resumes. And should a candidate back out in the last minute you will always have the next candidate ready. Click here to read my post "7 steps to overcome the biggest challenges while hiring?"

910 views0 comments

Recent Posts

See All

What do you need done today?

Valve Solutions is your one stop

shop for all your website and social media services. We help 

your business grow in a social, mobile, digital world

Contact Us

4283 Express Lane,

Suite 5199-367, Sarasota

FL 34249, USA

201 Vimal, Sarvodaya Nagar,

Mulund West, 400080

Mumbai, India

  • Instagram - Black Circle
  • RSS - Black Circle
  • Pinterest - Black Circle

©2019 by www.valvesolutions.co. Proudly created with Wix.com