# Free Template w/ full details of every UN country

**URL:** https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467
**Category:** Community Resources
**Created:** [June 26, 2020, 2:25am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467 "2020-06-26T02:25:48Z")
**Posts on this page:** 13
**Page:** 2

<div class="post-metadata">

### Author: ![samwagner](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@samwagner](https://community.glideapps.com/u/samwagner)
#### Post date: [July 8, 2022, 2:54pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/22 "2022-07-08T14:54:00Z")

</div>

Hi Jamie.

I’m working on this project.

> [@Flags of the world](https://community.glideapps.com/t/flags-of-the-world/44118/2):
>
> Maybe this?

Would be great if I could get my hands on your sheet.

Would you mind sharing it with and the community?

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [July 9, 2022, 12:24am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/23 "2022-07-09T00:24:44Z")

</div>

Posted in here [Flags of the world - #3 by gvalero](https://community.glideapps.com/t/flags-of-the-world/44118/3)

---

<div class="post-metadata">

### Author: ![samwagner](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@samwagner](https://community.glideapps.com/u/samwagner)
#### Post date: [July 19, 2022, 10:56am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/24 "2022-07-19T10:56:43Z")

</div>

Thank you, @Jaime, that looks great!

However, when reaching out to grab this fantastic app, I get an error message that I don’t understand at all. How am I supposed to delete anything in a sheet that I don’t own yet?

 ![Screenshot 2022-07-19 at 12.54.24](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/a/8ae4bca1036e7afe0beb1519a7e5804141bba486.png)

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [July 19, 2022, 11:37pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/25 "2022-07-19T23:37:46Z")

</div>

Good question haha. I deleted the blank rows. Try again!

---

<div class="post-metadata">

### Author: ![samwagner](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@samwagner](https://community.glideapps.com/u/samwagner)
#### Post date: [July 21, 2022, 2:28pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/26 "2022-07-21T14:28:31Z")

</div>

So here’s what I actually wanted to achieve.  
Was just too dumb to explain 🙂

It’s an alphabetical list of countries together with their flags in one field.  
The flags are emojis so that you might use them in any text field.

Take advantage if it is helpful for you by making a copy of that list.

As you know, countries come and go. So make sure to update your list whenever they rearrange the world again. 🙂

> **[Countries and Flags](https://docs.google.com/spreadsheets/d/1IOgn69ZIAwDdhpyEsJ3EU23FLD5PKx5OqH5_v0LZ1Jg/edit?usp=sharing)**
>
> Countries
> 
> Raw,Country
> %🇦🇫 Afghanistan%,🇦🇫 Afghanistan
> %🇦🇽 Åland Islands%,🇦🇽 Åland Islands
> %🇦🇱 Albania%,🇦🇱 Albania
> %🇩🇿 Algeria%,🇩🇿 Algeria
> %🇦🇸 American Samoa%,🇦🇸 American Samoa
> %🇦🇩 Andorra%,🇦🇩 Andorra
> %🇦🇴 Angola%,🇦🇴 Angola
> %🇦🇮 Anguilla%,🇦🇮...

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [July 21, 2022, 2:59pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/27 "2022-07-21T14:59:05Z")

</div>

Nice, whats your definition of a country

---

<div class="post-metadata">

### Author: ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [July 21, 2022, 3:29pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/28 "2022-07-21T15:29:37Z")

</div>

> [@samwagner](#):
>
> whenever they rearrange the world again. 🙂

That may happen sooner than later! 🤪

I am not understanding what I am seeing. Am I supposed to see flags? Some of the rows in Column A seem to be empty, but there is data in Column B. Perhaps there are some hidden columns?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ec4767dd988f72fa9ab5580f398cd7a923915c6.png)

---

<div class="post-metadata">

### Author: ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [July 21, 2022, 3:34pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/29 "2022-07-21T15:34:52Z")

</div>

I also get an error when trying to copy the template…  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94240f3c19e7ce27dd80787cf25355e8d963e680.png)

---

<div class="post-metadata">

### Author: ![samwagner](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@samwagner](https://community.glideapps.com/u/samwagner)
#### Post date: [July 21, 2022, 3:45pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/30 "2022-07-21T15:45:59Z")

</div>

Hm,

cannot replicate that. When I open the link in any private browser window, it opens like it should.

There also is no second column.

 ![Screenshot 2022-07-21 at 17.42.10](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9ad49ae6dd4cccd6e6773e595b79ce9372bf0bee.png)

Here’s the link again.

> **[Countries and Flags](https://docs.google.com/spreadsheets/d/1IOgn69ZIAwDdhpyEsJ3EU23FLD5PKx5OqH5_v0LZ1Jg/edit?usp=sharing)**
>
> Countries
> 
> Raw,Country
> %🇦🇫 Afghanistan%,🇦🇫 Afghanistan
> %🇦🇽 Åland Islands%,🇦🇽 Åland Islands
> %🇦🇱 Albania%,🇦🇱 Albania
> %🇩🇿 Algeria%,🇩🇿 Algeria
> %🇦🇸 American Samoa%,🇦🇸 American Samoa
> %🇦🇩 Andorra%,🇦🇩 Andorra
> %🇦🇴 Angola%,🇦🇴 Angola
> %🇦🇮 Anguilla%,🇦🇮...

---

<div class="post-metadata">

### Author: ![samwagner](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@samwagner](https://community.glideapps.com/u/samwagner)
#### Post date: [July 21, 2022, 3:48pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/31 "2022-07-21T15:48:55Z")

</div>

Hove none. May others decide.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 21, 2022, 5:56pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/32 "2022-07-21T17:56:45Z")

</div>

The 2 character country codes are special characters (not normal letter) that when combined are converted to a flag emoji. Check out the country flags at [🎌 Flags —&nbsp;List of Emoji Flags to Copy and Paste](https://emojipedia.org/flags/). Some older versions of windows don’t have the latest unicode releaset, so some emoji are not available. I’ve noticed this with colored dots that work fine on my phone and home computer, but doesn’t translate to the actual emoji on my work computer, which is on a long term support windows version. I see similar issues with flags, which I believe are a pretty recent addition to unicode. Plus I think I read somewhere that microsoft doesn’t fully support flag emoji due to some countries recognizing other territories as countries, and some not. It’s all complicated due to unicode and geo-political differences.

> **[Emoji country flags and their codes](https://apps.timwhitlock.info/emoji/tables/iso3166)**
>
> Emoji characters for all countries in ISO-3166-1

> **[The Past and Future of Flag Emoji](http://blog.unicode.org/2022/03/the-past-and-future-of-flag-emoji.html)**
>
> Emoji Flags are dead, long live Emoji Flags 🏁 🏁 🏁 By Jennifer Daniel, Unicode Emoji Subcommittee Chair With Emoji 16.0 submiss...

[https://answers.microsoft.com/en-us/windows/forum/all/flag-emoji/85b163bc-786a-4918-9042-763ccf4b6c05](https://answers.microsoft.com/en-us/windows/forum/all/flag-emoji/85b163bc-786a-4918-9042-763ccf4b6c05)

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [July 21, 2022, 6:00pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/33 "2022-07-21T18:00:45Z")

</div>

> [@David\_Gabler](#):
>
> I am not understanding what I am seeing. Am I supposed to see flags? Some of the rows in Column A seem to be empty, but there is data in Column B. Perhaps there are some hidden columns?

Hola David,

Are you using Windows on your PC to work on this spreadsheet right?

If so, Microsoft has long warned that they will not display country flags to avoid conflicting country claims. 🙄

Saludos!

---

<div class="post-metadata">

### Author: ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [July 21, 2022, 6:28pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/34 "2022-07-21T18:28:42Z")

</div>

> [@gvalero](#):
>
> Microsoft has long warned

Yes, Windows 10. I tried it on my Android and it seems to work right. Guess this solution won’t work for Pages.

[Previous page](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467.md?page=1)
