I am trying to upload a CSV file with Lat and Long data in it and there are two columns that are not numeric (see picture below). Whenever I try and upload the file, QGIS recognizes it as a string file and loads all the data in one line, which isn't what I want. Is there any way to get this to load as a delimited text layer or should I be loading it in as a different layer? I tried loading it in as a vector layer but then it called the lat long columns "real" not "integer" and I couldn't see them displayed (probably because of this).
I have a .csv file (Comma-separated values), i.e. a raw ascii text file like this:
"House_number","count" "1",103991 "10",81932 "100",4997 "100A",358 "100B",350 "100C",184
I load it in QGIS, using 'Add Delimited text layer', like this:
And it shows up perfect in the table afterwards. Note that text fields left-justify, while number fields right-justify.