topic Excel Data into ArcGIS in Data Management Questions

Excel Data into ArcGIS

MoniqueDawson — Mon, 27 Jan 2014 17:56:47 GMT

Hi all,

I am trying to import/attach excel data (MaxTemp, MinTemp, precipitation) to a multi-point shapefile. Is there a faster way of doing it other than editing each point shapefile attribute table?

MO

Re: Excel Data into ArcGIS

JoeBorgione — Mon, 27 Jan 2014 18:02:44 GMT

Hi all,

I am trying to import/attach excel data (MaxTemp, MinTemp, precipitation) to a multi-point shapefile. Is there a faster way of doing it other than editing each point shapefile attribute table?

MO

I take it you have a common item between the two tables right?

My personal approach would be to create a database table from the excel data. And, assuming that when you say shapefile you really mean point feature class, you should probably put the the excel data into the same database as your points. Then use a relate to see what data go with what points, via the common item.

Re: Excel Data into ArcGIS

MichaelVolz — Mon, 27 Jan 2014 18:03:17 GMT

You could try python scripting to convert the Excel data to a table and then using joins to get the data from Excel into the shapefile.

I would also suggest moving the data to a file geodatabase and performing the data manipulation there as it is less buggy than shapefiles.

Re: Excel Data into ArcGIS

MoniqueDawson — Mon, 27 Jan 2014 18:16:40 GMT

I take it you have a common item between the two tables right?

My personal approach would be to create a database table from the excel data. And, assuming that when you say shapefile you really mean point feature class, you should probably put the the excel data into the same database as your points. Then use a relate to see what data go with what points, via the common item.

The problem is that the excel data does not have the same field as the point shapefile. The point names of each point matches the ID field in excel data instead. I would have to add a field that would link them so I can perform a join

Re: Excel Data into ArcGIS

MichaelVolz — Mon, 27 Jan 2014 18:19:15 GMT

Are you going to perform this operation often with data updates from excel that need to be added to the shapefile (or file geodatabase feature class if you go with that format)? If so, I would script this process out.