I have an excel sheet of precipitation data of each month of some districts. I have also the shapefiles of these districts. How can I represent this data in these shapefiles.
2 Answers
well, if the excel and the shapes have a field in common you can join the excel to your shp. If not you can make a common field between them and do the join.
In ArcGIS 10.2 for Desktop this is a two step process:
- Use Excel To Table (Conversion) to convert your Excel file to a table (dBase or file geodatabase)
- Use Join Field (Data Management) to join the contents of your table to your shapefile based on a common attribute field.