Are you frustrated because data loading rich text field data isn’t loading right in lightning? And the only way to fix it is to manually edit each record and save it? But you’d rather data load it all? Have no fear! We have a converter!
- Run this Export query in Dataloader: SELECT Id, YourRichTextField__c FROM YourObject__c
- Paste the contents of the CSV file into the input below
- Click the “Convert” button
- Paste the contents of the output below into your CSV file
- Import that file with Dataloader
Convert CKEditor Values => Quill Editor Values