Looking to make your Google Sheets more appealing for younger learners? Need access to thousands of emojis, symbols or icons? Unicode is here to help.
Follow along with the attached activity here: LINK to Sample file
You are free to use a copy of this file with your students and colleagues
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Unicode has thousands of symbols each with a uniquely assigned code. These codes can be interpreted by programs such as Google Sheets as long as we make sure the program understands the context.
In order for sheets to correctly display these Characters or ‘Chars’ we have to use the formula CHAR as seen here:
=CHAR(table_number)
In the spreadsheet, first make sure you navigate to the DIY sheet at the bottom of the file. (If you are using your own sheets, this is not necessary.)
As you can see from the image above, I have added in a range of images all found in unicode.
Adding chars
Navigate to the cell where you would like to see your character or char added. Here you type the formula:
=CHAR( )
All we need to do now is add the missing table_number or reference number in Unicode. In order to get this number we can use any website that gives us the Unicode tables.
Linked in the file and here, is one of my favourite websites for this Unicode Search.
On the website you can search for any symbol or image you may need.
Copy the ID number shown on the website and paste this into your formula.
A preview of the symbol/emoji will show at the top.
Now you can repeat this step multiple time to insert all the images needed.
If you prefer want to see these steps in a video format, a YouTube video walking you through this activity is attached below:
You’re so awesome! I don’t believe I have read a single thing like that before. So great to find someone with some original thoughts on this topic. Really.. thank you for starting this up. This website is something that is needed on the internet, someone with a little originality!
Thank you! Glad you liked it. I made https://sethideclercq.com/tools/emojisearch.html to make making the formulas even easier!
I genuinely appreciate your help in coming up with such good stories and presenting them in such a great sequence.
Güzel aydınlatıcı makale için teşekkürler daha iyisi samda kayısı umarım faydalı çalışmalarınızın devamı gelir.
I like the efforts you have put in this, regards for all the great content.
Thank you! Appreciate the comment
naturally like your web site however you need to take a look at the spelling on several of your posts. A number of them are rife with spelling problems and I find it very bothersome to tell the truth on the other hand I will surely come again again.
Apologies about the spelling errors you have found. If there are any that jump out at you, by all means let me know on that particular post or article. I’m always happy to make changes where needed. Thank you. I hope that even with these errors, you still find value in the posts.
very informative articles or reviews at this time.
Good post! We will be linking to this particularly great post on our site. Keep up the great writing
This is my first time pay a quick visit at here and i am really happy to read everthing at one place
There is definately a lot to find out about this subject. I like all the points you made
I truly appreciate your technique of writing a blog. I added it to my bookmark site list and will
Very well presented. Every quote was awesome and thanks for sharing the content. Keep sharing and keep motivating others.
Great information shared.. really enjoyed reading this post thank you author for sharing this post .. appreciated