Importing File From Excel into ArcGIS Gives NULL Data in Fields

28171
14
08-10-2011 01:35 PM
GradyMorrison
New Contributor
I am attempting to import the attached excel file into ArcMap so that I can use the table's address fields in order to geocode the field locations in order to create a shapefile of this data. When I import this file in, I get the heading field to load fine, but all the attribute data in the fields is <Null>.  Is this a excel formatting issue that I cannot seem to locate? Or am I going about this in an incorrect manor?

Thank you for your time, and any help is great appreciated!
Tags (2)
0 Kudos
14 Replies
JoeBorgione
MVP Emeritus
I have done the reading of the char. and spaces and while joining it STILL is fill with <NullLs
HELP please


Are you joining a spread sheet to a table or importing a spread sheet to a table?

Either way, make sure the FIELD names don't have spaces or special characters.
That should just about do it....
0 Kudos
JacquelineRyssman
New Contributor
I am having a similar problem. Under my waypoints field the values containing both alpha and numeric characters show up as null in arcmap. I have tried just about everything in formatting and I am at my wits end. Help me. I have attached the problem file as well as highlighted the waypoints which are reading as null in arcmap
0 Kudos
JoeBorgione
MVP Emeritus
I am having a similar problem. Under my waypoints field the values containing both alpha and numeric characters show up as null in arcmap. I have tried just about everything in formatting and I am at my wits end. Help me. I have attached the problem file as well as highlighted the waypoints which are reading as null in arcmap


Your spreadsheet is the problem.  You've got mixed and matched formats in the same column.  Some are true numeric, while others should be treated as text (those with Alpha characters imbedded).  I suggest you create a personal geodatabase, and create a table with the following fields:  XCoord(double), YCoord(double), Waypoint(text).  Load your excel data into that and go to work.
That should just about do it....
0 Kudos
JacquelineRyssman
New Contributor
Your spreadsheet is the problem.  You've got mixed and matched formats in the same column.  Some are true numeric, while others should be treated as text (those with Alpha characters imbedded).  I suggest you create a personal geodatabase, and create a table with the following fields:  XCoord(double), YCoord(double), Waypoint(text).  Load your excel data into that and go to work.


Thank you for your help. It worked perfectly! I greatly appreciate it.
0 Kudos
PaulSmithson
New Contributor

I've had a similar problem as Grady Morrison. A .xlsx file containing text strings with spaces imports as <null>. I converted the file to .csv and ArcMap imported the strings including spaces without a problem. I'm not sure why that works, but it did work for me.

0 Kudos