I've been trying to add a certain CSV file as a points layer to QGIS for a while now, without much success. It can be viewed over here. (It was adapted from this .xls data file). In the online displayer, it does not render well. That's probably because information was lost when I saved the original .xlsx file as a CSV.
However, when I add it as a delimited text file in QGIS with ; as the regular expression delimiter, the sample looks good. Still, the point coordinates are not shown on the map when I choose longNieuw and latNieuw as the x and y coordinates, respectively.
I'm not sure what goes wrong, as I have earlier successfully added other point layers in QGIS.
Question: why can the linked CSV file above not be added properly as a points layer file in QGIS?
Note: here's an example of a coordinate tuple of the csv file I'm trying to upload:
28,69733300601 ; -100,51019685 The CRS of my own project is EPSG: 3857 . I've tried adding the points layer in both this CRS and in EPSG: 4326.