The New Geography Data Type in Excel: Let's Play With It

Data Types were recently released for certain Insiders and in this video I play with the Geography Data Type to show you some strengths and weaknesses to help prepare you if you don't have the Data Types already.

Some things we see:
- We can't copy-paste-as-values to get rid of the Data Type and keep the value
- The Geography Data Type tries to fix things for us; e.g., it converted "Zion, IL" into just plain "Zion."
- From a Data Type we can get population, city name, and mayor info.
- We can't concatenate Data Types.
- We can get city names from a zip code ... mostly. Some zip codes returned simply "Postal Code in the United States. But if you have to look up 10 instead of 200, hey! There's a lot to appreciate.

Finally, I look at what happens if I open a file that has Data Types, but the version of Excel doesn't have Data Types?

Check it out!

My book: Guerrilla Data Analysis 2nd Edition

#ExcelDataTypes
#GeographyDataTypes
#DataTypes

[QuickMadeUpName]

Very interesting. Good examples and run through.

[barttitulaerexcelbart]

Thank you Oz for exploring this for us. Promising technology, but at this moment it will not be rolled out on massive scale...

[vladislavkostin]

Never knew Excel had such capabilities!

[entertainmentgalaxy]

very informative and will save great amount of time and avoid to get data from different google data sources.

Thanks OZ and excl on fire for sharing such a beautiful video

[josebetancourt]

Hi thanks for your video! I visited the microsoft insiders and I saw that an a stock data type is available! Hope to see an example about it from you soon!

[lmk]

Just went through lynda Get and Transform. Unpivot is really nifty. Powerful tool.

[rrrprogram]

Thanks for something now... Donno how i am gonna use it... My excel doesn't habe those options yet

[willyamkartonosuyanto]

Sir, this type of geography data.. Will it work with excel 2019?