Look up Canadian Postal Codes Using Street Address

[Postmaster]

I have an Excel database that contains over 3000 Canadian street addresses, but I am missing the postal codes for these addresses. Is there anyway to automatically look up the postal codes for all of these addresses? Please HELP!!!

Thanks

 

[Michael M]

My guess from the info provided is NO !!
You would need to have something connecting the address (including town) with the Postocde listed somewhere....maybe a website list of the towns/postcodes That you could download !!!

 

[Logit]

.
.
Here is a resource ... but its still a manual process unless you can automate it:

Resource website: Postal Codes Canada


Text File :

https://www.amazon.com/clouddrive/s...Y0G5aLJZKmCM1EeXLZ?ref_=cd_ph_share_link_copy


Excel workbook :

https://www.amazon.com/clouddrive/s...cblBkHrhJJyvQ14VR8?ref_=cd_ph_share_link_copy

 

[Michael M]

Don't know what the dataset looks like, but it could be used along with a VLOOKUP to recover the postcodes to your data

https://www.aggdata.com/free/canada-postal-codes