I'm trying to add a delimited text layer using coordinates. The file has been created in excel and then converted to a csv file in the saving. When I put it into Qgis it doesn't recognise the headings- it puts all the cells as headings and doesn't recognise all the data. none of the headings are just numbers. Attached is a screenshot of the data I'm trying to import. Any ideas as to where I could be going wrong?

enter image description here

  • When importing a delimited text layer, there is an option called "First record has field names". Was this checked?
    – Joseph
    Commented Aug 20, 2015 at 10:19
  • Since you work on a mac: Possible duplicate of gis.stackexchange.com/questions/137260/… and gis.stackexchange.com/questions/76142/…
    – AndreJ
    Commented Aug 20, 2015 at 10:23
  • Yeah the First record has field names was checked. It puts all the headings on and then loads more as 'fields' and then says at the bottom that there is 'no data found in file'... I'm very confused. When I try and import other files the data is just immediately recognised which is why I thought it must be something wrong with the excel file I made. Commented Aug 21, 2015 at 16:13
  • perhaps one of your fields has a comma, and this is what's causing the problem. perhaps try saving it as tab separated or as pipe (|) separated. Commented Aug 21, 2015 at 17:26
  • 1
    I've realised it was because I needed to save it as a 'windows comma separated' values file, not just a .csv file. Thankyou for the links Andre! Commented Aug 21, 2015 at 17:30

1 Answer 1


Asker "needed to save it as a 'windows comma separated' values file, not just a .csv file" which also solved the problem for me.

Your Answer

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

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