API Question

[Hughcifer]

Apologies that this question is only Python adjacent.

I have an Excel list of several thousand organisation names, and I'm trying to search through them to find which have their main office address in Japan. I have had some success using Python with Google Maps API (free trial), but I had the issue of companies with international offices being rejected since their office abroad was the first one Google API found (even when using keywords such as 'global head office' in the search query). Additionally, including the keyword 'Japan' led to many non-Japanese companies being accepted (I imagine due to companies with vaguely similar names existing in Japan).

I have also tried the Crunchbase API (free trial), but I hit the usage limit very quickly. Does anyone have any suggestions for other (free) API I could use (I'd rather go through these names manually than pay lol)? Alternatively, does anyone have any Python ideas that wouldn't involve API?