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

284
4
Jump to solution
09-01-2021 01:12 PM
JulietHook
New Contributor II

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!

0 Kudos
1 Solution

Accepted Solutions
jcarlson
MVP Notable Contributor

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.

jcarlson_0-1630528652153.png

 

- Josh Carlson
Kendall County GIS

View solution in original post

4 Replies
jcarlson
MVP Notable Contributor

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.

jcarlson_0-1630528652153.png

 

- Josh Carlson
Kendall County GIS
JulietHook
New Contributor II

Hi Josh,

Unfortunately, I only used four to illustrate this issue for the screenshot but it will be closer to 1,000 or more rows to copy and paste. However, I could do them in batches. I can also check if the find and replace function will allow me to set this information to null with your method. Thank you for your help!

0 Kudos
jcarlson
MVP Notable Contributor

Yes, find and replace in Excel should work for getting the "placeholder" in, and then the rest of the process as described in Pro would take care of the rest. It sounds like a limitation in the Excel to Table tool, honestly. There are better ways to get tabular data into Pro if this is something you're going to do regularly. Exporting your table to a CSV, for instance, will include the empty values in a way that is correctly interpreted when the CSV is opened in Pro.

- Josh Carlson
Kendall County GIS
0 Kudos
JulietHook
New Contributor II

I hadn't thought to import as a CSV- that is a great idea. Thank you for your expertise!

-Juliet

0 Kudos