Free Trial

Alteryx Designer Desktop Discussions

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

How to import a folder of .xlsx files and save each file as .csv file in the same folder

TimOzirsky
8 - Asteroid

Will someone please let me know How to import a folder of .xlsx files and save each file as .csv file in the same folder?
I found the Directory tool to read the folder and now what.

Thank you

4 REPLIES 4
binuacs
21 - Polaris

@TimOzirsky one way of doing this with the batch macro

image.png

TimOzirsky
8 - Asteroid

I am sorry, that didn't work for me.
I should have said that I want the work flow to open each xlsx file and save each file as a csv file using the xlsx file name in the same folder.
For example, open B0-0.xlsx and save it as B0-0.csv.

Thank you

binuacs
21 - Polaris

@TimOzirsky That is exactly the above workflow does, what is the error you are facing?

TOzirsky
7 - Meteor

I can't find any files created by the macro. Do I need to edit a path somewhere or ?

Thank you

Labels
Top Solution Authors