Converting .CSV to xlsx - Bunch of files

[sriniprad08]

Hi Team,

Hope you are well. 

I need help. I have a folder with .csv files. Is there a macro which can append all the .csv files and convert them into .xlsx format ?

Please let me know ,

thanks,

Sri

[Hamder83]

Hi 

This should do it 🙂 

You change the directory to match your directory 🙂 

And you can right click and open the macro so the delmiter matches your data 🙂 

[atcodedog05]

Hi @sriniprad08 

Just adding a guide on how to downgrade packaged workflows and macros 

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

Hope this helps : )

[sriniprad08]

Hi @Hamder83 ,

Thank you so much. Its working. However all the columns are coming in the single row. how to get the data in the separate column please?

thanks,

Sri

[sriniprad08]

Hi @atcodedog05 ,

Thank you for the timely input :). Very useful.

Regards,

Sri

[sriniprad08]

 Hi @Hamder83 ,

Please let me know your thoughts,

[Hamder83 · Accepted solution]

Hi 

if you right click the macro and set the delimiter to comma as in your input file 🙂 

[sriniprad08]

Hi @Hamder83 ,

Thank you very much. Very helpful.

Cheers,

Sri