How to convert rich text into HTML for CSV upload?
Hi everyone, I have a bit of an issue,
We're trying to batch import spreadsheets to HubDB, mainly from Google sheets.
However, downloading CSV files from Google Sheets, special characters such as ø and ß are converted into nonsensical text. We also lose the ability to format our 'description' text with bold text, italics, lists, and even new lines.
My solution to this problem was to manually convert text into HTML using online converters, meaning we have inline HTML tags in cells.
However, I realise if I insert rich text formatting directly into HubDB UI and then download as CSV, it features inline HTML tags - but there doesn't seem to be a way to utilise HubSpot's conversion as I can ONLY upload CSV I build myself?
Is there a way to convert rich text into HTML/CSV using HubSpot without having to insert it directly into the table?