When I have a list type measure (either LookML defined or custom measure), it shows up as expected on explore and visualization:
but when downloading data to Excel it exports as <a href="…>.
The only workaround I can find is to create a table calculation that formats it with to_string(), but I can’t force all users to change their existing dashboards to do this.