Forum Discussion
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
Damian92 If you connect to the link via PowerQuery, the import will produce the desired table. See attached.
3 Replies
- Riny_van_EekelenPlatinum Contributor
Damian92 If you connect to the link via PowerQuery, the import will produce the desired table. See attached.
- Damian92Copper ContributorWill have some reading to do on that tool. Totally forgot about it. Thank you.
- Riny_van_EekelenPlatinum Contributor
Damian92 This is a good starting point.