How to get Shapefile point coordinates into .xls?

Question

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.

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

Curlew · Answer 1 · 2013-02-06 11:39:19Z

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.

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.
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
@surftrial Please accept the answer if your problem is solved

1 Answer