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.
- Open the CSV File
- Highlight the ROWS that has Leads information ONLY. Do Not Select ALL.
- Copy the highlighted rows by hitting CTRL + C on the keyboard or by hitting the left click of the mouse and select copy.
- Open a New Blank Workbook
- Paste the leads information the new spreadsheet by highlighting the first box, click the left button and select Paste. You can also use the shortcut CTRL + V.
- Save it using CSV (Comma delimited) format