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-boun...@lists.osgeo.org > [mailto:qgis-user-boun...@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 > <dodod...@gmail.com<mailto:dodod...@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@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org> > http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user > _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
