A lead import is a handover to the people who will make the next call. If phone numbers are damaged, ownership is unclear or callback promises disappear, a successful upload can still leave your sales team with an unusable list.
Use this checklist before importing phone-sales leads from CSV or Excel. It separates data preparation from interface requirements, so you can build a useful working sheet without assuming every column can be imported.
1. Define what the list is for
Decide whether you are bringing in new enquiries, moving an existing pipeline or reassigning leads between employees. Each needs different attention:
- New enquiries: retain the source and enough context to explain why the person may expect a call.
- Existing pipeline: preserve the current stage, latest meaningful conversation and promised next step.
- Reassigned leads: identify the new owner and any commitments made by the previous employee.
Keep an unchanged copy of the original file. Use a separate working copy for cleanup and record who approved it for import.
2. Prepare a useful working sheet
Start with contact name, phone number, source, owner, status and next-action context. Add company or other details only when they help the calling workflow.
These are planning fields, not a statement of required import columns. Check the actual import interface for accepted headers, file structure, required values and mapping options before finalizing your file.
Keep information in separate columns rather than combining a number, owner and callback instruction in one cell. This makes review easier even if some details must be added after import.
3. Check phone numbers and possible duplicates
Phone numbers deserve a separate review because they determine who your team reaches.
- Store numbers as text to avoid losing leading zeros or a plus sign.
- Use a consistent country-code convention appropriate to the list.
- Flag blank, incomplete or visibly malformed numbers for review.
- Look for the same number appearing with different spacing or punctuation.
- Review repeated numbers before deciding whether records represent duplicates or distinct contacts sharing a number.
Do not assume the import will automatically identify or merge duplicates. Resolve known conflicts deliberately, and retain useful notes before removing any row.
4. Agree on owners and status meanings
Assign an accountable employee to each lead that is ready for calling. Review unfamiliar owner names and leads whose previous owner has left the team.
Agree on what each status means before mapping old labels to new ones. For example, distinguish “attempted but not reached” from “contacted and interested.” A scheduled callback is not evidence that a lead is qualified.
In CallTrackly, lead management for phone sales teams supports employee assignment individually or during a CSV or Excel import. Confirm how your sheet's ownership and status values should be represented in the import interface.
5. Preserve commitments, not unnecessary personal details
A useful handover note tells the next caller what was discussed and what should happen next. “Requested a callback on Tuesday afternoon to discuss delivery timing” is more actionable than “follow up.”
Where possible, resolve vague dates before import. Keep notes relevant to the business conversation and avoid collecting unnecessary personal information.
Treat notes and scheduled tasks separately. After import, check whether callback commitments need to be entered as follow-ups. CallTrackly lets teams schedule the next follow-up with a date, time, employee and supporting context.
6. Test a sample, then check the full import
Use a small, representative sample before processing the full list. Include an ordinary lead, a reassigned lead and one with a callback commitment. Compare the resulting records with your working sheet.
Use this acceptance checklist for the sample and repeat it after the full import:
- [ ] Expected records are present; any omissions are understood.
- [ ] Names and phone numbers display correctly.
- [ ] Assigned employees are correct.
- [ ] Statuses retain their intended meaning.
- [ ] Relevant notes and source details are preserved where supported.
- [ ] Callback commitments have an actionable next step.
CallTrackly connects lead records with calling activity and supports follow-up scheduling. The import is ready for handover when employees can identify whom to call, why they are calling and what needs to happen next—not simply when the file finishes uploading.
Sources
- Call Recording Software | Streamline Call Tracking | telecrm Accessed 2026-11-16