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. Nov 9, 2020 at 15:24
  • its is working when i upload one but not all, 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
    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
    Nov 9, 2020 at 15:48
  • 1
    How exactly do you "upload" it! Please share a screenshot of the dialog. 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 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
    Nov 10, 2020 at 7:44

Your Answer

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

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