Spring 2012 Edition
This article as a PDF.
How many times have you imported spreadsheet data into ArcGIS only to find some cells empty or formatted with an unwanted field type? To avoid these and other problems, follow these practices when creating and maintaining data in Excel you will use in ArcGIS.
ArcGIS reads the first 255 field characters. Fields with more than 255 characters are converted to BLOB fields and are not readable. Abbreviate, manually truncate, or split any fields longer than 255 characters.
ArcGIS typically converts spreadsheet numeric fields to double precision (Double), which may not meet your needs. If necessary, create new fields of the desired type and calculate values into them.
ArcGIS 10 uses the Lotus date/time format. In this format, the calendar date is represented by a whole number value that represents the number of days since January 1, 1900, plus one day (due to a bug in Lotus 123 and carried over to Excel). Time is represented as the decimal portion of a 24-hour day. If date/time data is important, format the input spreadsheet using a standard Excel date/time format.
The first row of an Excel worksheet sets the name for each column. Column names become field names when an Excel worksheet is imported into ArcGIS. Always follow these naming rules:
For more information, search ArcGIS 10.0 web help for Excel worksheet.