File format conversion

[TandelGouravi]

Hi,
How to convert the file format from one way to another (eg. .csv to .xls) in the beginning of the workflow and use it in the same flow(.xls)
for further transformation?

Thanks in advance

-Gouravi

[LordNeilLord]

Hey @TandelGouravi 

To convert the file format, all you need to do is input as one file type (i.e. csv) and output as another (i.e. xlsx)

There are few limitations to how you can import and export data

[ismailhab]

Hi,

May be this solution can help with this tool, its working step by step.

Ismail,

[carlosteixeira]

Hi @TandelGouravi 

I do not know if I understand exactly what you want, this workflow is working. It transforms the CSV into an XLSX and uses it in the same workflow.
I do not know how much data your workflow has.
Let me know if it does not work for you.

[estherb47]

Hi @TandelGouravi 

First, I'd ask why do you need the file to be in .xls format for using in Alteryx? You can, at any point in your workflow, save the data out to an excel file with an Output Data tool.

Assuming that the data is streaming in properly from the csv, you can continue to process it with Alteryx without saving and re-importing. Select tools and autofield are helpful with changing the data type from string, and just keep on going from there.

Let me know if this helps/if you have more questions.

Cheers!

Esther

[adarsh2707]

Hi 

I have a question. Can I convert a .tde file to a xlsx file.

I wish to convert the .tde file created by the alteryx server usage report to an excel file

[chloeley]

Can I change the file to xlsx excel format basically, from the start? 

i want to work with a xlsx format in my workflow but the original data is in csv form 

the csv form merges the columns all into one column and i dont want to text to column so many times 

[jdminton]

Hi @chloeley, Just so you're aware, this is a really old thread that you are replying to with a similar question. Kudos to you for searching first, but you'll likely get better and faster responses by creating a new post that you can also mark as solved.

To answer your question, there really is no need to convert it to Excel first. In the CSV settings, you will need to assign a delimiter. That can vary in different CSV files, but is typically a comma, a tab, or a pipe | character. You can usually see this if you open the csv file with notepad or a similar text viewing tool.  If you look at the configuration below for an input tool with a csv file, the delimiter is currently set to \n which is a new line character. That means it will put all of the data in one field. It might also be \0 which indicates no delimiter. If you change that to the correct delimiter, you should get the fields in separate columns. In this example, it should be a comma delimiting the fields. Feel free to create a new post with your configuration settings and an example of what the data looks like if you need more help.