Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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.

share|improve this question
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. –  Gerardo Jimenez Jun 25 '13 at 0:22
Check this also gis.stackexchange.com/questions/31314/… –  Gerardo Jimenez Jun 25 '13 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 '13 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... –  Gerardo Jimenez Jun 28 '13 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 '13 at 12:50
show 2 more comments

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.