Hoping this is in the right section. I have several shapefiles that I need to pull the attribute tables from, data cleanse in Excel and then load back up to ArcGIS as a single file. I have modified the attribute tables to create a decimal degrees longitude and latitude in British National Grid co ordinate system, same as all my features and maps. If I try and then upload the data back to ArcGIS, by adding the Excel file to the map and using the Display XY Data pop up, the data is drawn miles out on the map and all the data points are clustered together.
I have looked around various forums and can't work out what I'm missing, so any advice would be appreciated.
I have looked around various forums and can't work out what I'm missing, so any advice would be appreciated.
Most issues with dispaly of data from excel run into problems because of:
Incorrectly defined coordinate system (or defining the desired instead of the source coord system)
Negative vs Positive longitude values (or vice versa in the eastern hemisphere)
No transformation specified
(for no display of data)
column begins with Number
Illegal Character in column name (ie: -,# % .)
Spaces in column name
Incorrect data type (ie x y coord is of type text)
If none if these apply,
post a sample of your data for a more targeted reply.
Best Regards,
Jim