I'm trying to upload a CSV-file with coordinates of about 80,000 lines, when ever I uploading the file to QGIS, for some reason, the coordinates don't display right and spreading equally. But when I upload one by one (for testing) the position is correct.

enter image description here

enter image description here

It does not matter from me the map I just want use intersection with polygons and points in order to get values ​​for points.

  • 4
    Can you share a sample of the data? It's hard to know why anything might be happening when we can't see the data, even a screenshot of the first few rows would help. Can you also tell us what version of QGIS you are using. Commented Nov 9, 2020 at 15:24
  • its is working when i upload one but not all, Commented Nov 9, 2020 at 15:33
  • 1
    It would be important to see how the data is structured exactly - just coordinates does not help so much. Just press the screenshot button on your keyboard and paste (CTRL-V) in the text field where you insert your question here on StackExchange.
    – Babel
    Commented Nov 9, 2020 at 15:46
  • 1
    Or upload the file someplace like Google Drive or the like and put the link here.Make sure you set the file to public sharing
    – Llaves
    Commented Nov 9, 2020 at 15:48
  • 1
    How exactly do you "upload" it! Please share a screenshot of the dialog. Commented Nov 9, 2020 at 18:04

1 Answer 1


The grid you see when you add your CSV to QGIS is caused by the precision of your coordinates. They only have two (sometimes only one or none at all) decimals. See this OSM wiki for an explanation of precision of coordinates: https://wiki.openstreetmap.org/wiki/Precision_of_coordinates

So from QGIS side, everything looks just fine. The error is caused earlier, maybe within Excel or wherever your data comes from. E.g. some MS Office products like access use the Windows OS settings for decimals which is two by default.

As a conclusion you need to fix your data acquisition.

  • so why its working fine when I upload a small sample Commented Nov 10, 2020 at 6:11
  • 1
    Please show a good import. Which column of your csv contains the right coordinates? e.g. I see a coordinate pair in column E which has rounded values in columns F and G.
    – Hans Erren
    Commented Nov 10, 2020 at 7:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.