Importing File From Excel into ArcGIS Gives NULL Data in Fields

23987
13
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)
Reply
0 Kudos
13 Replies
GradyMorrison
New Contributor
Here is the attachment --
Reply
0 Kudos
VaishaliRaut
New Contributor II
Hi Graddy,

Please check the attached excel sheet and let me know the result.
Thanks!

Vaishali.
Reply
0 Kudos
GradyMorrison
New Contributor
Perfect. That seems to have solved the issue. How did you change that xls file so that it was able to import correctly?  If I could have the process you used I would really appreciate it!

Thanks for your time!
Reply
0 Kudos
VaishaliRaut
New Contributor II
Hi Graddy,

I simply removed the spaces from the excel. In GIS when excel comes into role, taking care of spaces and special characters in it would always give you correct and faster result.

Thank you!
Vaishali.
Reply
0 Kudos
KyleLeissner
New Contributor
How do you remove the spaces in excel? Is there an easy automated way?
Reply
0 Kudos
RuthEmerick
New Contributor II
How do you remove the spaces in excel? Is there an easy automated way?


Use Find/Replace in Excel. In the Find box, type a space. In the Replace box, don't type anything. Press "Replace All."
JeffWard
Regular Contributor II
Use the TRIM function.  In a new column click on the first cell and click on the Insert Function button in the formula bar (fx).  Enter TRIM in the search field and select TRIM from the results.  Then enter the cell reference or choose the cell selector (grid looking tool to the right of the argument entry box).  Then click OK.  You can copy and paste that formula to the rest of the cells in that column.  But I think you will then have to select the entire contents of that column you just created and copy it.  Then go to the next empty column at the top and right click then select "Paste Special" and select "Values" from the choices.  Then you can delete the column with the formula in it and what you have left is a column with the trimmed text values.  ArcMap probably won't handle a formula in a cell.

Hope that helps.
Jeff Ward
Summit County, Utah
Reply
0 Kudos
Della_RaeHaesler
New Contributor
I have done the reading of the char. and spaces and while joining it STILL is fill with <NullLs
HELP please
Reply
0 Kudos
JoeBorgione
MVP Esteemed Contributor
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.
can't wait to retire....
Reply
0 Kudos