Mass updates to a status column

I have a large board with about 40 columns and 8000 items, that I need to do a mass update to a status column (there are 4 statuses to match the process) which I will need to update that status. I will use the code column (text) as my item reference. I will have a list of 100 codes that I need to update the status. Sometimes the field will have a value to be replaced and sometimes there is no value. How can I do this without manually looking up and updating status one by one? Is there an upload option to update a column or AI or integration I can do?