Import contacts and leads from Excel
On this page
Download the template and catalogue
Open CRM, then Contacts, to import contacts and leads from Excel.
Keep the instruction row, headings and column order unchanged. Upload the completed template; use the catalogue to read guidance and copy reference names.
Columns 1 to 5
f_name — First name: Enter the contact first name. Do not leave it blank.
l_name — Last name: Enter the last name if available, or leave it blank.
mobile_1 — Primary mobile: Enter the primary mobile as text to retain its leading zero. Use a number not already assigned to another lead in the organization.
mobile_2 — Additional mobile: Enter an additional number when needed, as text. Supplied numbers are checked for duplicates.
web_site — Website: Enter the contact website if available, or leave this field blank.
The template requires f_name, mobile_1 and source. Other fields are optional. When using a reference field, copy an available catalogue name.
Owner and classifications
owner — Contact owner: Copy a name from Lead owners, not a user number. The name must identify one clear choice.
title — Title: Enter the contact title when needed.
section — Section: Copy a name from Lead sections when needed. Do not invent a section if the reference list is empty.
phone — Phone: Enter the phone as text to retain its leading zero. Supplied numbers are checked for duplicates.
rating — Rating: Copy the appropriate name from Lead ratings.
Source description and contact channels
source — Source: Required. Copy the source name from the organization reference sheet Lead sources.
description — Description: Enter follow-up details or the contact requirement.
facebook — Facebook: Enter Facebook details if needed, or leave this field blank.
whatsapp — WhatsApp: Enter WhatsApp details when needed, or leave this field blank.
email — Email: Enter a valid email address if available, or leave it blank.
Status date and interest category
status — Status: Copy the contact status name from Lead statuses.
twitter — X account: Enter the X or Twitter account when needed, or leave this field blank.
date — Date: Enter a valid date such as 2026-11-15. The catalogue states that an empty date uses today.
industry — Industry or interest category: Copy the appropriate category from Lead industries exactly as listed.
region — Region: Enter a region name from an approved reference when needed. This optional field may be left blank.
Upload the completed file
Save as XLSX, reopen the file, and check names, mobile numbers and references. Select Import Excel and choose the completed file.
After confirmation, open Background tasks to follow the CRM leads operation and row results.
Review the result and accepted row
Correct only the rejected row
Open the original template and prepare only the rejected row. Fill f_name with DEMO-XLS-LEAD-20261115-B, retaining mobile 01000007002 and the valid reference values.
Save the correction as XLSX, upload it through Import Excel, and confirm the operation.
Verify the correction and final list
After import, review each row name, owner and mobile number. Retain the correction file and rejection report for reference.
Sign in to record the lessons you have read. Sign in