Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

Converting .CSV to xlsx - Bunch of files

sriniprad08
11 - Bolide

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

7 REPLIES 7
Hamder83
11 - Bolide

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
22 - Nova
22 - Nova

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
11 - Bolide

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?

 

sriniprad08_0-1634034537315.png

 

thanks,

Sri

sriniprad08
11 - Bolide

Hi @atcodedog05 ,

 

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

 

Regards,

Sri

sriniprad08
11 - Bolide

 Hi @Hamder83 ,

 

Please let me know your thoughts,

 

Hamder83
11 - Bolide

Hi 

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

 

Hamder83_0-1634036729553.png

 

sriniprad08
11 - Bolide

Hi @Hamder83 ,

 

Thank you very much. Very helpful.

 

Cheers,

Sri

Labels