Import excel fields into feature class attribute table

[GlenLengyel]

Hello all!

I have an excel spreadsheet with approx. 1700 records. Each record has 5 fields that need to be updated in my feature class. Right now I have to enter editor mode and manually select each option from a dropdown for every record. I would love to write a Python script to automate this process. Does anyone have any ideas on some syntax or can point me in the right direction to help make this process go faster? Is there anyway I can iterate through each column and copy the records from excel to the attribute table?

Regards,

Glen

Here is a picture below as reference...

[DarrenWiens2 · Accepted solution]

Join the Excel sheet to the feature class based on "INT_ID" (provided that is a unique ID) and use the Field Calculator to transfer the values from Excel to feature class.

[GlenLengyel]

Thank you so much! I knew there was a way around it. I appreciate your response.

Glen