When I write a flag emoji like 🇨🇳 into a Google Sheets cell it displays as text and not as a flag when I am using Google Chrome or Microsoft Edge in Windows 10. Is there a way to display it as a flag with this setup?

Here is a sample spreadsheet which replicates the issue: https://docs.google.com/spreadsheets/d/1Q9F237ay3IMYh-qULXSpQUx4-0_cPj-xoQWeQ2_-ooE/edit?usp=sharing

  • When I copy and paste 🇨🇳 to a Google Sheet, the flag displays in the cell just fine. Tested on Safari on macOS. Consider sharing a publicly editable sample spreadsheet where the issue can be reproduced. There is a blank sheet maker that lets you share safely. May 25 at 11:00
  • @doubleunary thank you for the input. I have added more information about my set-up and a sample spreadsheet. May 25 at 13:45
  • 1
    I see the flags and country names in cells B10:F10 just fine, and the flags also show fine in the X axis labels in Chart1. It is unlikely that the issue is with Google Sheets. Try with another browser, and check your system for broken fonts and the like to identify what the problem is. May 25 at 21:16
  • @doubleunary have you tried it in Google Chrome on Windows 10? May 26 at 11:39
  • I have the same issue in Microsoft Edge. May 26 at 11:41


Browse other questions tagged or ask your own question.