Issue with .xls having a ' (single quote in front of all data)

Having an issue when doing an output to .xls

Each column has that single quote ' and it is hidden as you see it can only be seen in the highlighted area but not in the data cell. and i need the file format to be .xls but this hidden character has been failing to upload due to this character. any help would be greatly appreciated!

I am at a loss and any help would be appreciated!

- Michael Johnson

Workflow

Regex

Output

Data Investigation

Accepted answers

If at all possible, save from Alteryx as an .xlsx format, and then try using Excel to save as an .xls.

Easiest solution that has worked in the past for me.

Cheers!

Esther

All comments

Sorry, not quite sure what you are looking to achieve.

Is this that your input data has these or the data you output from Alteryx?

output from alteryx to an .xls format

If at all possible, save from Alteryx as an .xlsx format, and then try using Excel to save as an .xls.

Easiest solution that has worked in the past for me.

Cheers!

Esther

Yes, i currently do that and i can confirm it works.

But i do want to remove that manual step 🙂

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15880

MarqueeCrew 13708

apathetichell 13703