Import leads from Excel or CSV
Automatic column matching, turning a spare column into a custom field, and how duplicates are caught.
āĻāĻĒāĻ¨āĻŋ āĻĒā§āĻ˛ā§ āĻāĻžāĻĒāĻ˛ā§ āĻ¤āĻŦā§āĻ āĻĒā§āĻ˛ā§āĻ¯āĻŧāĻžāĻ°āĻāĻŋ YouTube āĻĨā§āĻā§ āĻ˛ā§āĻĄ āĻšāĻ¯āĻŧāĨ¤
Step by step
After this video you can bring in the sheet your team already uses, map its columns, keep duplicates and bad numbers out, and hand the leads to your callers in the same step.
- 1
Choose the file
Leads â Import. Drop a .xlsx, .xls, .csv or .tsv file of up to 50,000 rows and 25 MB, with column headings in the first row. Several files can go in at once: each file, and each sheet in a workbook, becomes its own list.
- 2
Match the columns
LumaKol matches common headings automatically. Confirm which column is the mobile number (required), the name and the email, and map extras to lead fields such as company, city, source or stage.
- 3
Turn a spare column into a custom field
A column that matches no lead field can become a new custom field on the spot, or you can skip it. Nothing has to be set up in Setup â Custom fields first.
- 4
Assign and label
Choose Decide later to leave the leads unassigned, one person, or Split evenly across the people you tick. Give the sheet a source label: it becomes the lead source you see in reports.
- 5
Check the rows before importing
Every row is checked in your browser before anything is uploaded: phone numbers, numbers repeated in the file and your custom field rules. Each problem row is listed with its row number and the reason, and Download these rows to fix saves them as a sheet to correct and import again.
- 6
How duplicates are caught
Only rows that pass are imported. A number already in the workspace is skipped as a duplicate, so the existing lead keeps its owner and its history.
- 7
Track the list afterwards
Leads â Manage lists shows every list with who uploaded it, how many leads it holds and who they sit with, and how far it has been called. Reports â Import history lists every sheet imported, with what was accepted and what was skipped.
Tips
- A number with a + is read as written. One without it is read as a number of your workspaceâs country first, then as an international number written without the +.
- During the free trial a workspace can keep up to 500 leads.
- Use one source label per channel, such as an expo or a campaign, so reports can tell them apart later.
Read the full guide
The written guide covers the same screens, with every setting explained, so you can follow along at your own pace.
- āĻ˛āĻŋāĻĄ āĻāĻŽāĻĒā§āĻ°ā§āĻ āĻāĻ°ā§āĻ¨ āĻ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖ āĻāĻ°ā§āĻ¨āĻāĻĒāĻ¨āĻžāĻ° āĻāĻŋāĻŽ āĻ¯ā§ āĻļāĻŋāĻ āĻāĻā§ āĻĨā§āĻā§āĻ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°ā§ āĻ¸ā§āĻāĻŋ āĻāĻĒāĻ˛ā§āĻĄ āĻāĻ°ā§āĻ¨, āĻāĻ˛āĻžāĻŽāĻā§āĻ˛āĻŋ āĻŽā§āĻ˛āĻžāĻ¨, āĻĄā§āĻĒā§āĻ˛āĻŋāĻā§āĻ āĻ āĻ āĻŦā§āĻ§ āĻ¨āĻŽā§āĻŦāĻ° āĻŦāĻžāĻĻ āĻĻāĻŋāĻ¨, āĻāĻŦāĻ āĻ˛āĻŋāĻĄāĻā§āĻ˛āĻŋ āĻāĻā§āĻ¨ā§āĻāĻĻā§āĻ° āĻŽāĻ§ā§āĻ¯ā§ āĻāĻžāĻ āĻāĻ°ā§ āĻĻāĻŋāĻ¨āĨ¤
- Lead management appEvery enquiry owned, scored and followed up
More from āĻĒā§āĻ°āĻĨāĻŽ āĻĒāĻ°ā§āĻŦ â āĻ¸ā§āĻāĻāĻĒ āĻāĻ°ā§āĻ¨
- 1Read your dashboard like a manager3:22
- 2Build your pipeline3:17
- 3Call outcomes that book the next follow-up3:10
- 4Custom fields, call scripts and message templates3:22
- 5Roles and seats explained2:47
- 7Assign, reassign and reset lead lists2:54
- 8How your agents work a lead2:27
- 9Follow-ups, live board and attendance4:30
- 10Reports and billing4:35
āĻāĻĒāĻ¨āĻžāĻ° āĻāĻŋāĻŽāĻā§ āĻāĻŽāĻ¨ āĻāĻāĻāĻŋ CRM āĻĻāĻŋāĻ¨ āĻ¯āĻž āĻĒā§āĻ°āĻ¤āĻŋāĻāĻŋ āĻāĻ˛ āĻ¸āĻāĻ°āĻā§āĻˇāĻŖ āĻāĻ°ā§
āĻāĻĒāĻ¨āĻžāĻ° āĻāĻ¯āĻŧāĻžāĻ°ā§āĻāĻ¸ā§āĻĒā§āĻ¸ āĻ¸ā§āĻ āĻāĻ°ā§āĻ¨ āĻāĻ° āĻ¸ā§āĻĻāĻŋāĻ¨āĻ āĻāĻ˛ āĻ§āĻ°āĻž āĻļā§āĻ°ā§ āĻāĻ°ā§āĻ¨āĨ¤
- āĻāĻžāĻ°ā§āĻĄ āĻ˛āĻžāĻāĻŦā§ āĻ¨āĻž
- āĻāĻ˛ āĻ¨āĻž āĻāĻ°āĻž 3 āĻāĻ¨ āĻ ā§āĻ¯āĻžāĻĄāĻŽāĻŋāĻ¨ āĻĒāĻ°ā§āĻ¯āĻ¨ā§āĻ¤ āĻŦāĻŋāĻ¨āĻžāĻŽā§āĻ˛ā§āĻ¯ā§
- āĻāĻĒāĻ¨āĻžāĻ° āĻ¨āĻŋāĻā§āĻ° SIM āĻĨā§āĻā§ āĻāĻ˛