I have been stuck on this for at least a week, coming back to it and always the same thing happens. I have done every step as requested. 1. I download the excel file and edit it as requested 2. Save it as CSV 3. Go to the import wizard, import leads->Add new record(Match leads by Name & Assign New Leads to this Source: Web) 4. Choose a file from the desktop named "Lead Import.csv" Then after those steps, whatever I tried I always get this (Screenshot 1) In the video that goes through the whole task, the guy has like 10 things to map while I have one, I think the problem is that it isn't separated properly, but I have NO clue why. When I open the CSV file in excel it all looks fine.
Also, when I click next I get this error, look at screenshot 2(this is probably irrelevant but I wanted to state all the info I can get)
I dropped the lead import files too, one is a CSV I am trying to upload named "Lead Import.csv" other is an edited version of the excel file from the task. Thank you in advance, I am almost finished with the full admin course and I am somehow stuck on probably one of the easiest modules so help would be highly appreciated.
Eric Praud (Activ8 Solar Energies) Forum Ambassador
Hi,
It looks liek your csv is not taking commas as the delimiter.
I see you're in Croatia, and I knwo that in most of Europe the standard delimiter for csv files is a semi-colon.
Here's an article by Salesforce on this issue:
https://help.salesforce.com/s/articleView?id=000331030&type=1
Here's an article for Excel:
https://www.ablebits.com/office-addins-blog/change-excel-csv-delimiter/