In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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