1

I have 2 datasets, a shapefile with postcode polygons and an excel table (.xls) with postcodes and building count.

How to represent the excel table in the map?

I know that in ArcGIS it's possible to add a table and then do a spatial join but no idea how to do that on QGIS. Or even just use the geocoding option

I downloaded the spreadsheet plugin and did a join, but I still wonder if there would be a better way of doing this

closed as off-topic by underdark May 20 '17 at 13:26

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This problem cannot or can no longer be reproduced. Changes to the system or to the asker's circumstances may have rendered the question obsolete, or the question does not include a procedure to enable potential answerers to reproduce the same symptoms. Such questions are off-topic as they are unlikely to help future readers, but editing them to include more details can lead to re-opening." – underdark
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 3
    Does your excel data contain any spatial data (e.g. coordinates, WKT etc.)? Note that you can either convert your .xls file to csv or use the Spreadsheet Layers plugin to import .xls files. If there are no spatial data then you can only join by matching fields from both the shapefile and the excel table. You can achieve this by right-clicking your shapefile and then: Properties > Joins; or from the Processing Toolbox: QGIS geoalgorithms > Vector general tools > Join attributes table. – Joseph Jul 1 '16 at 10:13
  • No geometry, actually I solved my problem by getting Spreadsheet layers and joining by matching the postcode columns. Still I feel that if I didn't have allmighty expensive postcode data then I would be screwed. – Luffydude Jul 1 '16 at 11:04
  • 1
    Awesome, you should post your comment as an answer. Hope your postcode data wasn't too expensive =) – Joseph Jul 1 '16 at 11:09