Exporting Reports with Links

[angielawrence]

We have a Report that we are exporting with multiple HTML links in a field, but when we open it in Excel, it's just text. I updated the valueformat to be HTML, but then the data doesn't pull in. Here's the Text Mode data as it was by default, I think I missed something. We want them to be clickable links in Excel as well.

displayname=
linkedname=direct
namekey=Photos Uploaded
querysort=DE:Photos Uploaded
textmode=true
valuefield=Photos Uploaded
valueformat=customDataLabelsAsString

Thank you!

[Kurt_Jones · Accepted solution]

See if adding/updating these items below, helps:

valueformat=HTML

link.url=customDataLabelsAsString(Photos Uploaded)