Leadber

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

HeaderExampleNotes
company_nameLim Frozen Foods Pte LtdBusiness name. Shown as the lead's title.
first_nameWeiUsed to greet the person in messages. Falls back to "there" if empty.
last_nameLimOptional.
emailwei@limfrozen.comNeeded to email the lead. Leave empty if unknown.
phone_number+6591234567Needed to message on WhatsApp or Zalo. This is also where a WhatsApp number goes. Include the + and country code.
websitehttps://limfrozen.comOptional. Used for duplicate checking and LeadDive research.
linkedin_urlhttps://linkedin.com/in/weilimOptional.
citySingaporeOptional. Use the city name, not a full address.
industryFood distributionOptional.
notesMet at FHA 2026Optional 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

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.