Explanation/ Solution: Lead Import Error - Column Header must not be longer than 64 characters

Explanation/ Solution: Lead Import Error - Column Header must not be longer than 64 characters

Issue/ Error :: 

While importing leads, user is getting the error Pop-up stating “Column Header must not be longer than 64 characters”, post file upload. 

Explanation :: 

It can be due to wrong CSV encoding or longer text string in headers of the uploaded CSV file. 

Solution :: 

The supported file type is as follows: “CSV UTF-8 (Comma delimited) (*.csv)”. 
In order to save the folder in the specified format, kindly reproduce the following steps (attaching images for your reference): 

1) Kindly open your CSV File in MS Excel. Please select the header: “File”.


2) Kindly select “Export”


3) Please change the file type using “Save As”


4) Kindly select CSV UTF-8 (Comma delimited) only. 


5) Once the same is done, you would be able to observe a green dot(as shown below) on your file when attempting the import, meaning the file is ready for import. 


    • Related Articles

    • Import Failing with Unique Constraint Error

      Issue: Lead import is failing for specific leads at the time of import and the Message comes as a Unique constraint error from the Prospect Base table. Resolution: If an account has 2 unique fields, Email and Phone. And while importing both fields ...

    • Opportunity import error | Updation | Import restrcition

      Issue reported: When trying to update opportunities using the opportunity import function, the following error is displayed in the import report as shown below. Import parameter to be noted - Overwrite duplicates. Error message - "Creation of new ...

    • No Error message on Unprocessed leads in import

      Issue: When we import leads into LS, and if any of the leads are unprocessed due to any reason, the Unprocessed reason is not shown by default. Resolution: There is an explicit setting that needs to be enabled from the backend so that the Unprocessed ...

    • Lead Cohort Assignment | Gurnick and GEGI Integration

      Issue Raised: Leads not containing the right Cohort. Alternative/Associated Queries: 1) Leads in LSQ and Students in GEGI have different Cohort identifiers. 2) Registration Link is not being sent. 3) Lead is not updating in the as per GEGI data. ...

    • How to hide the Lead Age from the Mobile App.

      Scenario: How to hide lead age from the Leadsquared mobile application. Solution: Steps to hide lead age: If you see in the Mobile App by default the lead age will be shown up against the leads, If the customer wants to remove the lead age then It is ...