render as html

[srijani-smsrc]

so i have used render as html , and i have put span in custom sql metric in table chart m but when i am downloading as excel or csv , the value and the span code is getting downloaded not just the value

@dosu

[dosubot[bot]]

This is expected behavior — "Render as HTML" only controls how values are displayed in the browser. When you export to CSV/Excel, Superset pulls the raw query results directly, so your <span> tags come through as-is in the export [1].

Recommended fix: Use Conditional Formatting instead

If your goal is just coloring values, use Superset's built-in Conditional Formatting (under the "Customize" tab in the Table chart). This applies colors natively without injecting HTML into the metric, so exports will contain only clean values.

Other workarounds:

1. Post-process in Excel — Use Find & Replace or =SUBSTITUTE() to strip the span tags after export.
2. Backend modification — If you want to strip HTML globally for all exports, you can modify superset/common/query_context_processor.py in the get_data() method by adding regex-based HTML stripping before the CSV/Excel conversion:

import re

# Add after verbose_map processing, before CSV/Excel conversion:
for col in df.columns:
    if df[col].dtype == "object":
        df[col] = df[col].apply(
            lambda x: re.sub(r'<[^>]+>', '', x) if isinstance(x, str) else x
        )

[1]

The conditional formatting approach is the cleanest solution since it separates styling from data entirely.

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.