[GIS] Add x y data from existing attribute table

qgis

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.

Best Answer

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.

Related Question