I am reaching spreadsheet crisis point and need some help! 

I have spotted some inaccuracies in a spreadsheet where incorrect address information has been inputted for a list of venues- places in Yorkshire listed as being in Scotland etc. I have been trying to go through this manually to correct areas but it is really time consuming as there are over 1,000 records (and I am also aware that human error caused these issues in the first place!) I have been looking online to see if there is a tool that can generate a spreadsheet of addresses based off the postcodes we have but I can only seem to find ones that pull off County or City but not both together.

Ideally I want to get a spreadsheet that provides the City, County/Region and Country for the post codes we have. Any suggestions of a free online tool that could do this? Thanks in advance!