Forum Discussion

AK90712's avatar
AK90712
Copper Contributor
Apr 25, 2020

geography

I have downloaded CSV data from The COVID Tracking Project into excel.  The states are shown as the 2 letter abbreviation.  I have been able to use this to retrieve information from that state, using the geographical data app.  This has worked well for the most part, however now some state abbreviations taken from Bing now return a country rather than the state.  For example MO should return Missouri, however it now returns Moldovia.  If I type in MO and apply the geography data, it will return Missouri.  I haven't been able to resolve this issue.

 

Any thoughts?

Jim

excel

1 Reply

  • wumolad's avatar
    wumolad
    Iron Contributor
    Apr 25, 2020

    Hi AK90712 

     

    You can format the data as a table and then select the column before clicking on the geography format.

     

    It worked for me. The MO is now showing as Missouri. See the attached file.

     

    Cheers

Resources