Table tool writes output as HTML text in Excel

[mtuwanax]

Hi All,

I'm having issues with using the Table tool to write output to excel. When I run the flow and use the browse tool I see that the pivot table is created correctly, but when I check the excel file, the pivot table is a HTML string, please see attached pictures of the two outputs.

May I kindly ask you to help resolve this issue?

  

[Jean-Balteryx · Accepted solution]

Hi @mtuwanax,

I found this post which could help you : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-Tool-creates-HTML-style-output-...

[AkimasaKajitani · Accepted solution]

Hi @mtuwanax 

If you use the Table tool, you should use Rendering tool to output data.

It is not possible to Output data tool to output the result of Table tool.

[apathetichell · Accepted solution]

yes - this is what happens when you attach a table to an output data tool... attach a render tool and it'll work fine... note - render too will re-write the entire file each time you use it.

[mtuwanax]

Hi all,

Thank you all for your responses, each approach solved my issue, and I found out that the best solution was to use the cross tab tool, and directly write the output to an excel file without having to use the table tool.