Sign up ×
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

2 Answers 2

  • 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


  1. Select the layer you would like to export csv with XY values
  2. Click browse, and select the location where you would like your file to be stored, give it a name;
  3. In your Layer Option of your "Save Vector as" window select Geometry as XY
  4. Click OK

Not sure if that was what you were after, the other Option could be


  1. Click on the shape layer you would like to generate x and y values
  2. Click on the Open attribute icon
  3. Click on the Open field calculator icon
  4. Check the create a new field
  5. Write your new field name (eg. x)
  6. Select in your Output field type Decimal number
  7. In the function search box write $x (it should be under Geometry)
  8. Double click (it should now show up in the expression)
  9. Click OK

You should now have and X column. Do not close the Attribute table, repeat step 3 to 9, changing step 5 by naming your column y and your step 7 by writing $y. You should have generated the X and Y values you required.

Hope it works..

share|improve this answer

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.