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

6
18




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…

6 COMMENTS

  1. 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

LEAVE A REPLY

Please enter your comment!
Please enter your name here