I've imported an Excel spreadsheet into ArcMap 10.5 and one of the columns entirely populates with NULL values. That column is just "reference numbers" so its just numbers from 1-180 in increasing value.

Does anyone know why this is happening and a possible workaround?

  • 1
    In Excel, select the number from 1 - 180, go to Cell Properties and choose Number instead of General and click OK. Then import the excel file again into ArcMap. Sometimes ArcMap does not like General format of the cell and need to explicitly format the column as Number – ahmadhanb Jul 26 '19 at 12:54
  • I tried that, still doesnt work :/ – Emma Pascoe Jul 26 '19 at 13:07
  • What is the name of the column that contains the data? – ahmadhanb Jul 26 '19 at 13:09
  • Just to keep it simple I just made it Ref – Emma Pascoe Jul 26 '19 at 13:10
  • 1
    Is the first row your header (so ref in your case) and the second row number 1? If you have hidden rows/columns that messes things up. – Hornbydd Jul 26 '19 at 15:34

Here are two possible workarounds:

1) Populate the field with incrementing values again using Field Calculator. If you really need those values in ArcMap, go to field calculator and enter the following code block (taken from the ArcGIS Calculate Field Examples), making sure you specify Python as the parser:

def autoIncrement():
    global rec
    pStart = 1 #adjust start value, if req'd
    pInterval = 1 #adjust interval value, if req'd
    if (rec == 0):
        rec = pStart
        rec = rec + pInterval
    return rec

In the expression you should write: autoIncrement()

2) Delete the Ref column from the spreadsheet. If the resulting table in ArcMap contains a FID field, you would not need the Ref column as it contains the exact same values.

  • I will try the first option, but also worth noting when I import the spreadsheet, a FID field doesnt show up – Emma Pascoe Jul 26 '19 at 14:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.