Forum Discussion

Damian92's avatar
Damian92
Copper Contributor
Oct 07, 2021
Solved

Importing the correct decimal data into a spreadsheet (latitude/longitude)

Hi everybody. 

Questions about latitude and longitude were already asked, regarding cell formatting. My issue relates to the import of that data instead. I might be missing some math basics here, I am afraid.
I have https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports.dat set of data which comprises of airports and relative coordinates. I saved the page and imported the data as a comma separated one which then created the table as expected.

However, I realized that coordinates have their decimals all wrong.

To illustrate this, in the original data "BFS", Belfast is located in 54.6575012207,-6.2158298492399995, whereas my file is showing that as 546.575.012.207, -62.158.298.492.399.900. 

My cells are now formatted as "Number"; I believe that perhaps I might need a custom cell format but I am worried I might get the wrong one. Any help would be highly appreciated.

Thank you

 

Original file vs my spreadsheet

3 Replies

Resources