In Salesforce, when exporting reports that contain formula fields that render HTML output — such as hyperlinks, email addresses, or images — the exported file (CSV or Excel) contains the underlying HTML tags rather than the rendered output.
This occurs because the Salesforce report export renders formula output values exactly as they appear in the user interface. When a formula renders HTML, those HTML tags are included in the export.
Example:
A formula field using the HYPERLINK function — for example, a formula that produces a hyperlink to " with the display label "Google" and target "_self" — displays as a clickable link labeled "Google" in the Salesforce user interface.
When the same report is exported, the export file contains the raw HTML markup: an anchor element with href set to " target set to "_self," and inner text "Google" — rather than just the word "Google."
Formula
HYPERLINK("https://www.google.com", "Google", "_self");
Export Result
<a href="http://www.google.com" target="_self">Google</a>
This is expected behavior in Salesforce. The report export renders the formula output exactly as it appears in the user interface, including any HTML markup from HYPERLINK, email, or image formulas.
To get a report export that contains only the URL value or email address (without HTML tags), use the corresponding Salesforce custom field types instead of formula fields:
Using dedicated Email and URL field types instead of HYPERLINK formula fields ensures the exported report contains clean, readable values.
000382893

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.