Finding Google Plus Codes for a database with addresses without VBA

I have a simple database with customer name and address. I would like to have a formula or method to look up the Google Plus Code for the addresses listed. I have NEVER used VBA and quite frankly, it scares me to try. But if I could get some expert opinion on how to best accomplish this goal, it would be greatly appreciated. See the attached file. Thanks to all that step in to help!

If you have all your addresses and associated GPCs in a list it would be relatively straightforward to use VLOOKUP or INDEX/MATCH to return the GPC for a selected address.
It's not clear from your file what your expected output is. Perhaps it would be helpful if you could update it to show what your desired results are?

BSB

Thank you for your reply!! It is appreciated!! I do not have the GPC for all of my addresses. Finding the GPC is what I am hoping to automate. What I have been doing is: I have been going to the company's website, looking up the address, finding and copying the GPC, then returning to my Excel file and pasting it beside the address. I was hoping there was a way to have excel automatically look up the GPC by using the address given. Maybe I am asking too much from Excel but I thought I would try before I kept doing the boring and laborious job of going back and forth cutting and pasting for these 1,000 addresses I have.

I did a little more research on this. Google provides a Web API for Plus Codes. You can easily implement a WebAPI in VBA using MSXML 6.0. Example below. You embed the address in the url. You need to encode address string like substitute + for space. You also embed the your encrypted key and email address. You need to have an account with Google Maps to get your key. I don't have Google Maps account so I wasn't able to test it.

Please Login or Register  to view this content.