Geocode from addresses to latitude / longitude, using Nominatum API.
Try the macro out on a Test Sheet with sample address data.
Unfortunately, you've got to add this script to each sheet you are using.
This tool supports geocoding using address data spread across multiple columns.
The way this works is: You select a set of columns containing the data, and the geocoding process puts the latitude, longitude, and OSM URL data in the rightmost three columns. It will overwrite any data in those three columns.
Some care is needed, as it will concatenate all columns except the rightmost three columns to create the address string.
Original code is here: https://github.com/nuket/google-sheets-geocoding-macro
This is a fork with some modifications to migrate from Google geocoding to OSM Nominatum.