Has anyone found a way to 'bulk update' organisation locations in the Location column either through AI or automations?

I have a list of about 500 organisations and I want to update the Location of each so I can do analysis based on region. Is there any quick way to get the Location column populated without entering each one manually?