[GIS] way to quickly paste multiple columns of data into an attribute table in QGIS

qgisqgis-2

So I have a shapefile with 133 rows of data, and I want to add 4 extra fields to it. My problem is that after I have created the new fields in the attribute table, I have no way to quickly paste the data for these columns from my spreadsheet. Can someone show me how to do this?

Best Answer

Save the spreadsheet as .csv (text) and open it using the CSV button in QGIS. You can then define a join in the properties tab of the shapefile. This will allow you to choose which columns to add to the shapefile. Finally you can save the shapefile using Save As to make the change permanent if required.

Related Solutions

QGIS Attribute Table Not Displaying Data – Troubleshooting Guide

Under Settings->Options->General (a bit down the panel) I have a dropdownbox "Behaviour of Attribute table" (or whatever it is in your language).

After switching that to "Show All Objects", I see them in the table. It looks like that overrides the checkbox in the attribute table itself.

[GIS] Added columns in SpatiaLite won’t appear in QGIS (attribute table)

though this question has been out there awhile, i wanted to post what seems to have worked for me (which sounded almost identical to the OP question). Following the bug report from http://hub.qgis.org/issues/8923 to https://groups.google.com/forum/#!topic/spatialite-users/FOq1DPRDkJw, i tried the following (python implementation):

    conn=sqlite3.connect(dbPath)
    conn.enable_load_extension(True)
    cursor=conn.cursor()
    cursor.execute('SELECT load_extension(\'/usr/local/lib/mod_spatialite.so\');')  
    sql = 'SELECT UpdateLayerStatistics(\'myTableName\');'
    cursor.execute(sql)

and the new column magically appeared in the QGIS attribute table.

Best Answer

Related Solutions

QGIS Attribute Table Not Displaying Data – Troubleshooting Guide

[GIS] Added columns in SpatiaLite won’t appear in QGIS (attribute table)

Related Question