I have created polygon centroids using one of the "Geometry Tools" but I would like to extract the actual coordinates into Excel for further work. Is this possible?
Create 2 new columns (x and y) type real. In field calculator use option update existing field and execute following expressions:
$x (for x column) and
$y (for y column). Actually you can create new columns in field calculator directly using create new column option. Now you can export your layer as CSV (save layer as) and work with it in Excell or whatever you like.
Here is a lazy way of getting the coordinates.
- Select all features in the centroids layer using selection tools.
- Press Ctrl+C to copy it to clipboard.
- Open Excel. Press Ctrl+V to paste data to clipboard.
You get the Well Known Text(WKT) of the features in the
'wkt_geom' field in Excel as shown below. This is a great way to pull the WKTs out of features.