Hi, Yes that seems to be the problem. Excel has a tendency to add empty delimiters in rows that have been erased. One way of dealing with that is to cut and paste to data you want in a new spreadsheet and then to export that to csv. I don’t think libreoffice has that problem. Nicolas
> Le 3 déc. 2018 à 06:47, Andreas Neumann <a.neum...@carto.net> a écrit : > > Hi, > > You seem to have an issue in your data around row 20. Probably not enough > delimeters, or an unescaped character within an attribute that makes QGIS > believe that parts of the data belongs to a different, potentially > incompatible, attribute. > > Please check your data against mistakes. If you can't find it out yourself, > upload it somewhere to share it and we can have a look. Without having access > to your data and the setting you used (e.g. a screenshot of your settings), > it is impossible to help. > > Another potential trouble could be that you have chosen more than one > delimiter and QGIS chokes on that because that other delimiter is part of > your data in a certain attribute. > > Andreas > >> On 2018-12-03 12:07, Taimur al said wrote: >> >> >> Hi, >> >> I'm emailing regarding an issue i'm facing with the latest version of Qgis >> 3.4.2. >> >> Currently im trying to upload an excel sheet converted to (CSV format) on >> Qgis, this sheet has over 100 rows but only 20 rows are shown and then after >> adding these rows to the canvas only 20 points show. I have tried with other >> excel sheets (CSV) i have tried and worked with in the past with the older >> version and still only 20 rows show. >> >> >> May i ask if im doing anything wrong / is there a new way to do it? >> >> Hope to hear from you soon. >> >> Regards, >> >> Taimur Al Said >> Wildlife Biologist >> >> _______________________________________________ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
