How to paste rich text into notepad or markdown

I’m really excited about the new Notepad and Markdown widgets for displaying rich text. I have a Google Sheet which contains formatted text that I want to bring over, but when I paste into a text column in Grist the formatting disappears. Is there a way to paste rich text into Grist? I have thousands of entries to update, so ideally I would want to bulk paste the text, not paste one entry at a time.

No one? No way around this?

Hi Victor!

I apologize for the delay in responding. We somehow missed your initial post. Unfortunately, there is no good way to paste rich text into Grist. This is something we would like to improve in the future. In the meantime, if the entire column is formatted in the same way, you could use formulas to add the formatting to the text. I created an example at the link below:

Copy/Paste the plain text into Grist (or import) then you can create a new formula column that adds formatting as a string. For example, to bold text in markdown, you surround the text with two asterisks, like you see in the screenshot below. Then, have the markdown widget point to this formula column to show the formatted text.


Again, I apologize for our delay in response! I hope this workaround helps. Please let me know if you have any other questions.


Thanks for the reply. Unfortunately that doesn’t help me, as I’m looking to reproduce text that has a mix of different formatting.