0

enter image description hereI have a spread sheet with coordinates that once I bring in to Arcmap, the attributes disappear. The points are on the map, and when you Identify each point, the data shows up, but when the attribute table is open, the attribute titles are there, but no data below them. I have another table with data that comes in as it should. I was able to Display XY data and reproject, and the attributes showed up, but then there was only one point on the map (there is a total of 15). I've attached a screenshot of the excel table, but let me know what other info is needed.

  • The column names might be causing issues. Try simplifying them by removing punctuation and spaces just to see if that's the issue. Also, if commas (,) are your delimiter, make sure your cell values are surrounded by double quotes (") if your cell values contain commas. – alexGIS May 4 '16 at 15:57
  • Does the table data display BEFORE you display X, Y locations as points on the map? – alexGIS May 4 '16 at 15:58
1

Here is a very useful ESRI blog you (and anyone else) who intends to link data held in Excel with ArcMap should read. It explains the many pitfalls there are with Excel.

I personal avoid using Excel like the plague and get my data into personal geodatabase which is essentially a spatial enabled Access database. Much easier to read and write from and you have ObjectID fields.

| improve this answer | |
1

Be sure of the type of your columns (date sometimes crash) and their names (no space, no special characters). It could also be the encoding (make a try with UTF8.) or your csv delimiter.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.