# State lat/long from CSV-file

I am trying to place points in QGIS that are given in a csv-file, coordinates are given in WGS84 (4326) but the positions are like this

``````LAT;LONG
5724.3180;1548.4021
``````

I can't get QGIS to place them correctly. When I divide them by 100 I get the extent correct but the place is not correct `57.24318 / 15.4021`

It should be Hultsfred. The points represent trees along Väg 23 between Målilla-Hultsfred

How do I solve this?

• Welcome to Geographic Information Systems! Welcome to GIS SE! We're a little different from other sites; this isn't a discussion forum but a Q&A site. Your questions should as much as possible describe not just what you want to do, but precisely what you have tried and where you are stuck trying that. Please check out our short tour for more about how the site works Commented Jan 27, 2021 at 13:12
• can you explain more what is not correct about the place you get? and why you believe the coordinates are in 100xwgs84 (which is a very weird idea) Commented Jan 27, 2021 at 13:12
• The coordinates are somewhere East of Värnamo, Sweden, if this "divide by 100" hypothesis is correct.
– Erik
Commented Jan 27, 2021 at 13:17
• Thanks but it should be Hultsfred Commented Jan 27, 2021 at 13:18
• And how do you know this? What exactly should these points represent?
– Erik
Commented Jan 27, 2021 at 13:25

If you add the DMS-notations at the correct places, `5724.3180;1548.4021` becomes `57°24'31.8" N; 15°48'40.21" E` - which is placed exactly where it should be as you state in the comments.

I suggest you load the data into QGIS as a table without geometry. Then you use the field calculator with the following expressions to create new latitude and longitude fields:

`substr(LAT,1,2)||'°'||substr(LAT,3,2)||'\''||substr(LAT,6,2)||'.'||substr(LAT,8)||'"N'` `substr(LONG,1,2)||'°'||substr(LONG,3,2)||'\''||substr(LONG,6,2)||'.'||substr(LONG,8)||'"E'`

Then save to `.csv`, then reload with the new coordinates as DMS.

You could also use excel for this editing, I guess.

It is also likely, as @mkennedy pointed out, that the original coordinates were `DDMM.mmmm`. In this case the expression would be:

`substr(LAT,1,2)||'°'||substr(LAT,3)||'\'N'`

And similarly for the East-coordinate.

• Thanks /Tack så mycket Commented Jan 27, 2021 at 13:55
• You're welcome @ÅkeEriksson. I just changed the expression, because I initially forgot about the point in the coordinates.
– Erik
Commented Jan 27, 2021 at 13:58
• @Erik I would have guessed the values were DDMM.mmmm. Good catch! Commented Jan 27, 2021 at 18:26
• @mkennedy which seems even more fitting, since it explains the point. The difference to the DMS is small enough.
– Erik
Commented Jan 27, 2021 at 19:09