+ Reply to Thread
Results 1 to 13 of 13

Thread: Importing File From Excel into ArcGIS Gives NULL Data in Fields

  1. #1
    Grady Morrison
    Join Date
    Aug 2011
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Importing File From Excel into ArcGIS Gives NULL Data in Fields

    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!

  2. #2
    Grady Morrison
    Join Date
    Aug 2011
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    Here is the attachment --
    Attached Files

  3. #3
    Vaishali Raut
    Join Date
    Aug 2011
    Posts
    2
    Points
    0
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    Hi Graddy,

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

    Vaishali.
    Attached Files

  4. #4
    Grady Morrison
    Join Date
    Aug 2011
    Posts
    4
    Points
    0
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    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!

  5. #5
    Vaishali Raut
    Join Date
    Aug 2011
    Posts
    2
    Points
    0
    Answers Provided
    0


    -1

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    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.

  6. #6
    Kyle Leissner
    Join Date
    Aug 2011
    Posts
    2
    Points
    1
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    How do you remove the spaces in excel? Is there an easy automated way?

  7. #7
    Ruth Emerick
    Join Date
    Feb 2011
    Posts
    36
    Points
    1
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    Quote Originally Posted by kleissner View Post
    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."

  8. #8
    Jeff Ward
    Join Date
    May 2010
    Posts
    141
    Points
    8
    Answers Provided
    1


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    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

  9. #9

    Join Date
    Jun 2012
    Posts
    1
    Points
    0
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    I have done the reading of the char. and spaces and while joining it STILL is fill with <NullLs
    HELP please

  10. #10
    Joe Borgione

    Join Date
    Apr 2010
    Posts
    1,140
    Points
    307
    Answers Provided
    31


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    Quote Originally Posted by dxhaesler View Post
    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.
    Joe Borgione
    AlpineGeographic

    If the suggestion I provide helps solve your problem, please feel free to give it a favorable review by clicking the up arrow. That's only only reward I get for sharing 20 + years of professional GIS experience.

  11. #11
    Jacqueline Ryssman
    Join Date
    Apr 2013
    Posts
    2
    Points
    0
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    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
    Attached Files

  12. #12
    Joe Borgione

    Join Date
    Apr 2010
    Posts
    1,140
    Points
    307
    Answers Provided
    31


    1

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    Quote Originally Posted by ryssmanj View Post
    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.
    Joe Borgione
    AlpineGeographic

    If the suggestion I provide helps solve your problem, please feel free to give it a favorable review by clicking the up arrow. That's only only reward I get for sharing 20 + years of professional GIS experience.

  13. #13
    Jacqueline Ryssman
    Join Date
    Apr 2013
    Posts
    2
    Points
    0
    Answers Provided
    0


    0

    Default Re: Importing File From Excel into ArcGIS Gives NULL Data in Fields

    Quote Originally Posted by jborgion View Post
    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.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts