I have seen all the questions for how to export an attribute table to Excel from QGIS, and I try all the answers like copy paste, CSV (in fact this I do not know where to find), but none seems to be the right answer.
Can anyone help me?
QGIS Export – How to Export Attribute Table to Excel from QGIS
attribute-tablecsvexcelexportqgis
Related Solutions
If you open the attribute table,
open an empty excel spreadsheet,
Select all or some of the records in the attribute table.
to select all the button in upper left gives this pulldown to accomplish that.
right click on the left edge (on a box).
copy selected.
Switch to the spreadsheet. right click in the upper left cell (just one cell)
ctrl+V (paste).
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
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
Formatoption list and chooseMS 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.