[Qgis-user] Editing shapefile attributes in QGIS

[Alex Mandel]

Actually the issue is that Excel 2007 and later no longer allow Saving
DBF without add-ons (3rd party). Only LibreOffice or OpenOffice still
support that.

So yes if you can use Table Manager and built in tools to QGIS that
would provide less headache long term, manually adding columns to dbf is
a little tricky sometimes.

Alternately you can import an xls table and join it to an existing
shapefile.

Enjoy,
Alex

On 12/18/2014 12:14 PM, Basques, Bob (CI-StPaul) wrote:
> Paulo,
> 
> Well my first answer would be to suggest you simply open the DBF file up in Excel and edit it directly, as long as you leave the ID columns (to associate the attributes with the Geometries) alone you can do all that you describe.  But Excel no longer opens DBF files by default (or does it now, again?).  So, you should use OpenOffice or LibreOffice to open them, and then do the same thing in there.
> 
> Bobb
> 
> 
> 
> From: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Paulo van Breugel
> Sent: Thursday, December 18, 2014 2:09 PM
> To: David Bradley; QGIS user email list
> Subject: Re: [Qgis-user] Editing shapefile attributes in QGIS
> 
> You can do a lot with the Table manager (you can find and install this plugin via the plugin manager: menu --> plugins --> manage and install plugins).
> If that is not enough, you can of course always open the dbf file. I would recommend using LibreOffice/OpenOffice instead of excel as in my experience at least Excel can sometimes mess up the dbf file.
> 
> Paulo
> 
> On 18 December 2014 20:39:33 CET, David Bradley <dododave at gmail.com<mailto:dododave at gmail.com>> wrote:
> 
> Can someone point me in the direction of a better way to edit the data in a shapefile?
> 
> Basically I want to export what is already in there to Excel, edit it, and then re-import it. The editing I need to do is to move a few cells into another column, add several columns, and remove many other seemingly superfluous columns.
> 
> Thanks for any suggestions!
> David
> 
> ________________________________
> 
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org<mailto:Qgis-user at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>