Issue: There are leads information in wrong form fields even the List is in CSV and there are no commas in it.
Cause: There might be hidden formulas in the list especially if the list came from the leads vendor directly.
Step 1: Open the CSV File
Step 2: Highlight the ROWS that has Leads information ONLY. Do Not Select ALL.
Step 3: Copy the highlighted rows
Step 4: Open a New Blank Workbook
Step 5: Paste the leads information the new spreadsheet
Step 6: Save it using CSV (Comma delimited) format