In Quantum GIS, I already imported an excel or dbf table. Now I need to tell Quantum GIS which columns are Latitude and Longitude. How do I do that?

I know there is Add Delimited Text Layer which allows that, but it seems Unreasonable to me to convert XLS or DBF file to text file before importing! There must be some direct way of telling QGIS that these parameters of the imported attribute table are actualy x y data.

  • 1
    If you are using 1.8 try the xy tools plugin (check all the rquirements). It opens xls files. By the way, is not that difficult also saving an xls file as a csv comma delimited. In either case you have to define in the first line the database structure. Jun 25, 2013 at 0:22
  • Check this also gis.stackexchange.com/questions/31314/… Jun 25, 2013 at 0:30
  • Well, does this mean that there is no way how to take coordinates directly from the attribute table in QGIS? Very clumsy!
    – Tomas
    Jun 28, 2013 at 8:14
  • On the contrary, there are two different ways. You can save your excel as a csv and use de "add delimited text layer"plugin. The second one is install the "XY tools" plugin (you can follow the instructions in the thread mentioned above). Both methods work fine. So there is no clumsiness in Qgis... Jun 28, 2013 at 12:46
  • @GerardoJimenez, I said "directly". You have already imported data to QGIS but to use them, according to these suggested solutions you must save them as xls/csv and import them again. Already imported data! This is really clumsy, isn't it? In no way it is direct and easy. I would expect that I could say to QGIS: "use these two columns of the attribute table as coordinates".
    – Tomas
    Jun 28, 2013 at 12:50

1 Answer 1


QGIS 3.0 has made it quite easy.

Use Create points layer from table tool (under Processing Toolbox | Vector creation).

enter image description here

Just assign X and Y fields and set appropriate Target CRS to reproject.

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.