Fetch postalcode from address missing postalcode

[casparvervuurt]

Hi Everyone,

I have a list of addresses that I want to fetch the postal code of, I have been trying in google sheets and excel but I cannot seem to find a solution as to how to fetch the postal code. All the addresses are in The Netherlands and of every address I have the Street, housenumber and the city. Is there any way to fetch the postalcode via VBA? I would like to be able to do it in the future, so if you have any help please let me know!

Thanks in advance!

Caspar

[KOKOSEK]

If you know any website where we can use API to find out post code by address, that could be one of possible solution (this https://www.postcode.nl/en/services/adresdata/api look nice)