Learn / Import leads
How to format a file to import leads into Leadber
Short answer: use a CSV or Excel file with the headers in row 1 and one lead per row. Use these headers: company_name, first_name, last_name, email, phone_number, website, linkedin_url, city, industry, notes. Give every lead a phone_number with country code (for example +6591234567) or an email. Importing is free (no credits) on paid plans and during the free Pro trial.
Columns
| Header | Example | Notes |
|---|---|---|
company_name | Lim Frozen Foods Pte Ltd | Business name. Shown as the lead's title. |
first_name | Wei | Used to greet the person in messages. Falls back to "there" if empty. |
last_name | Lim | Optional. |
email | wei@limfrozen.com | Needed to email the lead. Leave empty if unknown. |
phone_number | +6591234567 | Needed to message on WhatsApp or Zalo. This is also where a WhatsApp number goes. Include the + and country code. |
website | https://limfrozen.com | Optional. Used for duplicate checking and LeadDive research. |
linkedin_url | https://linkedin.com/in/weilim | Optional. |
city | Singapore | Optional. Use the city name, not a full address. |
industry | Food distribution | Optional. |
notes | Met at FHA 2026 | Optional free text. |
Headers do not have to match exactly. The import screen shows a field mapper, and names such as Email, Mobile, WhatsApp, Company, Business Name, Website, City, Industry or Remarks are matched automatically. Check the mapping before you click Import.
Example file
company_name,first_name,last_name,email,phone_number,website,linkedin_url,city,industry,notes Lim Frozen Foods Pte Ltd,Wei,Lim,wei@limfrozen.com,+6591234567,https://limfrozen.com,,Singapore,Food distribution,Met at FHA 2026 Kopi Supplies Sdn Bhd,Aisyah,Rahman,,+60123456789,,,Kuala Lumpur,Wholesale,WhatsApp only Harbour Logistics,Daniel,Tan,daniel@harbourlogistics.sg,,,,Singapore,Logistics,Email only
The three rows show a lead with everything, a WhatsApp-only lead and an email-only lead. Empty cells are fine.
Rules
- Files: CSV (UTF-8), .xlsx or .xls, up to 20 MB. Headers in row 1. Excel files: only the first sheet is read.
- Phone numbers: write them with a + and country code. Without it a number is read as Singapore. A number Leadber cannot recognise is saved as typed and will fail to send, so check them before importing.
- Email-only leads: allowed. Leave phone_number and website empty.
- Duplicates: skipped when the same phone number and website already exist in your workspace. With no phone and no website, email, company and name are compared instead.
- Cost and plans: free, no credits used. Import is available on paid plans and during the free Pro trial. Before importing, Leadber shows how many rows are new and how many are already in your leads.
- Where leads go: into a campaign named "CSV / Excel Import" with status NEW, ready to research, message or email.
Questions
Which columns are required to import leads into Leadber?
None is enforced, but each lead needs at least a phone_number (to message it on WhatsApp or Zalo) or an email (to email it). A row with neither cannot be contacted.
What phone number format does Leadber need?
International format with a plus sign and country code, such as +6591234567 for Singapore or +60123456789 for Malaysia. A number without a + and country code is read as Singapore. A number Leadber cannot recognise is saved exactly as typed and will fail to send.
My file has separate Phone and WhatsApp columns. What should I do?
Map both columns to phone_number on the import screen. Leadber keeps one number per lead: for each row the first column (left to right) that has a value is used, and an empty cell never erases a number from another column. Leadber messages that number on WhatsApp, so put the number you want to use for WhatsApp in the left-most column.
Can I import leads that only have an email address?
Yes. Leave phone_number and website empty. Rows with no phone and no website are matched for duplicates on email, company and name, so a list of email-only leads imports in full.
How does Leadber detect duplicates when importing?
A row is skipped when a lead with the same phone number and website already exists in your workspace. Rows with neither a phone nor a website are compared on email, company and name instead.
How much does importing leads cost?
Nothing. Importing your own leads is free and uses no credits, and duplicates are skipped. It is available on every paid plan and during the free Pro trial; the Free plan does not include lead import.
What file types and sizes are supported?
CSV (UTF-8), .xlsx and .xls, up to 20 MB. The first row must be the column headers. For Excel files only the first sheet is read.
Ready? Sign in to Leadber, open Leads, then Import.