Home/HighLevel/Features/Contacts/HighLevel CSV file guidelines for contact and opportunity imports

CRM and Pipelines

HighLevel CSV file guidelines for contact and opportunity imports

In short

The CSV file format guide explains how to structure a .csv file so HighLevel can read contact or opportunity data without errors. It covers required columns, mandatory values, field specific formats, file size limits and supported country and timezone lists.

AreaContacts · Smart Lists
Used forReal estate agency, Dental practice, SaaS startup
Setup steps8 steps in 1 task
Last updatedNovember 16, 2026

01Who this is for

  • Founders who need to bulk upload new leads quickly, as a clean CSV reduces manual data entry.
  • Marketing teams that run large email or SMS campaigns, as correctly formatted tags and custom fields enable precise segmentation.
  • Sales managers importing opportunities, as the required IDs let the system update existing records instead of creating duplicates.

02CSV file formats, explained

HighLevel reads .csv files that contain one worksheet and a header row matching either standard or custom field names. When the file follows the required structure, the platform maps each column automatically and can create or update contacts and opportunities in one operation.

The import process validates country names, timezones, phone formats and other data types against the rules listed in the guide. If a row meets the mandatory field rule, at least a first name, email or phone, the record is accepted; otherwise a new record is generated. Errors are reported when the file exceeds 30 MB, uses a different format, or contains unsupported values.

03How businesses use CSV file format

  • Real estate agency. The agency builds a CSV with columns for First Name, Last Name, Email, Phone, and Property Tags. After ensuring each phone uses the E.164 format, they upload the file so HighLevel creates new leads and tags them for specific property types.
  • Dental practice. The practice adds an Additional Phone Numbers column and formats entries with commas. By including the practice's custom field for Insurance Provider, the CSV import adds those details to each patient record in HighLevel.
  • SaaS startup. The startup exports a list of trial users, includes a Contact Owner column formatted as "FirstName LastName", and imports the CSV. HighLevel assigns each contact to the correct owner and updates existing users based on email matches.

04The numbers and rules that matter

  • Sheets allowed: One sheet per file.
  • Max file size: 30 MB.
  • Phone formats accepted: E.164 (+11234567890) or US formats like 123-456-7890.

05Before you start

  • Create any custom fields in HighLevel with the exact labels and data types you will use in the CSV.
  • Save the file as .csv with only one worksheet.
  • Make sure the file size does not exceed 30 MB.

06How to set up and use CSV file format in HighLevel

Prepare a CSV file that HighLevel can import

  1. Create a .csv file that contains a single sheet and a header row matching HighLevel field names.
  2. Add at least one of the mandatory columns: First Name, Email Address, or Phone Number.
  3. Enter data using the formats specified for each field type, such as E.164 for phone numbers and MM/DD/YYYY for dates.
  4. If you need multiple phone numbers or emails, place them in separate columns named Additional Phone Numbers and Additional Email Addresses and separate entries with commas.
  5. Verify that any Country or Timezone values match the exact case sensitive entries listed in the guide.
  6. Remove any blank rows or columns that are not needed.
  7. Check that the file size is under 30 MB and that the file extension is .csv.
  8. Save the file and upload it through HighLevel’s import interface.

07Settings that matter

  • Date Picker (Date Fields). Controls the accepted date formats such as MM/DD/YYYY, YYYY/MM/DD, MM DD YYYY or YYYY MM DD.
  • Multi, Select / Checkbox. Defines how multiple values are separated, commas, semicolons or periods.
  • Single Option (Dropdown). Allows only one value per cell, matching a predefined list option.
  • Phone Number. Specifies the required format for phone entries, with E.164 recommended.
  • Tags. Determines how tag values are delimited, using commas, semicolons or periods.

08Things to know before you rely on it

  • Only .csv files are accepted; other formats are ignored.
  • A maximum of one worksheet may be present in the file.
  • File size cannot exceed 30 MB.
  • Country names must match the official list exactly, including case and spelling.
  • Timezone identifiers must be entered exactly as shown, with case sensitivity.

09How it connects to the rest of HighLevel

Michael's take

Michael Reimer
Michael ReimerFounder of CRM Pros, HighLevel Commander and Certified Admin

A stray extra sheet, a mismatched country name, or an unsupported phone format will cause the upload to fail.

When the CSV follows the guidelines, fields map automatically and postimport cleanup is minimized.

Get More InformationOpens on HighLevelPublished November 2, 2026 · Updated November 16, 2026

Common questions

Common questions about CSV file format.

Can I import contacts with more than one phone number or email?

Yes. Add separate columns named Additional Phone Numbers and Additional Email Addresses, and separate multiple values with commas.

What happens if a column in my CSV does not exist in HighLevel?

The column is ignored unless you map it to an existing standard or custom field during the import process.

Will HighLevel detect duplicate contacts automatically?

Yes. Duplicate detection uses your Duplicate Detection Settings and can match by Contact ID, phone number or email, then merge or skip records.

Can I update existing contacts with a CSV import?

Yes. Include a field used for duplicate matching, Contact ID, email or phone, and HighLevel will update the matching records instead of creating new ones.

Next step

Pick the features that matter. Then get the plan that unlocks them.

Explore the features you want, start with the five at the top, and upgrade through my link when you are ready. The bonuses and the team come with it.

The features directory explains every HighLevel feature in plain English. Browse it to see what the platform can do.

Back to the FeaturesSee the full details
⌃

Site preview

Explore the next page

This destination is reserved in the page inventory and is not built yet.