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.

How can I get just Coordinates (in a file) from point features (shapes) without big hussle. Something like Shape to .xls, with distinct coordinates?

I want to use this coordinates immediately, so GPX is no solution.

Thanks in advance for your help.

share|improve this question
so you want to first remove duplicates and then export? –  underdark Feb 6 '13 at 11:18
there should be no duplicates inside, basically I want to export the coordinates in a useable file, from where I can easily grap the coordinates –  surftrial Feb 6 '13 at 12:16

1 Answer 1

  • Open your point shape in QGIS
  • Check that the projection is right and open the "Export/Add Geometry Values" function in the vector menu -> Geometry tools.
  • This will add two columns to your point shape containing the exact coordinates.
  • Now you can export the attribute table to a external program. Here the easiest ways to do that
    • Select all points and simply press CMD+C (Copy) and paste it into Excel
    • Use the mmqgis plugin (mmqgis -> transfer) to export the geometry or the coordinates directly. You'll get a comma delimited file (.csv), which can be opened in Excel.
    • The XY-tools plugin directly allows exporting to a xls File.
share|improve this answer
Hi Curlew, thanks for your guidance! As I intended to do the best fit, using XY-tools for deriving directly coordinates from the shape I'm experienceing some trouble with the python xlw and xlrd libs. –  surftrial Feb 6 '13 at 13:23
Guess i got it done! thx –  surftrial Feb 6 '13 at 14:09
You can also use the field calculator of the attribute table in order to calculate the coordinates. To do so the point layer must be in edit mode. Then save the shp file as a csv file –  Gerardo Jimenez Feb 6 '13 at 14:31
@surftrial Please accept the answer if your problem is solved –  underdark Feb 6 '13 at 16:29

Your Answer


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

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