[GIS] QGIS won’t read table columns in CSV import on Mac OS

csvimportmacqgis

I am trying to import a CSV file into QGIS, but it ends up looking like my print screen below (program is in Swedish but in the preview window you can see how QGIS won't read my data correctly). I can't load the data since for some reason, QGIS reads my CSV table columns as one single row. What is wrong? I want QGIS to read my data as numbers, so I have created an additional csvt-file with the code "String","String","Integer". Is there something else that I need to to in order for QGIS to read the third column as numbers?

enter image description here

Still, after doing that it loos like this… enter image description here

enter image description here

Best Answer

I had the same problem of QGIS reading a CSV file (saved from MS Excel 2011 on my Mac) as a single row.

So, I re-saved the Excel worksheet as "Windows Comma Separated (.csv)" and QGIS was able to read it just fine.

Related Solutions

QGIS – How to Resolve Numeric Column Recognition Issues Despite CSVT

The "Add delimited text layer" tool does not interpret the CSVT. Only "add vector layer" needs a CSVT. Basically, "add delimited text layer" tries to make a best guess and it usually does very well recognizing numeric values. One of the reasons to use "add vector layer" is that "add delimited text layer" requires a geometry column.

Does your CSV contain a geometry or x and y columns? Then use "add delimited text layer".

If your CSV does not contain any coordinates/geometry, use "add vector layer".

As to why the numeric values are not recognized by "add delimited text layer", please post your CSV or at least a sample (first few lines). If even one line in the file contains a text in the "numeric" column, the tools will default back to String.

[GIS] QGIS CSV import of percentage values

Your numbers still contain the "%" symbol. If you want them to be recognized as numbers then loose the "%". i.e.:

LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander 
Albury (C);0.93;0.02;0.0
Armidale Dumaresq (A);0.88;0.06;0.00

Also be sure you are choosing the semicolon ";" as the "Custom delimiter" when you do the import.

Best Answer

Related Solutions

QGIS – How to Resolve Numeric Column Recognition Issues Despite CSVT

[GIS] QGIS CSV import of percentage values

Related Question