Make sure that you are following the correct format.
Copy the below sample format in a notepad, save as csv file,import and check if it is working or not.
# ExternalId*, name* , address* , phone ,desc , siteName* , longitude , latitude, timeZone*, type
901,BMC-Pune,"Bldg No 332,Erwada,Pune",020-918-8800,http://www.bmc.com,BMC-HQ-PUNE,,,Asia/Kolkata,0MMake sure th
Do you have a Google Maps license ? Please attach the CSV.
This time you are not getting a format related error, So It seems the format issue has been solved now.
Edit the contents with your location values and try to import.
If facing error, Post the error message and new CSV file.
When I tried to import by giving longitude and latitude detail. The import is successful.
So is it that for each and every location longitude and latitude needs to be given in the excel.