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

About this tutorial:

Video duration: 10:31
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…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

6 thoughts on “The New Geography Data Type in Excel: Let’s Play With It

    Vladislav Kostin

    (May 15, 2018 - 4:52 pm)

    Never knew Excel had such capabilities!


    (May 15, 2018 - 4:52 pm)

    Very interesting. Good examples and run through.

    RRR program

    (May 15, 2018 - 4:52 pm)

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

    Haider Ali

    (May 15, 2018 - 4:52 pm)

    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


    (May 15, 2018 - 4:52 pm)

    Thanks for the stock of Geography : )

    Bart Titulaer

    (May 15, 2018 - 4:52 pm)

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

Leave a Reply

Your email address will not be published. Required fields are marked *