Getting The Exact Address Of Companies With The Following Data: Company, City, State; What Is My Best Option?

Hi all,

I’m currently trying to merge 3 lists of together over 30.000 rows with companies, to make sure I can delete the duplicates I want to merge the companies sin one list with one similar cell for all, the exact address or coordinates.

I’ve tried using bing maps API, but after checking it doesn’t show up correctly. What I can do is go into google maps an manually put in the company, state & city and then copy the address but doing this for 30.000 rows will take me years.

What would my best option be to do this? I’m advanced with Zapier & Power Automate.

Many thanks!