In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start 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
binu_acs
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

binu_acs
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