ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

XLS output creating apostrophes at the beginning of string columns

gdefazio
5 - Atom

Hi all,

I am converting a cvs file to an xls within my workflow, and it is returning columns with ' before strings only. When I attempt to run the file back through Alteryx, it does not show the apostrophes before the strings and only shows when I open the excel file. The output looks normal when in a regular xlsx file. 

Example: 

xlsx output: 4R47223
xls output: '4R47223

1 REPLY 1
alexnajm
19 - Altair
19 - Altair

I'd recommend outputting to .xlsx - .xls is a legacy file type that will no longer be supported going forward! Whatever system needs it as .xls, I would push back and see if you can do .xlsx

Labels
Top Solution Authors