# Retaining Rich Text **URL:** \ **Category:** Ask for Help\ **Created:** [February 1, 2022, 9:12pm UTC](https://community.glideapps.com/t/retaining-rich-text/37991 "2022-02-01T21:12:33Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Michael\_Kagan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_kagan/32/1146_2.png) [@Michael\_Kagan](https://community.glideapps.com/u/Michael_Kagan)\ **Post date:** [February 1, 2022, 9:12pm UTC](https://community.glideapps.com/t/retaining-rich-text/37991/1 "2022-02-01T21:12:33Z")
I have created an excel document by copying and pasted formatted text (e.g.,bold and italic) from a word document. I then open the excel document in google sheets. It is the google sheet I am using as the data for my app. is there a way to bring formatted text into google sheets from excel? Thanks for your help with this. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 2, 2022, 1:46am UTC](https://community.glideapps.com/t/retaining-rich-text/37991/2 "2022-02-02T01:46:28Z")
So you uploaded the Excel document to Google Drive and open it as a Google Sheet? I don’t think you have a way to retain the format that way. Have you tried copy pasting directly to an empty sheet instead of through uploading a file? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 2, 2022, 2:22am UTC](https://community.glideapps.com/t/retaining-rich-text/37991/3 "2022-02-02T02:22:51Z")
If you’re using it with Glide, why does it matter how it’s formatted in the Google Sheet? 🤔 ---
**Author:** ![Michael\_Kagan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_kagan/32/1146_2.png) [@Michael\_Kagan](https://community.glideapps.com/u/Michael_Kagan)\ **Post date:** [February 2, 2022, 3:36am UTC](https://community.glideapps.com/t/retaining-rich-text/37991/4 "2022-02-02T03:36:00Z")
Didn’t try that…thanks for the suggestion…it works; i.e., I can copy an retain text formatting from excel to gsheets. two issues: 1. I try to display it in my app using a rich text field, but no formatting comes through. 2. glide is reformatting the data inside of glide so that when I look at the data in the glide display of the sheet it looks like all the fields are choices (like a choice field in airtable) weird. Another issue from the copy point of view is that I have A LOT of data that I am bring across, so I actually add another step in my transformation from word and that is from excel to airtable. Copy and pasting doesn’t seem like a workable process with so much data ---
**Author:** ![Michael\_Kagan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_kagan/32/1146_2.png) [@Michael\_Kagan](https://community.glideapps.com/u/Michael_Kagan)\ **Post date:** [February 2, 2022, 3:41am UTC](https://community.glideapps.com/t/retaining-rich-text/37991/5 "2022-02-02T03:41:40Z")
good question. how can I get formatted data into glide, markdown? the data I am working with in Word has the formatting and I want to retain that when I use that data in my app. Any suggestions on how to get data from word to glide that preserves the formatting? As you already know I have used excel and on occasion I have also moved the data into airtable. I am open to suggestions. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 2, 2022, 3:47am UTC](https://community.glideapps.com/t/retaining-rich-text/37991/6 "2022-02-02T03:47:26Z")
If it’s valid markdown, you should be able to display it in a rich text component. Just one thing to note is that when Glide syncs with your Google Sheets, it only syncs the data - the contents of the cells - not any formatting that might have been applied for display in the Google Sheets. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 2, 2022, 4:01am UTC](https://community.glideapps.com/t/retaining-rich-text/37991/7 "2022-02-02T04:01:27Z")
> [@Michael\_Kagan](#): > > - I try to display it in my app using a rich text field, but no formatting comes through. > - glide is reformatting the data inside of glide so that when I look at the data in the glide display of the sheet it looks like all the fields are choices (like a choice field in airtable) Could you provide a couple of screen shots that show: - How the data looks in the Google Sheet - How it looks in the Glide Data Editor - How it looks when you try to display it in a Rich Text component ---
**Author:** ![Michael\_Kagan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_kagan/32/1146_2.png) [@Michael\_Kagan](https://community.glideapps.com/u/Michael_Kagan)\ **Post date:** [February 2, 2022, 11:58am UTC](https://community.glideapps.com/t/retaining-rich-text/37991/8 "2022-02-02T11:58:47Z")
Will send something along later today. ---
**Author:** ![Michael\_Kagan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_kagan/32/1146_2.png) [@Michael\_Kagan](https://community.glideapps.com/u/Michael_Kagan)\ **Post date:** [February 20, 2022, 2:08pm UTC](https://community.glideapps.com/t/retaining-rich-text/37991/9 "2022-02-20T14:08:30Z")
@Darren_Murphy…apologies for not being my word and sending along a screenshot. The issue is now moot as I have the data stored as rich text in airtable (where it was living before moving it into GS so I could create an app from it). With the introduction of the airtable connection my issue has disappeared as glide recognizes and retains the formatting of the text inside of airtable 😂 Thank you, again, for being so quick to lend a hand.