Output Formating is bad in excel - How to sort out?

[Abbas999]

Hi Experts,

I need your help. I am actually converting addresses into GPS coordinates "Longtitudes and Lattitudes". I am using a website where input around 200 addresses and they provide output in a csv. You can see the image below. The formating is little bad. All the data is good but they are not on their accurate location. You can see some part of address like city and zip code is in Latitude and longtitude cell and lattitude and longtitude data is showing in easting and northing cell. Can you suggest a way to keep all in format? Well i don;t need address data as i have to put the gps coordinates from this csv to main csv where all the data is available. I want all the gps coordinates in order as it is in the csv.

 

[Abbas999]

I think this is not a big problem and someone will have a solution for me. I always got a solution from this forum. I hope this time i will learn something new. Please reply. Thanks

 

[RatExcel]

Please provide the csv file.

 

[Abbas999]

Here is link to Download testing file : https://www.dropbox.com/s/8ky9znwe3ds06ui/Testing File.xlsx?dl=0 Please Reply with a solution. Thank you

Please provide the csv file.

 

[gaz_chops]

That is the excel file! Have you got the original .CSV file

 

[Abbas999]

That is the excel file! Have you got the original .CSV file

I convert orignal one to excel as i am totally a newbie in this field and i Don't know why csv format is important. I think you guys are expert and you know better than me. here is the download link to csv file : https://www.dropbox.com/s/ezoq9imjgiyd8zd/Testing FIle CSV format.csv?dl=0

 

[RatExcel]

I need original csv file. Which site do you use for generating this csv?

 

[Abbas999]

I need original csv file. Which site do you use for generating this csv?

The .csv file is original. The website generates the file and it is available for download as .txt file. After downloading i open the text file and save as .csv to make it is a comma delimeted file. Here is the download link to csv file : https://www.dropbox.com/s/ezoq9imjgiyd8zd/Testing FIle CSV format.csv?dl=0

 

[Abbas999]

I need original csv file. Which site do you use for generating this csv?

The website is "www.doogal.co.uk" you can download the output as .txt file.

 

[RatExcel]

The website sucks, the only way I can see it done is to do it manually or find another website which generates better files. Sorry...