Is there a way to convert CSV to XLSX without losing formatting?

Question

So I have a workflow  that is used to reformat some excel files but it only works with XLSX files so i need to go open each file then save as XLSX then import. I was hoping there would be a way to skip that. Maybe even adding it to the beginning of the other workflow some how. Sort of an import CSV save as XLSX then import that XLSX.

apathetichell · Answer

You may also want to use a download tool directly in Alteryx so the filename is less troublesome - you can then work with the data and output and a more dynamic date - like the date could be appended to polling,,,

mceleavey · Answer

Hi @rmartori ,

This is because this is not a .csv format. You have no comma delimiters. Can you please post the original data with a description of what you're trying to do?

Thanks,

M.

rmartori · Answer

I am not sure why but whenever we input it as a CSV file it dumps everything into one column and I need to deliminate it out.

But I don't have anything to deliminate it by that wont ruin the workflow. We have a workflow that works if it is excel Basically the file itself looks like this.

Question #QuestionAnswer choiceAnswersResultsPercentagesCorrect AnswersJohn DoeJane SmithRobert Robertson1Is the sky bluea  True 13/6520%    1Is the sky blueb  False 45/6569%X XX1Is the sky bluecNo Answer 7/6511% X         0%100%100%

However when I import the CSV file it imports everything into one column.

Question # Question Answer choice Answers Results Percentages Correct Answers Miguelina John Doe Jane SMith Robert johnson         1 Is the sky blue a True 13/65 20% X X X X X X X X X X X X X         1 Is the sky blue b False 45/65 69% X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X         1 Is the sky blue c No Answer 7/65 11% X X X X X X X X X X X X X X X X

The workflow takes the multiple XLSX files, one for each question. And makes it into a file formatted like below.

NameEmailQuestion 1Question 2Question 3Question 4John Doe

john.doe@test.comCABAJane SmithJane.Smith@test.comBBBARobert RobertsonRobert.Robertson@test.comBCBB

The workflow itself works. I am just trying to find a way to fix the CSV part to make it just a touch quicker.

It doesnt help that the reports download the CSV files as polling[1].csv which means I need to rename them as well since excel doesnt like brackets.

I just am trying to find a way to convert the csv into excel without losing the above format, so far the only way I have been able to do that is by literally loading each file into excel and then saving as XLSX

The problem is the size of the table will vary from report to report, sometimes 5 people some times 10 sometimes 100 some times the questions arent true false sometimes they are actually multiple choice with 5 options, or 4, etc.