

Arc reads the first few rows of a Excel sheet in order to assign data types. If the first few rows of the Excel sheet have empty cells in them this can confuse Arc.

Underscores rule_the_roost here if you do need to separate words for readability. Don't use special characters (headings like are too special). Keep the number of characters low (I always aim for no more than 13). Let's have a look at a few possibilities and their solutions: 1 field headingsĪrc doesn't like fancy field (column) headings. They were there in Excel but had now vanished! The Null bells were tolling. I was approached recently as user had imported and Excel file into a geodatabase but then could not see the coordinates. Importing such a monster to a geodatabase can cause untold problems. It could be any version of Excel, it could be correctly formatted with notes, front page instructions and a glossary OR it could be have been put together by a digital Dr Frankenstein.

Often for the GIS guru (you) it'll be from Excel.
