How do I add or append excel data to an existing attribute table?
The excel column headings will match the attribute table headings (in name at least). Simply want to expand the attribute table without having to manually type all the data in.
[GIS] Adding Excel data to attribute table
arcgis-desktopattribute-tableexcel
Related Solutions
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
Kind of hard to know, but you need to use a shortcut, CTRL+SHIFT+C, which would
Copy the selected records onto the clipboard.
Best Answer
Add both the excel and feature class (incl. attribute table) to the map. Then join them together and export as a new feature class. Example below for ArcMap. (To join right click on layer in tree - Joins and Relates)