Skip to main content
Solved

CSV translation upload fails due to semicolons in auto-generated HTML/CSS formatting

  • September 22, 2026
  • 1 reply
  • 12 views

sanjay.mahamagamoorthy
Level 4
Forum|alt.badge.img

Running into an issue with the translation CSV workflow and wondering if anyone has seen this.

When exporting translations, some entries contain HTML and CSS that the editor generates automatically — happens as soon as you use standard formatting like bold, font color, or font size in a textbox. The output ends up looking something like:

<div><strong style="color: rgb(0, 0, 0);">Some text here.</strong></div>

Those inline styles contain semicolons, and re-uploading the CSV fails because of them — even if nothing was changed in the file. The only thing that actually unblocks the upload is deleting the entire row, reference tag and translation both. Clearing just the translation value and keeping the reference tag doesn't work, the upload still fails.

The problem is that this affects a large number of entries, so every sync cycle means manually identifying and stripping out all the styled rows before the upload goes through. Is there any way to allow semicolons in these entries, or a cleaner path for handling this?

Best answer by yingtao.gu13

From what I can tell, the semicolons causing the failure come from CSS that Celonis generates automatically when standard editor formatting is used — so there's no way to avoid it on the content side.

The only workaround that seems to work: delete the full row from the CSV before uploading, both the reference tag and the translation. Removing just the translation value isn't enough, the entire row needs to go.

1 reply

yingtao.gu13
Level 8
Forum|alt.badge.img+12
  • Level 8
  • Answer
  • September 22, 2026

From what I can tell, the semicolons causing the failure come from CSS that Celonis generates automatically when standard editor formatting is used — so there's no way to avoid it on the content side.

The only workaround that seems to work: delete the full row from the CSV before uploading, both the reference tag and the translation. Removing just the translation value isn't enough, the entire row needs to go.