current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite

I am wondering if there is a way to join the attributes from excel tables to shapes in Qgis. I have abbreviations in the shape and want to add the associated complete names from excel file by automatically join. The abbreviation is also given in an excel column. Once there was a tool "join attribute" that is missing now. I tried to join by using properties/ join but then it is only possible to choose shape-files. Thank you for your help!!

andreas

share|improve this question

3 Answers 3

up vote 3 down vote accepted

Adding to @Rob Lodge 's answer above. you can directly convert excel file to .csv format and there is a plugin called mmqgis here you can add attributes join from .csv file . i think this may help you if your shapefile dosent have latitude and longitude as seprate fields in excel. enter image description here

share|improve this answer
    
thank you, that is a good way. I tried it with a test datset and it works. Sadly not with the dataset that I want to merge..there seems to be something wrong with data format in the table.?? but this would be a different question thank you! –  oppia04 Sep 18 '13 at 12:18
up vote 0 down vote

Enable the fTools plugin and use Vector > Data management tools > Join attributes by location

share|improve this answer
    
thank you for reply, the data in the excel file are no spatial data so there is no way to join them by location. –  oppia04 Sep 13 '13 at 8:29
2  
You could open the shapefile in excel (convert to .csv format in QGIS), and simply merge the two datasets that way. Then export the .csv as a Text (Tab delimited) file, and open it in QGIS that way with Layer > Add delimited text layer. You can use the spatial reference from the shapefile as in the X Y fields on the import menu. Should work. –  Rob Lodge Sep 13 '13 at 8:42
    
Spatialite can load an excel 2003 (*.xls) format spreadsheet as a database table. So if you import your shapefile into Spatialite, and load the excel table, you can easily do the join. –  Micha Sep 13 '13 at 9:19
    
this is sorry pretty complicated, to walk the way by foot, wonder if there is a more convenient option... –  oppia04 Sep 13 '13 at 10:51
up vote 0 down vote

I just had the same problem and mmqgis only gave me error messages ("no matching records found"), but here is another solution to the problem that worked perfectly for me.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.