When i selected some portion of the map in QGIS, in the attribute table the selected features gets highlighted…
How to export the highlighted features from attribute table to an excel file automatically..?
[GIS] How to export highlighted features from attribute table to an excel file
attribute-tablecsvqgis
Related Solutions
QGIS v3.x
Right click on the layer in the Table of Contents (aka. legend or layer tree) and open the Save As... dialog.
Once there, click on the Format option list and choose MS Office Open XML spreadsheet [XLSX].
Note that you also have an option for Libre Office files: Open Document spreadsheet [ODS].
ORIGINAL ANSWER (no longer valid):
Install the XY Tools plugin by Richard Duivenvoorde.
Select a vector file from the ToC (that is, make it active).
Go to
Vector->XY tools->Save attribute table as Excel file.
You would need the Python library xlw installed for doing so.
I would do the following things to make life easier:
Before you do this, make a backup of your shapefile.
- In your shapefile, go to the layer properties / fields and turn on edit mode.
- select all Field except the ID field
- Delete all fields except the ID Field
- add your
csv file as a layer in QGIS (Main menu/Layer/Add Layer/ Add delimited text layer)
(choose no geometry) - in your shapefile, select properties/joins and choose both ID fields for source and target. As described in the other answer to this question.
- Save your modified Shapefile.
this is the Field tab I am referring to
Don't forget to toggle editing before and after deleting unnecessary field
Best Answer
Simply select the features on the map and use copy-paste (Ctrl + C , Ctrl + V) to copy the data into a text editor or Excel.