UK postcode geography data types

%3CLINGO-SUB%20id%3D%22lingo-sub-2064282%22%20slang%3D%22en-US%22%3EUK%20postcode%20geography%20data%20types%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2064282%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20recently%20started%20using%20geography%20data%20types%20in%20Excel%20and%20they%20are%20so%20useful.%26nbsp%3B%20One%20thing%20I've%20not%20managed%20to%20work%20out%20though%2C%20is%20how%20to%20use%20UK%20Postcodes%20and%20make%20them%20into%20geography%20data%20types.%26nbsp%3B%20I%20can%20see%20lots%20of%20tutorials%20for%20how%20this%20works%20for%20US%20Zip%20codes%2C%20for%20example%20this%20youtube%20video%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DHiRLEG-NNKg%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DHiRLEG-NNKg%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20do%20that%2C%20but%20for%20UK%20Postcodes.%26nbsp%3B%20When%20I%20try%2C%20I%20just%20get%20question%20marks%20on%20the%20postcodes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2064282%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

I have recently started using geography data types in Excel and they are so useful.  One thing I've not managed to work out though, is how to use UK Postcodes and make them into geography data types.  I can see lots of tutorials for how this works for US Zip codes, for example this youtube video:

 

https://www.youtube.com/watch?v=HiRLEG-NNKg

 

I want to be able to do that, but for UK Postcodes.  When I try, I just get question marks on the postcodes.

 

Do

You have a bunch of zip codes (postal codes) in Excel. What can you do with those? Thanks to the new Office 365 Geography Data type, you can easily get the c...
0 Replies