How to Tag Job Titles by Department (Sales, Marketing, Finance) in a Lead List

To tag job titles by department, match each title against keyword rules in a fixed order and write the first department that matches. Upload the list to the job title department tagger, pick the title column and download the file with a new Department column. It runs in your browser, and your file is not uploaded.

Why add a department column

A cold email about payroll software reads very differently to a finance lead and a head of sales. A department column lets you split one export into lists that each get their own message, or leave out the functions that would never buy. It pairs with seniority: keep directors and above with the job title seniority filter, then tag departments to pick the function you sell to. Our guide to filtering a lead list by seniority covers the first half.

The by-hand way in Sheets or Excel

Test each department's keywords with SEARCH and nest the tests, most specific first:

=IF(ISNUMBER(SEARCH("finance",A2)),"Finance",IF(ISNUMBER(SEARCH("marketing",A2)),"Marketing",IF(ISNUMBER(SEARCH("sales",A2)),"Sales","Other")))

It works for a handful of keywords. It gets long fast, and SEARCH matches inside words (it finds "it" inside "Recruiter"), so short keywords cause false tags. Excel also stops you at 64 nested levels.

Step 1: upload and pick the title column

Upload a CSV or .xlsx file, or paste the cells with the header row first. A header such as Title or Position is picked for you.

Step 2: choose whether to show the rule

Tick the option to add a Matched on column. It holds the word that decided each department, so every tag can be checked.

Step 3: read the result

Each title is read against keywords for one department at a time, in this order: legal, finance, human resources, customer success, marketing, sales, product, design, IT and security, engineering, operations and, last, executive. The first department with a match wins.

Title	Department	Why
Product Marketing Manager	Marketing	marketing is checked before product
Sales Engineer	Sales	sales is checked before engineering
Barista	Other	no keyword matched

You also get a count per department and a few examples. A blank title is labelled Unknown.

Step 4: check the Other rows

Titles are written in many ways and some are vague, such as Head of Growth or Partner. Scan the Other rows and the odd ones, then override them in the spreadsheet. Clean messy titles first with the job title normalizer; the normalising titles guide shows how.

What this tool cannot do

• It reads English titles only and uses plain rules, not a model.
• A title with words from two functions goes to the first department in the order.
• It tags what the title says, not what the person does day to day.
• Only the first sheet of a workbook is read.

Check the addresses before you send

Tidy columns do not make an address deliverable. Upload your list on the verify page: the first 100 email checks are free with a Google sign-in, no card. Each address comes back valid, risky or invalid with a reason, and nothing is sent to anyone on the list. For larger or recurring lists, see bulk email verification, list cleaning and pricing.

Tag your list now

Open the job title department tagger.