Friday, 21 August 2015

Exporting attribute table to Excel from QGIS?


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?



Answer



UPDATE 13.10.2016:


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].


I'm using QGIS v.2.14.4




PREVIOUS ANSWER (still valid):




  1. Install the XY Tools plugin by Richard Duivenvoorde.




  2. Select a vector file from the ToC (that is, make it active).





  3. Go to Vector->XY tools->Save attribute table as Excel file.




enter image description here


You would need the Python library xlw installed for doing so.


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...