Inputting an Excel column in a new field added to the attribute table

JulietHook

I used the Excel to Table function to plot around 132 paired coordinates along with their associated data fields. I want to add another column in the existing attribute table that was originally created in this Excel to Table function. I can add the column. The data that I have copied and pasted from Excel to this new column will not  format correctly. My issue is that blank spaces are not inputting. So, it wont leave a row blank when pasted when there is a blank row in the excel file. 

In my screenshot attached, you can see there is a blank field in row 2, in the B column. When I copy and paste into the attribute table column from Excel, it will format the data as if there is no blank field so that the "China Lake Fa" jumps to row 2 and becomes incorrectly associated with row A 5152. How can I fix this? Typing in <Null> has not worked because it doesn't actually recognize that as an empty field when I query the data.

Thank you!

Excel Error- Null Field.jpg

settings.png

jcarlson

With so few values, it probably wouldn't be too terrible to manually fix it. Fill your blank fields in Excel with a value like "zzz".

Once your table is imported, you can use Select by Attributes to select all of those features, then set the attribute to Null from the Attributes pane.