12

I have designed a schedule in Google Sheets that uses emoji to indicate the character of each days activities. They display perfectly in Google Sheets. I want to physically print the sheet but when I try to export to PDF they disappear leaving behind the dreaded crossed boxes. I have also tried to export to HTML and then print the resulting page. This does preserve the emoji but badly breaks the layout on print.

My question is this-- can it be done? Can I print emoji from google sheets or will I have to redo my work in a different program.

1
  • Hey, seems like an encoding issue, not sure what can be done. Try maybe some picture instead of emojis ? here's an example. You can check for corresponding image at emojipedia.org
    – pjmg
    Aug 6, 2019 at 20:58

6 Answers 6

3

Try using image instead of emojis?

here's a sample

=IMAGE("https://s3.amazonaws.com/pix.iemoji.com/images/emoji/apple/ios-12/256/face-with-tears-of-joy.png")

Links of images come from emojipedia.

4

I exported the document to excel and it shows the emojis and then they print from there.

1
  • This doesn't work in my old version of Excel 2007, but perhaps it does in more recent versions.
    – Simon East
    Oct 7, 2022 at 10:08
2

if you don't have to choose exact font, emoji containing cells that are formatted with "Inconsolata" or "Sawarabi Mincho" are perfectly exported to PDF.

2
+500

Solution

As I explained in this Answer

  • Export your Sheet as Web page (.Html)

enter image description here

  • Open with a browser and save as a PDF
  • Open the PDF with a PDF editor or Illustrator and delet columns and rows grids

enter image description here

2

I've reported this as an issue here: https://issuetracker.google.com/issues/241147770

Please vote the issue if you want Google to solve it.


Note: when I use fonr Noto Emoji emojis are printed, but they are not colored.

enter image description here

To use this font select 'More Fonts' option.

0

The solution for me was instead of choosing to Download PDF via "File > Download > PDF", try the following: "File > Print > Next > Destination > Save As PDF" (click the dropdown showing your printer). This will export with the emojis.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.