I've got an Excel file which includes known locations with their exact address (street, house number, city, state). This Excel file does not have a geographical column. Also, I have a .shp file inside those boundaries of buildings.

I want to relate every address in the Excel file to a building from the .shp file in order to represent to the .xls file on a map and for further analysis.

Couldn't find a way to do it in QGIS. Any ideas?

I've got an Excel file which includes known locations with their exact address (street, house number, city, state). This Excel file does not have a geographical column. Also, I have a shapefile inside those boundaries of buildings.

I want to relate every address in the Excel file to a building from the .shp file in order to represent to the .xls file on a map and for further analysis.

Couldn't find a way to do it in QGIS. Any ideas?

I've got an excel file which includes known location with their exact address (Street, house number, city, state). This excel file does not have any geographical column. Also, I have a shp file inside those boundaries of buildings.

I want to relate every address in the excel file to a building from the shp file, in order to represent to the xls file on a map and for further analysis.

Couldn't find a way to do it in QGIS. Any ideas  ?

Thanks, Lauren.

I've got an Excel file which includes known locations with their exact address (street, house number, city, state). This Excel file does not have a geographical column. Also, I have a .shp file inside those boundaries of buildings.

I want to relate every address in the Excel file to a building from the .shp file in order to represent to the .xls file on a map and for further analysis.

Couldn't find a way to do it in QGIS. Any ideas?