Skip to main content
Question

Save to spreadsheet showing HTML characters in export

  • January 2, 2020
  • 0 replies
  • 85 views
When my team uses a notes field, and we export their work to Excel using the save as spreadsheet function, HTML characters appear in this field in the spreadsheet.  Is there a way for their notation to export without these characters?  Photos depict what the font looks like in QuickBase, and then when a spreadsheet is created.

------------------------------
Teresa Maviglia
------------------------------
This topic has been closed for replies.

  • AustinK
  • Registered
  • January 2, 2020
You are just seeing what is actually in the field. That is a rich text field right? The browser interprets the HTML you have in there but Excel isn't able to. Is Notes - Customer a formula field by any chance? Or is the information entered into there and the formatting changed by whomever is entering it at the time?

If it is a formula field then you could possibly just have a secondary formula calculate to the same information without all of the HTML in there and have that field on the report instead. That should show up in Excel better than what you have. Another option would be, is the rich text field necessary? I know it is nicer looking. If they were just entering this into a regular text box it should not have the formatting issues you are seeing even if they have multiple lines.

Maybe someone else knows something else more helpful but those would be my suggestions.
Terms & ConditionsAccessibility statement