This video provides a how to geocode addresses in Excel using a publicly available VBA code.
You will need to create a google account and set up the billing information.
Links:
https://myengineeringworld.net/2014/0...
https://myengineeringworld.net/2018/0...
https://developers.google.com/maps/do...