Shape Files and Excel Data

[gregburbidge]

Hi All,

I have a shape file that has city wards boundaries. I have an excel file with addresses, Lat/Long. I'd like to append the ward number in excel based on that shape file. Any ideas? I know if I was using ARCGIS this would be a snap, but I'd ideally like to find a workaround as we only run this exercise once a year so getting an ARCGIS license might not be the most economical way to do this.

Any ideas much appreciated!

Greg

 

[AFPathfinder]

From my cursory research on shapefile, I don't think Excel can natively read those types of files. You would need a third-party software solution to load the table data into Excel or a geospatial system that can export the data into a csv-like format like ArcGIS.